Restore data from a backup to a new ApsaraDB for ClickHouse instance. The new instance is referred to as a cloned instance. Only instance-level restoration is supported — database-level and table-level restoration are not available.
Limits
| Constraint | Detail |
|---|---|
| Restoration scope | Instance level only. Database-level and table-level restoration are not supported. |
| Region | The cloned instance must be in the same region as the source cluster. |
| Edition | The cloned instance must use the same edition (Community-compatible or Enterprise Edition) as the source cluster. |
| Deployment mode (Community-compatible only) | The cloned instance must use the same deployment mode and replica configuration as the source cluster. |
Prerequisites
Community-compatible clusters:
Kernel version 21.8 or later
Storage type is PL0 ESSD, PL1 ESSD, PL2 ESSD, or PL3 ESSD
The Tiered Storage of Hot and Cold Data feature is disabled
Enterprise Edition clusters:
Cluster version 24.10 or later
Billing
You are charged for the new instance when you restore data to it.
Restore data from a backup
Log on to the ApsaraDB for ClickHouse console. In the upper-left corner, select the region where your cluster is located.
On the Clusters page, click the ID of the cluster from which you want to restore data.
In the left navigation pane, click Backup and Restoration.
On the Backup and Restoration page, find the backup set to restore. In the Actions column, click Data Recovery.
On the Clone Instance page, review the source cluster configuration and configure the parameters for the cloned instance. The available parameters differ by edition:
Community Edition
Parameter
Description
Cluster type
The type of the source cluster.
Source cluster for cloning
The ID of the source instance.
Source type for cloning
The data source type: backup set or real-time replica.
Source backup set for cloning
The start time of the backup set. Available only when Clone Source Type is set to Backup Set and the current instance kernel version is not the latest.
Region
The region of the cloned instance. Defaults to the same region as the source cluster and cannot be changed.
Zone
The zone where the cloned instance is deployed.
Network type
Virtual private cloud (VPC) only.
Virtual Private Cloud (VPC)
The VPC for the cloned instance.
vSwitch
The vSwitch for the cloned instance.
Current instance kernel version
The kernel version used as the clone baseline. If Clone Source Type is Backup Set, this is the kernel version of the cloned instance (same as the source, cannot be changed). If Clone Source Type is Real-time Replica, this is the kernel version of the source instance.
Destination instance kernel version
The target kernel version of the cloned instance. Available only when Clone Source Type is Real-time Replica.
Replica configuration
The number of replicas. Defaults to the same as the source cluster and cannot be changed. Options: Dual-replica edition — each node has two replicas; if one becomes unavailable, the other continues serving traffic. Single-replica edition — each node has one replica; if it becomes unavailable, the cluster is unavailable until fully recovered.
Node specifications
The node specifications for the cloned instance.
Number of nodes
The number of nodes. Defaults to the same as the source cluster and cannot be changed.
Storage type
The disk type: Enterprise SSD (ESSD) (PL3 > PL2 > PL1 > PL0 in performance) or Ultra disk (cost-effective with medium random read/write performance).
Encryption type
No encryption or Disk encryption (block-level encryption; requires selecting an encryption key).
Storage space
The storage capacity. Defaults to the same as the source cluster and cannot be changed.
Enterprise Edition
Parameter
Description
Cluster type
The type of the source cluster.
Source cluster for cloning
The ID of the source instance.
Source type for cloning
Defaults to Restore from Backup Set.
Source backup set for cloning
The start time of the backup set.
Deployment plan
The deployment plan for the cloned cluster.
Region
The region of the cloned instance. Defaults to the same region as the source cluster and cannot be changed.
Zone
The zone where the cloned instance is deployed. For multi-zone deployment plans, select three zones.
Network type
Virtual private cloud (VPC) only.
Virtual Private Cloud (VPC)
The VPC for the cloned instance.
vSwitch
The vSwitch for the cloned instance.
Maximum CCUs
The maximum number of ClickHouse Compute Units (CCUs) for the cloned instance.
Minimum CCUs
The minimum number of CCUs for the cloned instance.
Click Buy Now.
After the restore completes
After you click Buy Now, the cloned instance starts creating. Creation time is proportional to the data volume. Once complete, the cloned instance appears on the Clusters page.
After the instance is available:
Verify that the cloned instance contains the data you need.
Update your application connection strings to point to the new instance, if required.
If the original cluster is no longer needed, delete it to avoid ongoing charges.