Manage ClickHouse® backups

Warning

At the moment, you can create backups only for specific ClickHouse® shards. The functionality that allows creating backups for clusters is currently under development.

Manually create a backup

  1. Go to the Clusters overview page.

  2. Select the cluster you want to create a backup for and click on it.

  3. Go to the Backups tab.

  4. Click Create backup.

  5. Name your backup and click Submit. ClickHouse® service automatically creates a separate backup for each shard in the cluster.

Note

Daily backups are created automatically at approximately 1 a.m. according to your timezone.

Restore shards from backups

  1. Go to the Clusters overview page.

  2. Select the cluster whose shards you want to restore and click on it.

  3. Go to the Backups tab.

  4. Select a shard you want to restore a backup from.

  5. Click and select Restore backup. The cluster creation page will open automatically.

  6. Follow the steps from the Create a cluster page to add a new cluster for your backup copy.

    Warning

    Currently, you can't use an existing cluster to store your data after you restore this data from a backup. Create a new cluster for this purpose and redefine its Service, Provider, Region and Resources settings.

Delete a backup

Warning

At the moment, you cannot delete a backup manually. The DoubleCloud service automatically deletes backups after 7 days since creation.

  1. Go to the Clusters overview page.

  2. Select the cluster whose backup you want to delete and click on it.

  3. Go to the Backups tab.

  4. Select a backup you want to delete.

  5. Click and select Delete.

  6. Click Delete to confirm your action.

See also: