Skip to main content

Create a ClickHouse® cluster

  1. In the control panel, in the top menu, click Products and select Cloud 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 the 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 a cluster to an existing private subnet, in the Subnet field, select an existing subnet.

  2. To create a new private subnet:

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

    2.2. Optional: change the subnet CIDR.

    2.3. Optional: change the network in which the subnet will be created — you can select an existing network or create a new one. You cannot change the network after creating the cluster.

Optional: Security

Select security groups to filter inbound and outbound cluster traffic.

If the Security section 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 name of the node group — 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. There can be no more than ten nodes in a shard.

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

    Public IP addresses are automatically assigned to all shard nodes — a dedicated address for each node.

  7. Optional: 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, on 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. It is added automatically if the cluster contains 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 some of the cluster's computing resources.

  1. Select the Collect technical cluster logs to 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 default values for DBMS settings or change them, click Edit. We recommend changing setting values only if necessary — incorrectly configured values may cause the cluster to become inoperable or degrade 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 to connect to the cluster. You cannot view the password in the control panel, but you can change it.

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