Skip to main content

Create a ClickHouse® cluster

Last update:

  1. In the Dashboard, on the top menu click Products and select Managed Databases.

  2. Click Create cluster.

  3. Enter the cluster name.

  4. Select a location. You cannot change the location after the cluster is created.

  5. Select the DBMS — ClickHouse.

  6. Select a ClickHouse® version.

  7. Fill in the following sections:

  8. Check the price of the Managed Databases cluster.

  9. Click Create cluster.

Network

A ClickHouse® cluster can only be connected to a private subnet. You can create a new subnet or add the cluster to an existing one.

  1. To add an existing private subnet, in the Subnet field, select an existing subnet.

  2. To add a new private subnet:

    2.1. In the Subnet field, select New private subnet.

    2.2. Optional: change the subnet CIDR.

    2.3. Optionally, change the network where the subnet will be created — you can select an existing network or create a new one. You cannot change the network after the cluster is created.

Optional: Security

Select security groups to filter incoming and outgoing cluster traffic.

If the Security block is missing, traffic filtering (port security) is disabled in the cluster network. If traffic filtering is disabled, all traffic will be allowed.

Node group configuration

  1. Optional: change the node group name — shard.

  2. Select a configuration line.

  3. If you selected a line with custom configurations, select the disk type and specify the number of vCPUs, RAM size, and disk size.

  4. If you selected a line with fixed configurations, select a configuration.

  5. Specify the number of nodes in the shard. A shard can contain no more than ten nodes.

  6. Optional: to make shard nodes accessible from the internet, attach public IP addresses to them:

    • if you have selected an existing private subnet, select the Connect public access checkbox. The private subnet must meet the requirements;
    • if you are creating a new private subnet, attach public IP addresses after the cluster is created.

    A separate public IP address will be automatically assigned to each shard node.

  7. Optionally: specify the shard weight. Available values are from 0 to 65535.

  8. Optional: add additional shards:

    8.1. To add a shard with the same configuration, in the shard card click .

    8.2. To add a shard with a different configuration, click Add shard and repeat steps 1–8.

ClickHouse Keeper configuration

The ClickHouse® Keeper node group is required for all cluster configurations, except for one. It is added automatically if the cluster has a shard with two or more nodes or multiple shards. ClickHouse® Keeper is removed automatically if the cluster consists of one shard with one node.

  1. Optional: change the node group name.

  2. Select a configuration line.

  3. If you selected a line with custom configurations, select the disk type and specify the number of vCPUs, RAM size, and disk size.

  4. If you selected a line with fixed configurations, select a configuration.

Optional: Logging

To have access to cluster logs, enable logging. Logging uses part of the cluster's computing resources.

  1. Select the Collect technical cluster logs in the log service checkbox.

  2. Select a log group or create a new one.

  3. Optional: if you selected a new group, change its name.

Optional: DBMS settings

To view the default values of DBMS settings or to change them, click Change. We recommend changing setting values only if necessary—incorrectly chosen values may cause the cluster to become inoperable or reduce its performance.

Administrator password

  1. Enter a user password or click Generate. The password must contain:

    • at least 12 characters;
    • uppercase and lowercase Latin letters;
    • digits;
    • special characters — !?@$%&*..

  2. Copy and save the user password—it is required for connecting to the cluster. The password cannot be viewed in the Control Panel, but it can be changed.

ClickHouse® is a registered trademark of ClickHouse, Inc. https://clickhouse.com.