All Products
Search
Document Center

ApsaraDB for ClickHouse:Data recovery

Last Updated:Aug 26, 2026

You can restore data from a backed-up ApsaraDB for ClickHouse instance to a new ApsaraDB for ClickHouse instance.

How it works

ApsaraDB for ClickHouse supports data recovery at the instance level only, not for individual databases or tables. All data from the source instance's backup set is restored to a new instance, known as a clone instance.

Prerequisites

  • For Community-compatible Edition instances:

    • The kernel version is 21.8 or later.

    • The storage type is ESSD PL0, ESSD PL1, ESSD PL2, or ESSD PL3.

    • Tiered storage of hot and cold data must be disabled for the instance.

  • For Enterprise Edition instances: The kernel version is 24.10 or later.

Billing

Restoring data creates a new, billable instance.

Note

The new instance is created in the same region as the source instance, and its edition cannot be changed. For Community-compatible Edition instances, the deployment method and replica configuration are also inherited from the source instance and cannot be modified.

Procedure

  1. Log on to the ApsaraDB for ClickHouse console. In the upper-left corner, select the instance's region.

  2. On the Clusters page, select the tab for the corresponding edition, and then click the target instance ID.

  3. In the navigation pane on the left, click Backup and Restoration.

  4. On the Backup and Restoration page, find the desired backup set and click Data Recovery in the Actions column.

  5. On the Clone Instance page, review the source instance's configuration and configure the clone instance.

    Community-compatible edition

    Parameter

    Description

    Cluster Type

    The edition of the source instance.

    Cloned Data Source Cluster

    The source instance ID.

    Clone Source Type

    The data source type for the clone instance.

    Backup Set

    The start time of the backup set.

    Note

    This parameter is displayed only if the following conditions are met:

    • Clone Source Type is set to Backup Set.

    • The Current Instance Kernel Version is not the latest version.

    Region

    The region of the clone instance. This is locked to the source instance's region.

    Zone

    The zone of the clone instance.

    Network Type

    Only Virtual Private Cloud (VPC) is supported.

    VPC

    The VPC for the clone instance.

    VSwitch

    The vSwitch for the clone instance.

    Current Instance Kernel Version

    If Clone Source Type is set to restore from a backup set, this parameter shows the kernel version of the clone instance, which matches the source instance and cannot be changed.

    If Clone Source Type is set to clone from a real-time replica, this parameter shows the kernel version of the source instance and cannot be changed.

    Target Instance Kernel Version

    The kernel version of the clone instance.

    Note

    This parameter is available only if Clone Source Type is set to clone from a real-time replica.

    Replica Configuration

    The replica configuration of the clone instance, inherited from the source instance. This cannot be changed.

    • High-availability: Each node contains two replicas. If one replica becomes unavailable, the other replica in the same shard can continue to provide service.

    • single-replica: Each node has only one replica. If this replica becomes unavailable, the entire instance becomes unavailable until the replica fully recovers.

    Specification

    The node specifications for the clone instance.

    Nodes

    The number of nodes in the clone instance, inherited from the source instance. This cannot be changed.

    Storage Type

    The storage type of the clone instance.

    • ESSD: Enhanced SSDs (ESSDs) are ultra-high-performance cloud disks based on a new-generation distributed block storage architecture. Performance levels: ESSD PL3 > ESSD PL2 > ESSD PL1 > ESSD PL0.

    • Ultra Disk: A cost-effective cloud disk with moderate random read/write performance and high reliability.

    Encryption Type

    The encryption type for the clone instance.

    • No encryption: The disk is not encrypted.

    • Disk encryption: Encrypts the entire data disk at the block storage level. You must also select an encryption key.

    Storage Capacity

    The storage capacity of the clone instance, inherited from the source instance. This cannot be changed.

    Enterprise edition

    Parameter

    Description

    Cluster Type

    The edition of the source instance.

    Cloned Data Source Cluster

    The source instance ID.

    Clone Source Type

    The data source type, which is fixed to "Restore from backup set".

    Backup Set

    The start time of the backup set.

    Deployment Method

    The deployment method for the clone instance.

    Region

    The region of the clone instance. This is locked to the source instance's region.

    Zone

    The zone of the clone instance.

    If you select the multi-zone deployment method, you must select three zones for the instance.

    Network Type

    Only Virtual Private Cloud (VPC) is supported.

    VPC

    The VPC for the clone instance.

    VSwitch

    The vSwitch for the clone instance.

    Maximum CCU

    The upper limit of CCU (ClickHouse Compute Unit) for the clone instance.

    Minimum CCU

    The lower limit of CCUs for the clone instance.

  6. Click Buy Now.

After the purchase is successful, you can view the clone instance on the Clusters page.

Note

The time required to create the clone instance depends on the data size.