Maintenance in Managed Service for ClickHouse®
Maintenance in Managed Service for ClickHouse® includes:
- Automatic installation of DBMS updates and patches for hosts (including for stopped clusters).
- Scheduled automatic storage expansion.
- Other maintenance activities.
A major DBMS version update is not part of maintenance. For more information about major version changes, see ClickHouse® version upgrade.
Maintenance window
You can set the maintenance window when creating a cluster or updating its settings:
- The arbitrary option (default) allows performing maintenance at any time.
- The by schedule option allows setting the preferred maintenance start day and time (UTC). For example, you can choose a time when the cluster is least loaded.
Maintenance workflow
The maintenance workflow for Managed Service for ClickHouse® clusters depends on the number of shards and hosts in them:
- In single-host clusters, maintenance is performed on a single ClickHouse® host. This means, if you restart such a cluster during maintenance, it will become unavailable.
- If a cluster consists of multiple ClickHouse® hosts in a single shard, replica hosts undergo maintenance one by one. Such hosts are queued randomly. If you restart a host during maintenance, it will become unavailable for this time period. If you access a cluster using the FQDN of the ClickHouse® host, the cluster may become unavailable. To make your application continuously available, access the cluster using a special FQDN always pointing to the available host.
- If a cluster consists of multiple shards, maintenance is performed shard by shard in ascending order by shard number. Maintenance is first performed on hosts of one shard, then two shards, four, and so on, up to ten. Host maintenance is the same as in single-shard clusters. If you access a cluster shard using the FQDN of the ClickHouse® host, the shard may become unavailable. To make your application continuously available, access the shard using a special FQDN, always pointing to the available host in the shard.
ClickHouse® is a registered trademark of ClickHouse, Inc.