Moving and restoring a ClickHouse® cluster
-
When are backups performed? Is a database cluster available during 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?
How do I back up a ClickHouse® database?
Backups are created every 24 hours and stored for seven days after being created. You can restore data only as of backup creation time.
Is DB 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 DB cluster available during backup?
When creating or updating a cluster, you can set the time interval during which the backup will start. The default time is 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.
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 average speed when recovering a cluster from a backup is about 100 Mbps. Cluster recovery time may vary significantly depending on the host class and the nature of data being stored 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