8.4.12. ClickHouse backups

Important points:

  • Backups:
    • Usually created at night.
    • Contain all instance databases.
    • Do not use space in the instance (are stored on a separate server).
    • Not created for empty instances without databases.
  • Maximum number of backups at any given time — 5 (excluding a backup for the 1st day of the month).
  • A backup for the 1st day of the month is not created if automatic backups are disabled in settings.

Working with backups is performed in the "ClickHouse" section on the "Backups" tab:

Restore

Databases can be restored from backups. Restoration is possible both to the original database and to any other database within the instance. During restoration, the current contents of the selected database are replaced with data from the backup.

  1. Click "Restore".
  2. Select the backup, its date, the destination database, and click "Restore".

On the backups page, a history of all restore requests is displayed.

Settings

  1. Click "Backup settings".
  2. Select the desired instance backup frequency and number of backups, then save your changes:
    • "Once a day" — daily.
    • "Once a week" — every Sunday.
    • "Once a month" — on the 1st day of each month.
    • "Do not create automatic backups" — completely disables the creation of automatic backups (including backups for the 1st day of the month).
Content