All Products
Search

This Product

    ApsaraDB for ClickHouse:Data backup

    Document Center

    ApsaraDB for ClickHouse:Data backup

    Last Updated:Mar 28, 2025

    ApsaraDB for ClickHouse provides the data backup feature. To use this feature, you must turn on Backup Service Switch.

    Prerequisites

    • Community-compatible Edition cluster

      • The kernel version of the cluster is 21.8 or later.

      • The cluster uses Enterprise SSDs (ESSDs) at performance level 0 (PL0), PL1, PL2, or PL3.

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

    • Enterprise Edition cluster

      • The kernel version of the cluster is 24.10 or later.

      • The cluster resides in the China (Zhangjiakou) region.

    Usage notes

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

    • You can back up all databases, tables, views, data dictionaries, and metadata structures of your cluster.

    • During the backup process, data files are read and replicated. This reduces the read and write efficiency of your cluster. We recommend that you perform backup tasks during off-peak hours or maintenance windows.

      Note

      If you enable or modify the data backup settings for an Enterprise Edition cluster within the specified backup time range, the system immediately performs a backup. For example, if you enable or modify the backup settings at 14:03 and the backup time range is 14:00 to 15:00, the system immediately performs a backup.

    • A backup task cannot be interrupted after it is started.

    Billing rules

    Community-compatible Edition

    • Billing rule: ApsaraDB for ClickHouse provides a free quota for backup data storage. The free quota is the same as the size of the storage space in your ApsaraDB for ClickHouse cluster. For example, if the storage space of your ApsaraDB for ClickHouse cluster is 100 GB, the free quota for backup data storage is also 100 GB. If the size of your backup data exceeds the free quota, fees are billed for the excess storage space every hour based on the unit price for backup storage space. The pay-as-you-go billing method is used.

    • Billing formula: Backup fee per hour = (Storage space used for backup - Free quota) × Unit price for backup storage.

    Examples:

    Note

    The preceding examples are for reference only. In actual billing scenarios, the prices displayed in the ApsaraDB for ClickHouse console shall prevail. For more information, see Fees for backup space in ApsaraDB for ClickHouse clusters.

    • The backup storage space that you use does not exceed the free quota.

      If the free quota is 50 GB and the backup storage space that you use is 40 GB, you are not charged for data backup.

    • The backup storage space that you use exceeds the free quota.

      If the unit price for backup storage space is USD 0.000026 per GB-hour, the free quota is 50 GB, and the backup storage space that you use is 100 GB, your backup cost is USD 0.0013 per hour.

    Enterprise Edition

    Enterprise Edition is in public preview. You can use it free of charge during the public preview.

    Enable the data backup feature

    1. Log on to the ApsaraDB for ClickHouse console.

    2. In the top navigation bar, select the region where your cluster is deployed.

    3. On the Clusters of Community-compatible Edition or Enterprise Edition Clusters tab of the Clusters page, click the ID of the cluster that you want to manage.

    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 Backup Service Switch.

    7. In the Backup Settings panel that appears, configure the parameters described in the following table.

      Parameter

      Description

      Backup Cycle

      Backup tasks are performed on a weekly basis. A maximum of one backup task can be performed per day. You can select multiple days in a week.

      Backup Time

      The default value is 02:00-03:00. This indicates that a backup task is performed from 02:00 to 03:00 on the day that you specified. You can specify a custom value.

      Backup Retention Time

      By default, backup data is retained for seven days. You can set a value in the range of 7 to 30.

    8. Click OK to complete the backup configuration.

    After a backup task is performed, one set of backup data is generated. You can use the backup data to restore your cluster data to a new ApsaraDB for ClickHouse cluster. For more information, see Data restoration.

    Important

    To prevent loss of backup data, restore your backup data to a new ApsaraDB for ClickHouse cluster in a timely manner.

    Disable the data backup feature

    Important

    After the data backup feature is disabled, all historical backup snapshots are deleted. Before you disable the data backup feature, restore your backup data to a new ApsaraDB for ClickHouse cluster in a timely manner to prevent loss of the backup data. For more information about how to restore data, see Data restoration.

    1. Log on to the ApsaraDB for ClickHouse console.

    2. In the top navigation bar, select the region where your cluster is deployed.

    3. On the Clusters of Community-compatible Edition or Enterprise Edition Clusters tab of the Clusters page, click the ID of the cluster that you want to manage.

    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 Backup Service Switch.

    7. In the message that appears, click OK.