If you have backed up the data of an ApsaraDB for ClickHouse cluster, you can use the data restoration feature to restore the data to a new ApsaraDB for ClickHouse cluster.
Feature description
ApsaraDB for ClickHouse supports only data restoration for a cluster. ApsaraDB for ClickHouse does not support data restoration for a database or table. When you restore your data, all data in the backup set of your source cluster is restored to the new cluster. The new cluster is known as a clone cluster.
Prerequisites
Community-compatible Edition
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
The kernel version of the cluster is 24.10 or later.
The cluster resides in the China (Zhangjiakou) region.
Billing rules
If data is restored to a new cluster, you are charged for purchasing the new cluster.
The region and edition of the new cluster are the same as those of the source cluster and cannot be changed. In addition, if the new cluster uses Community-compatible Edition, the deployment method and replica configuration of the new cluster must be the same as those of the source cluster and cannot be changed.
Procedure
Log on to the ApsaraDB for ClickHouse console.
In the upper-left corner of the page, select the region where the cluster that you want to manage is deployed.
On the Clusters page, click the Clusters of Community-compatible Edition or Enterprise Edition Cluster tab based on the edition of the cluster that you want to manage, find the cluster, and then click the ID of the cluster.
In the left-side navigation pane of the page that appears, click Backup and Restoration.
On the Data Backup tab, find the backup you want to restore and click Data Recovery in the Actions column.
On the Clone Instance page, view the configurations of the source cluster and configure the following parameters for the clone cluster.
Community-compatible Edition
Parameter
Description
Cluster Type
The edition of the source cluster.
Clone Source Cluster
The ID of the source cluster.
Clone Source Type
The data source type of the clone cluster.
Clone Source Backup Set
The start time of the backup task.
NoteWhen the following conditions are met, this parameter is available:
The Clone Source Type parameter is set to Backup Set.
The Kernel Version of Current Instance parameter is set to a version other than the latest version.
Region
The region where the clone cluster is deployed. By default, this setting of the clone cluster is the same as that of the source cluster and cannot be changed.
Zone
The zone where the clone cluster is deployed.
Network Type
The network type. You can only set the value of this parameter to Virtual Private Cloud. A virtual private cloud (VPC) is an isolated virtual network that provides high security.
Virtual Private Cloud (VPC)
The VPC where the clone cluster is deployed.
vSwitch
The vSwitch associated with the clone cluster.
Kernel Version of Current Instance
If you set the Clone Source Type parameter to Backup Set, the value of this parameter is the kernel version of the clone cluster. By default, the kernel version of the clone cluster is the same as that of the source cluster and cannot be changed.
If you set the Clone Source Type parameter to Real-time Replica, the value of this parameter is the kernel version of the source cluster and cannot be changed.
Kernel Version of Destination Instance
The kernel version of the clone cluster.
NoteOnly when you set the Clone Source Type parameter to Real-time Replica, this parameter is available.
Edition
The number of replicas in the clone cluster. By default, this setting of the clone cluster is the same as that of the source cluster and cannot be changed. Valid values:
High-availability: A shard has two replicas. If a replica in the shard fails, the other replica in the shard can take over services from the failed replica.
Single-replica: A shard has only one replica. If the replica fails, the entire cluster becomes unavailable. The cluster can provide stable services only after the replica is recovered.
Server Specifications
The shard specification of the clone cluster.
Server Nodes
The number of shards in the clone cluster. By default, this setting of the clone cluster is the same as that of the source cluster and cannot be changed.
Storage Type
The storage type of the clone cluster. Valid values:
ESSD PL1 (Recommended), PL2 ESSD, PL3 ESSD, and PL0 ESSD: ESSDs are high-performance disks that are developed based on the next-generation distributed block storage architecture. ESSDs provide high read and write performance. A PL3 ESSD outperforms a PL2 ESSD. A PL2 ESSD outperforms a PL1 ESSD. A PL1 ESSD outperforms a PL0 ESSD.
Ultra Disk: An ultra disk is a cost-effective disk that provides a medium rate of random input/output operations per second (IOPS) and high data reliability.
Encryption Type
The encryption type of the clone cluster. Valid values:
Disable Disk Encryption: Data on the disks of the clone cluster is not encrypted.
Enable Disk Encryption: All data on the disks of the clone cluster is encrypted based on block storage. If you set this parameter to Enable Disk Encryption, you must select an encryption key.
Storage Space
The storage capacity of the clone cluster. By default, this setting of the clone cluster is the same as that of the source cluster and cannot be changed.
Enterprise Edition
Parameter
Description
Cluster Type
The edition of the source cluster.
Clone Source Cluster
The ID of the source cluster.
Clone Source Type
The source data type of the clone cluster. The default value is Backup Set.
Clone Source Backup Set
The start time of the backup task.
Deployment Method
The deployment method of the clone cluster.
Region
The region where the clone cluster is deployed. By default, this setting of the clone cluster is the same as that of the source cluster and cannot be changed.
Zone
The zone where the clone cluster is deployed.
If you set the Deployment Method parameter to Multiple zones, you need to select three zones to deploy the cluster.
Network Type
The network type. You can only set the value of this parameter to Virtual Private Cloud. A VPC is an isolated virtual network that provides high security.
Virtual Private Cloud (VPC)
The VPC where the clone cluster is deployed.
vSwitch
The vSwitch associated with the clone cluster.
Maximum CCUs
The maximum number of ClickHouse Compute Units (CCUs) that is supported for the clone cluster.
Minimum CCUs
The minimum number of CCUs that is supported for the clone cluster.
Read Terms of Service.
Click Buy Now.
After you purchase the clone cluster, you can go to the Clusters page to view the clone cluster.
The creation of the clone cluster may take some time, which depends on the backup data size.