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

Prerequisites

The version of the ApsaraDB ClickHouse cluster is V20.3, V20.8, or V21.8.

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.
  • You cannot interrupt a backup operation that has started.
  • After the data backup feature is enabled, you cannot disable the feature.
  • If you enabled 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 description

  • Billing rule: ApsaraDB ClickHouse provides a free quota that you can use to store backup data. The free quota is the same as the size of the storage space in your ApsaraDB for ClickHouse cluster. If the size of your backup data exceeds the free quota, you are billed for the excess backup space based on the pay-as-you-go billing method. You are billed by hour and based on the unit price of backup space.
  • You are billed based on the following formula: Backup cost per hour = (Used backup space - Free quota of backup space) × Unit price of backup space.
  • Example
    • In the following example, the backup space that you use does not exceed the free quota:

      If the free quota is 100 GB and the backup space that you use is 50 GB, you are not billed.

    • In the following example, the backup space that you use exceeds the free quota:

      If the unit price of backup space is USD 0.000026 per GB-hour, the free quota is 50 GB, and the backup space that you use is 100 GB, your backup cost is USD 0.0013 per hour. You are billed based on the following equation: (100 GB - 50 GB) × USD 0.000026 per GB-hour = USD 0.0013 per hour.

      Note The preceding prices are provided only for your reference. In actual billing scenarios, the prices displayed in the ApsaraDB for ClickHouse console take precedence. For information about the prices of backup space, see Billing overview.

Enable the data backup feature

  1. Log on to the ApsaraDB for ClickHouse console.
  2. In the upper-left corner, select the region where your cluster is deployed.
  3. On the Clusters page, click the Default Instances tab, and click the ID of the cluster.
  4. In the left-side navigation pane, click Backup and Restoration.
  5. Click the Backup Settings tab and turn on Backup Service Switch.
    Notice The first time you enable the data backup feature, a backup operation is immediately performed. This affects the write and query operations on your cluster in a negative manner.
  6. In the Backup Settings panel, configure the parameters that are 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 duration is 02:00‒03:00. You can specify a duration based on your business requirements.
    Retention Period You can specify the number of days for which you want to retain your backup data. The default value is 7. The valid values range from 7 to 730.
  7. Click OK to complete the configuration.

After a backup task is performed, one backup set is generated. You can use the backup data to restore your cluster data to a new cluster. For more information, see Restore data.