All Products
Search

This Product

    ApsaraDB for ClickHouse:Data backup

    Document Center

    ApsaraDB for ClickHouse:Data backup

    Last Updated:Jan 21, 2026

    ApsaraDB for ClickHouse provides a data backup feature. You can enable this service to configure backup settings.

    Prerequisites

    • For Community-compatible Edition clusters:

      • The kernel version is 21.8 or later.

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

      • The Automatic Storage Tiering feature is disabled for the cluster.

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

    Usage notes

    • Only one backup schedule can be set for each cluster.

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

    • The backup process reads and copies data files, which can affect the read and write performance of the cluster. We recommend that you run backup jobs during off-peak hours or O&M windows.

      Note

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

    • A backup job cannot be interrupted after it starts.

    Billing rules

    Community-compatible Edition

    • Billing rule: ApsaraDB for ClickHouse provides a free backup storage quota that is 100% of your cluster's storage space. For example, if you purchase a cluster with 100 GB of storage space, your free backup storage quota is 100 GB. If your backup storage usage exceeds the free quota, the excess storage is billed hourly on a pay-as-you-go basis.

    • Formula: Hourly backup storage costs = (Backup storage usage - Free backup storage quota) × Unit price for backup storage.

    • Billing examples:

      Note

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

      • If your backup storage usage does not exceed the free quota:

        If the free backup storage quota is 50 GB and your backup storage usage is 40 GB, the backup is free of charge.

      • If your backup storage usage exceeds the free quota:

        If the unit price for backup storage is USD 0.000026 per GB/hour, the free backup storage quota is 50 GB, and your backup storage usage is 100 GB, the hourly backup storage costs are (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 the cluster resides.

    3. On the Clusters page, select the appropriate cluster edition, and then click the ID of the destination cluster.

    4. In the navigation pane on the left, 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, set the following parameters.

      Parameter

      Description

      Backup Cycle

      Backup jobs run on a weekly basis, with a maximum of one backup per day. You can set any number of days in a week as backup dates.

      Backup Time

      The default backup time is from 02:00 to 03:00 on the specified backup date. You can set this to any time period.

      Backup Retention Time

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

    8. Click OK to save the backup settings.

    After a backup job is successfully completed, a backup dataset is created. You can use this backup data to restore data to a new cluster. For more information, see Data restoration.

    Important

    Restore 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 deleted. To prevent data loss, you must restore your backup data to a new cluster before you disable this feature. For 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 the cluster resides.

    3. On the Clusters page, select the appropriate cluster edition, and then click the ID of the destination cluster.

    4. In the navigation pane on the left, 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 dialog box that appears, click OK.