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 creating the cluster.

  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 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 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. 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 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 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 access cluster logs, enable logging. Logging uses part of the cluster's computing resources.

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

  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 edit them, click Edit. We recommend changing setting values only when necessary — incorrectly selected values can render the cluster inoperable or degrade its performance.

Administrator password

  1. Enter the 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. 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.