All Products
Search

This Product

    ApsaraDB for ClickHouse:Data backup

    Document Center

    ApsaraDB for ClickHouse:Data backup

    Last Updated:Aug 05, 2026

    ApsaraDB for ClickHouse provides data backup to protect your cluster data. You can enable backup and configure the schedule, time window, and retention period.

    Prerequisites

    • For a Community-compatible Edition cluster:

      • The kernel version is 21.8 or later.

      • The storage type is ESSD PL0, ESSD PL1, ESSD PL2, or ESSD PL3.

      • The tiered storage of hot data and cold data feature is disabled for the cluster.

    • For an Enterprise Edition cluster, the cluster must be version 24.10 or later.

    Usage notes

    • You can configure only one backup schedule for each cluster.

    • A backup includes all databases, tables, views, data dictionaries, and metadata structures in the current cluster.

    • To selectively back up specific databases or tables, you can use the BACKUP DATABASE command. For more information, see Use BACKUP and RESTORE commands for data backup and restoration.

    • Backups read and copy data files, which may affect cluster read and write performance. We recommend that you schedule backup tasks during off-peak hours.

      Note

      For an Enterprise Edition cluster, if you enable or modify backup settings during the specified backup time window, a backup task starts immediately. For example, if you enable or modify the settings at 14:03 and the backup time is set from 14:00 to 15:00, the cluster immediately starts a backup.

    • A backup task cannot be interrupted after it starts.

    Billing

    Community-compatible Edition

    • Billing rules: ApsaraDB for ClickHouse provides a free backup storage quota equal to 100% of your cluster's storage capacity. For example, if your cluster has 100 GB of storage, your free backup quota is 100 GB. Usage beyond the free quota is billed hourly on a pay-as-you-go basis at the unit price of backup storage.

    • Billing formula: Hourly backup fee = (Backup storage used - free quota) × unit price of backup storage.

    • The following are billing examples:

      Note

      The prices in this example are for reference only. For actual pricing, see the information on the console. For more information about backup storage pricing, see Backup storage fees for Community-compatible Edition.

      • Backup storage usage does not exceed the free quota:

        If your free quota is 50 GB and you use 40 GB for backups, the data backup is free of charge.

      • Backup storage usage exceeds the free quota:

        If the unit price for backup storage is USD 0.000026/GB/hour, your free quota is 50 GB, and you use 100 GB for backups, the hourly backup fee is (100 - 50) GB × USD 0.000026/GB/hour = USD 0.0013/hour.

    Enterprise Edition

    This feature is in public preview and is free of charge.

    Enable data backup

    1. Log on to the ApsaraDB for ClickHouse console.

    2. In the upper-left corner of the page, select the region where your cluster is located.

    3. On the Clusters page, select the tab for your cluster's edition and then click the target cluster's ID.

    4. In the left-side navigation pane, click Backup and Restoration.

    5. On the Backup and Restoration page, click the Backup Settings tab.

    6. On the Backup Settings tab, turn on the Backup Service Switch.

    7. In the Backup Settings dialog box that appears, configure the following parameters.

      Parameter

      Description

      Backup Cycle

      Backups run on a weekly schedule, with a maximum of one backup per day. Select on which days of the week to run backups.

      Backup Time

      By default, backups run between 02:00 and 03:00 on the selected days. You can specify any one-hour time slot.

      Backup Retention Time

      The default retention period is 7 days. You can set a value from 7 to 30 days.

    8. Click OK.

    After a backup task completes, a backup snapshot is created. You can use this snapshot to restore data to a new cluster. For more information, see data restoration.

    Important

    Restore your backup data to a new cluster promptly to prevent data loss.

    Disable data backup

    Important

    When you disable the data backup feature, all existing backup snapshots are permanently deleted. To prevent data loss, ensure that you restore any required data to a new cluster before you disable this feature. For more information about how to restore data, see data restoration.

    1. Log on to the ApsaraDB for ClickHouse console.

    2. In the upper-left corner of the page, select the region where your cluster is located.

    3. On the Clusters page, select the tab for your cluster's edition and then click the target cluster's ID.

    4. In the left-side navigation pane, click Backup and Restoration.

    5. On the Backup and Restoration page, click the Backup Settings tab.

    6. On the Backup Settings tab, turn off the Backup Service Switch.

    7. In the confirmation dialog box that appears, click OK.