Moving and restoring a ClickHouse® cluster
-
When are backups performed? Is a database cluster available during a backup?
-
How many backups are stored in Managed Service for ClickHouse®? For how long?
-
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?
What is the backup procedure for a ClickHouse® database?
Backups are created every 24 hours and stored for seven days after being created. You can restore data only as of the backup creation time.
Is database host backup enabled by default?
Yes, backup is enabled by default. For ClickHouse®, a full backup is performed once a day with the possibility to restore it to any saved backup.
When are backups performed? Is a database cluster available during backup?
When creating or updating a cluster, you can set the time interval during which the backup will start. Default time: 22:00 - 23:00 UTC (Coordinated Universal Time).
Clusters remain fully accessible during the backup window.
How many backups are stored in Managed Service for ClickHouse®? For how long?
The size and amount of backups are not limited. Automatically created backups are stored for seven days, while manually created ones are stored indefinitely.
Can I change the automatic backup retention period?
When creating or modifying a cluster, you can set the retention period for automatic backups.
What does a daily backup include?
Backup data is only stored for the MergeTree engine family. For other engines, backups only store table schemas. For more information, see Backups.
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 host class and the nature of data in the DB.
How do I move an existing ClickHouse® cluster to Yandex Cloud?
Use Yandex Data Transfer.
ClickHouse® is a registered trademark of ClickHouse, Inc.