Get started
Log in
Yandex Managed Service for ClickHouse

Changing cluster settings

After creating a cluster, you can:

Changing the host class

If you don't have the Yandex.Cloud command line interface yet, install it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To change the host class for the cluster:

  1. View the description of the CLI's update cluster command:

    $ yc managed-clickhouse cluster update --help

  2. Request a list of available host classes (the ZONES column specifies the availability zones where you can select the appropriate class):

    $ yc managed-clickhouse resource-preset list

+-----------+--------------------------------+-------+----------+
|    ID     |            ZONE IDS            | CORES |  MEMORY  |
+-----------+--------------------------------+-------+----------+
| s1.nano   | ru-central1-a, ru-central1-b,  |     1 | 4.0 GB   |
|           | ru-central1-c                  |       |          |
| s1.micro  | ru-central1-a, ru-central1-b,  |     2 | 8.0 GB   |
|           | ru-central1-c                  |       |          |
| ...                                                           |
+-----------+--------------------------------+-------+----------+

  3. Specify the class in the update cluster command:

    $ yc managed-clickhouse cluster update <cluster name>
     --clickhouse-resource-preset <class ID>

    Managed Service for ClickHouse will run the update host class command for the cluster.

    You can change the ZooKeeper host class using a similar parameter: --zookeeper-resource-preset.

You can change the host class using the API update method: pass the appropriate values in the request parameter configSpec.clickhouse.resources.resourcePresetId (for ZooKeeper — configSpec.zookeeper.resources.resourcePresetId).

To request a list of supported values, use the list method for the ResourcePreset resources.

Increasing storage size

If you don't have the Yandex.Cloud command line interface yet, install it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To increase the storage size for a cluster:

  1. Make sure the required cluster is using network storage (it is not yet possible to increase the size of local storage). To do this, request information about the cluster and find the disk_type_id field: it should be set to network-hdd or network-ssd:

    $ yc managed-clickhouse cluster get <cluster name>

id: c7qkvr3u78qiopj3u4k2
folder_id: b1g0ftj57rrjk9thribv
...
config:
  clickhouse:
    resources:
      resource_preset_id: s1.nano
      disk_size: "21474836480"
      disk_type_id: network-ssd
...

  2. View the description of the CLI's update cluster command:

    $ yc managed-clickhouse cluster update --help

  3. Make sure the cloud's quota is sufficient to increase the storage size: open the Quotas page for your cloud and check that the Yandex Managed Service for ClickHouse section still has space available in the space line.

  4. Specify the required amount of storage in the update cluster command (it must be at least as large as disk_size in the cluster properties):

    $ yc managed-clickhouse cluster update <cluster name>
     --clickhouse-disk-size <storage size in GB>

    If all these conditions are met, Managed Service for ClickHouse launches the operation to increase storage space.

    You can change the storage size for ZooKeeper by using the same parameter, --zookeeper-disk-size.

You can change the cluster's storage size using the API update method: pass the appropriate values in the request parameter configSpec.clickhouse.resources.diskSize (for ZooKeeper, the parameter is configSpec.zookeeper.resources.diskSize).

Make sure the cloud's quota is sufficient to increase the storage size: open the Quotas page for your cloud and check that the Yandex Managed Service for ClickHouse section still has space available in the space line.

Changing ClickHouse settings

You can change the DBMS settings of the hosts in your cluster. All supported settings are described in the API reference.

You can change the DBMS settings for a cluster using the API update method: pass the appropriate values in the request parameter configSpec.clickhouse.config.