All Products
Search
Document Center

ApsaraDB for ClickHouse:Data restoration

Last Updated:Apr 02, 2025

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.

Note

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

  1. Log on to the ApsaraDB for ClickHouse console.

  2. In the upper-left corner of the page, select the region where the cluster that you want to manage is deployed.

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

  4. In the left-side navigation pane of the page that appears, click Backup and Restoration.

  5. On the Data Backup tab, find the backup you want to restore and click Data Recovery in the Actions column.

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

    Note

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

    Note

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

  7. Read Terms of Service.

  8. Click Buy Now.

After you purchase the clone cluster, you can go to the Clusters page to view the clone cluster.

Note

The creation of the clone cluster may take some time, which depends on the backup data size.