Skip to main content

Create a ClickHouse cluster

  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 in which the subnet will be created — you can select an existing network or create a new one. After the cluster is created, the network cannot be changed.

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 have no more than ten nodes.

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

    • if you 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. Values from 0 to 65 535 are available.

  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 single-node ones. 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 a single 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 a portion 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 change them, click Change. We recommend changing setting values only when necessary; incorrectly selected values can render the cluster 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.