ApsaraDB for ClickHouse backs up all databases, tables, views, data dictionaries, and data structures in your cluster on a configurable schedule. After a backup completes, you can restore the data to a new cluster.
Prerequisites
Before you begin, make sure your cluster meets the following requirements:
Community-compatible Edition:
Kernel version 21.8 or later
Storage class: PL0 ESSD, PL1 ESSD, PL2 ESSD, or PL3 ESSD
Automatic Storage Tiering disabled
Enterprise Edition:
Version 24.10 or later
How it works
Each cluster supports one backup schedule. On each scheduled date, ApsaraDB for ClickHouse reads and copies the cluster's data files. This process competes with normal cluster reads and writes, so schedule backups during off-peak hours or O&M windows.
Keep in mind:
A backup job cannot be interrupted after it starts.
For Enterprise Edition clusters, enabling or modifying backup settings while a backup window is active triggers an immediate backup job. For example, enabling backup at 14:03 when the backup window is 14:00–15:00 starts a backup immediately.
Billing
Community-compatible Edition
The free backup storage quota equals 100% of your cluster's purchased storage. For example, a 100 GB cluster includes a 100 GB free quota.
If backup storage usage exceeds the free quota, the excess is billed hourly:
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.
Hourly cost = (Backup storage usage − Free quota) × Unit price per GB/hour
Examples (prices shown for reference; see the console for current pricing):
Usage within quota: free quota 50 GB, usage 40 GB — free of charge
Usage exceeding quota: unit price USD 0.000026/GB/hour, free quota 50 GB, usage 100 GB — (100 − 50) × 0.000026 = USD 0.0013/hour
For pricing details, see Backup storage costs for Community-compatible Edition clusters.
Enterprise Edition
This feature is in public preview and is free of charge.
Enable data backup
Log on to the ApsaraDB for ClickHouse console.
In the upper-left corner, select the region where your cluster resides.
On the Clusters page, select the cluster edition, then click the cluster ID.
In the left navigation pane, click Backup and Restoration.
Click the Backup Settings tab.
Turn on the Backup Service Switch.
In the Backup Settings dialog box, configure the following parameters, then click OK.
| Parameter | Description | Default | Range |
|---|---|---|---|
| Backup cycle | Days of the week on which backup jobs run. Each selected day runs at most one backup. | — | Any combination of days |
| Backup time | The time window during which the backup job runs on each scheduled date. | 02:00–03:00 | Any time period |
| Backup retention time | How long each backup is kept before it is automatically deleted. | 7 days | 7–30 days |
After the backup job completes, a backup dataset is created. Restore this data to a new cluster promptly to protect against data loss. For instructions, see Data restoration.
Restore backup data to a new cluster promptly to prevent data loss.
Disable data backup
Disabling data backup deletes all existing backup snapshots. Before you disable this feature, restore your backup data to a new cluster. For instructions, see Data restoration.
Log on to the ApsaraDB for ClickHouse console.
In the upper-left corner, select the region where your cluster resides.
On the Clusters page, select the cluster edition, then click the cluster ID.
In the left navigation pane, click Backup and Restoration.
Click the Backup Settings tab.
Turn off the Backup Service Switch.
In the confirmation dialog box, click OK.