ApsaraDB for ClickHouse:Data backup

Prerequisites

Precautions

• 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.

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

• If you enable tiered storage of hot data and cold data for an ApsaraDB for ClickHouse cluster, you cannot enable the data backup feature for this cluster.

Billing

• 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, you are charged 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 = (Backup storage space that you use - Free quota) × Unit price for backup storage space.

Examples:

• 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.

  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.

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 Default Instances tab of the Clusters page, click the ID of the cluster on which you want to enable the data backup feature.

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, set 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 730.

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.

Disable 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 Default Instances tab of the Clusters page, click the ID of the cluster on which you want to disable the data backup feature.

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 Note message that appears, click OK.