PolarDB:Full restoration method 2: Restore data from a backup set (snapshot)

Precautions

Only the data and account information of the original cluster can be restored to a new cluster. The parameter settings of the original cluster cannot be restored to the new cluster.

Procedure

1. Log on to the PolarDB console. Click Clusters in the left-side navigation pane. Select a region in the upper-left corner and click the ID of the cluster in the list to go to the Basic Information page.

2. In the left-side navigation pane, choose Settings and Management > Backup and Restoration

3. Restore data to a new cluster.

   • Restoration within a region:

     Find the backup set from which you want to restore data and click Restore Data to New Cluster in the Actions column.

     

   • Restoration across regions:

     1. On the Backup and Restoration page, select the region where the data to be restored resides.

     2. Find the backup set from which you want to restore data and click Restore Data to New Cluster in the Actions column.

     

4. On the Clone Instance page, select a billing method for the new cluster.

   • Subscription: When you create a cluster, you must pay for the compute nodes. You are charged fees for the storage resources that you use and the fees are deducted from your account balance on an hourly basis.

   • Pay-as-you-go: If you select the pay-as-you-go billing method, you pay for the resources after you use them. You are charged for the compute nodes and the used storage space on an hourly basis. The fee is deducted from your account balance on an hourly basis. We recommend that you select the pay-as-you-go billing method for the short-term use. You can reduce costs by releasing the cluster based on your business requirements.

5. Configure the parameters described in the following table.

   Parameter	Description
   Clone Type	Select Restore from Backup Set.
   Region	The region to which the data is to be restored. Note Cross-region backup can be used to restore data to the source or destination region. If cross-region backup is not enabled, the region of the new cluster is the same as that of the original cluster and does not need to be specified.
   Backup Set	Select the backup set from which you want to restore data. Note The Backup Start Time of each backup set is displayed. You can determine whether to select the backup set based on this backup time.
   Primary Zone	Select the primary zone where the cluster resides. Note In regions that have two or more zones, PolarDB automatically replicates the data to the secondary zone for disaster recovery.
   Network Type	This parameter is fixed to VPC. You do not need to configure this parameter.
   VPC	Select a VPC and a vSwitch for the new cluster. We recommend that you select the same VPC and vSwitch that are connected to the original cluster. Note Make sure that the PolarDB cluster is created in the same virtual private cloud (VPC) as the ECS instance to which you want to connect. Otherwise, the cluster and the Elastic Compute Service (ECS) instance cannot communicate over the internal network to achieve optimal performance.
   VSwitch
   Compatibility	This parameter is automatically set to the Compatibility value of the original cluster. You do not need to change this value.
   Product Edition	This parameter is automatically set to the Product Edition value of the original cluster. You do not need to change this value.
   Edition	This parameter is automatically set to the Edition value of the original cluster. You do not need to change this value.
   Specification Type	This parameter is automatically set to the Resource Type value of the original cluster. You do not need to change this value.
   CPU Architecture	This parameter is automatically set to the CPU Architecture value of the original cluster. You do not need to change this value.
   Node Specification	Select a node specification. The maximum storage capacity and the performance of a cluster vary based on the node specifications. For more information, see Specifications of compute nodes. Note We recommend that you select a node specification that is higher than the node specification of the original cluster. This ensures that the new cluster runs as expected.
   Nodes	The default value is 2. Note By default, a new cluster has one primary node and one read-only node. After the cluster is created, you can add nodes to the cluster. A cluster can contain one primary node and a maximum of 15 read-only nodes. For more information about how to add nodes, see Add or remove a read-only node.
   PolarProxy Type	The edition of the new cluster. This parameter is fixed to Standard Enterprise. You do not need to change this value.
   Enable Hot Standby Cluster	Select whether to Enable Hot Standby Storage Cluster. If the hot standby storage cluster feature is enabled, both the primary PolarDB cluster and the hot standby storage cluster are deployed in the same region. The two clusters each have three replicas, which adds up to six replicas. This delivers higher SLA than when this feature is disabled. If this feature is disabled, only the primary cluster is deployed. The cluster has three replicas, and the storage unit price is half of that when this feature is enabled. This delivers lower SLA than when this feature is enabled.
   Storage Type	PolarDB Enterprise Edition supports the PSL5 and PSL4 storage types: PSL5: the storage types supported in the historical versions of PolarDB. This storage type delivers higher performance, reliability, and availability. PSL4: a new storage type for PolarDB. PSL4 uses the Smart-SSD technology developed by Alibaba Cloud to compress and decompress data at the physical SSD disk level. This can minimize the storage price of data while keeping a high disk performance. Note You cannot change the storage type of an existing cluster. If you want to change the storage type, you need to create a new cluster with the desired storage type and then migrate data to the new cluster. For more information about the two storage types, see Comparison between PSL4 and PSL5.
   Storage Billing Method	PolarDB supports the Pay-as-you-go and Subscription storage billing methods. Pay-as-you-go: The storage capacity dynamically scales as the data volume increases or decreases. You do not need to specify the storage capacity when creating a cluster, and you are charged for the storage usage. Subscription: You must purchase a specific amount of storage capacity when you create a cluster. For more information about the two storage billing methods, see and Billing methods for storage. Note If you set the Product Type parameter to Subscription, you can set the Storage Billing Method parameter to Pay-as-you-go or Subscription. If you set the Product Type parameter to Pay-as-you-go, the Storage Billing Method parameter is unavailable, and you are charged for storage based on the pay-as-you-go billing method.
   Storage Cost	You do not need to specify the required storage when you set the Storage Billing Method parameter to Pay-as-you-go. You are charged for storage usage on an hourly basis in PolarDB. In addition, you can purchase storage plans based on your business requirements. For more information about how to purchase a storage plan, see Purchase a storage plan.
   Storage Capacity	The amount of storage capacity that you want to purchase for your cluster. The storage capacity of a PolarDB cluster of Enterprise Edition ranges from 50 GB to 500 TB, in 10 GB increments. Note If you set the Product Type parameter to Subscription and the Storage Billing Method parameter to Subscription, the Storage Capacity parameter is available.
   Cluster Name	The name of the cluster. The name must meet the following requirements: The name must be 2 to 128 characters in length, and can contain letters, digits, periods (.), underscores (_) and hyphens (-). The name must start with a letter. The name must start with a letter. The name can contain digits, periods (.), underscores (_), and hyphens (-). If you leave this field empty, the system automatically generates a cluster name. You can change the cluster name after the cluster is created.
   Purchase Plan	The subscription duration of the new cluster. Note This parameter is valid only when the Billing Method parameter is set to Subscription.
   Number	The number of clusters that you want to purchase.

6. Complete the payment based on the billing method you select.

   • Pay-as-you-go

     You must read and agree to the Terms of Service and specific terms of services that you select before you click Buy Now.

   • Subscription

     1. You must read and agree to the Terms of Service and specific terms of services that you select before you click Buy Now.

     2. On the Purchase page, confirm the order and the payment method, and click Subscribe.

   Note

   After you complete the payment, it takes 10 to 15 minutes to create the cluster. Then, you can view the new cluster on the Clusters page.

Related API operation