Updating a ClickHouse® cluster
How do I add a host to a cluster?
To add a host, follow this guide. You can also add new hosts to a cluster when creating a shard.
Can I set join_use_nulls to 1 using the CLI?
Yes. To do this, when creating a user or updating user settings, provide the required join_use_nulls value in --settings. Here is an example:
yc managed-clickhouse user update <username> \
--cluster-name=<cluster_name> \
--settings="join_use_nulls=1"
For more information, see this guide.
Will my cluster be unavailable during an update?
If your cluster has more than one host, there is no downtime while updating it, since the hosts are updated one by one. Only individual hosts are unavailable when the cluster is being restarted.
How do I change the time zone?
Change the ClickHouse® timezone or session_timezone setting. Learn how to do this in this guide.
Will my cluster be unavailable when adding replicas?
Yes, the cluster will experience a short downtime during restart.
How do I grant read-only permissions to a user?
To do this, when creating or editing a user via the CLI, specify readonly=1 in --settings. Here is an example:
yc managed-clickhouse user update <username> \
--cluster-name=<cluster_name> \
--settings="readonly=1"
For more information, see this guide.
How do I increase the memory limit?
Update the user settings and set the required Max memory usage value.
Can I change a network and subnets?
No, you can only select a network and subnets for hosts when creating a cluster or restoring it from a backup.
How do I change the distribution of data across shards in a cluster?
In an existing cluster, you cannot change the location of data in shards.
ClickHouse® is a registered trademark of ClickHouse, Inc.