Moving and restoring a ClickHouse® cluster

• How are ClickHouse® databases backed up?

• Are database host backups enabled by default?

• When does a backup run? Is a database cluster available during backups?

• How many backups does Managed Service for ClickHouse® store? For how long?

• Can I delete a backup?

• Can I change the automatic backup retention period?

• What does a daily backup include?

• Why does it take a long time to restore a cluster from a backup?

• How do I move an existing ClickHouse® cluster to Yandex Cloud?

• Can I restore a shard from a backup into a shard in an existing cluster?

How are ClickHouse® databases backed up?How are ClickHouse® databases backed up?

Backups are created every 24 hours and retained for seven days. You can only restore data as of the backup creation time.

Are database host backups enabled by default?Are database host backups enabled by default?

Yes, backups are enabled by default. For ClickHouse®, a full backup is performed once a day with the possibility to restore it to any saved backup.

When does a backup run? Is a database cluster available during backups?When does a backup run? Is a database cluster available during backups?

When creating or updating a cluster, you can set the backup start window. The default value is 22:00 - 23:00 UTC (Coordinated Universal Time).

Clusters remain fully available during the backup window.

How many backups does Managed Service for ClickHouse® store? For how long?How many backups does Managed Service for ClickHouse® store? For how long?

The size and number of backups are not limited. Automatically created backups are retained for seven days, while manually created ones, indefinitely.

Can I delete a backup?Can I delete a backup?

Yes, if you created it manually. To delete a backup, follow this guide.

Can I change the automatic backup retention period?Can I change the automatic backup retention period?

You can set the retention period for automatic backups when creating or updating a cluster.

What does a daily backup include?What does a daily backup include?

Backups contain data solely for the MergeTree engine family. For other engines, backups only contain table schemas. For more information, see Backups.

Why does it take a long time to restore a cluster from a backup?Why does it take a long time to restore a cluster from a backup?

The approximate average speed of restoring a cluster from a backup is 100 Mbps. The recovery time may vary significantly depending on the host class and nature of the database data.

How do I move an existing ClickHouse® cluster to Yandex Cloud?How do I move an existing ClickHouse® cluster to Yandex Cloud?

Use Yandex Data Transfer.

Can I restore a shard from a backup into a shard in an existing cluster?Can I restore a shard from a backup into a shard in an existing cluster?

This option is not currently supported.

However, you can restore your shard from a backup to a new ClickHouse® cluster and transfer data from that cluster into an existing one. To do this, explore the options below:

• Data Transfer enables you to transfer a database or individual tables to a Managed Service for ClickHouse® cluster.
• ClickHouse® built-in remote function allows you to transfer individual tables to a Managed Service for ClickHouse® cluster.
• ClickHouse® BACKUP and RESTORE commands help you back up a database or individual table to a Yandex Object Storage bucket and then restore your data from the bucket to a Managed Service for ClickHouse® cluster.

ClickHouse® is a registered trademark of ClickHouse, Inc.