All Products
Search
Document Center

PolarDB:Restore a released cluster

Last Updated:Mar 27, 2024

This topic uses a PolarDB for PostgreSQL cluster as an example to describe how to restore clusters in Cluster Recycle.

Usage notes

  • Released clusters in Cluster Recycle must have at least one backup set. If all backup sets of a cluster have been deleted, the cluster cannot be restored.

  • After a cluster is released, the data of all released clusters in Cluster Recycle is archived asynchronously to level-2 backups at a rate of approximately 150 MB/s. For more information about backup, see Overview.

Procedure

  1. Log on to the PolarDB console.

  2. In the top navigation bar, select the region in which the cluster that you want to manage is deployed.

  3. In the left-side navigation pane, click Cluster Recycle Bin.

  4. Find the cluster that you want to restore, and click Restore Data to New Cluster in the Actions column.

    恢复数据到新集群

  5. Set Billing Method to Subscription or Pay-As-You-Go.

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

    • Pay-As-You-Go: An upfront payment is not required. You are charged fees for the compute nodes and the storage that is consumed by your data. The fees are deducted from your account balance on an hourly basis.

  6. Configure the parameters that are described in the following table.

    Parameter

    Description

    Region

    The region where the cluster is deployed. You cannot change the region after the cluster is created.

    Note

    Make sure that the PolarDB cluster and the Elastic Compute Service (ECS) instance to which you want to connect are deployed in the same region. Otherwise, the PolarDB cluster and the ECS instance can communicate only over the Internet, which degrades cluster performance.

    Creation Method

    Select Restore from Recycle.

    This value indicates that the deleted database is restored from Cluster Recycle.

    Source Version

    Select the version of the released cluster.

    Deleted Clusters

    Select the name of the deleted cluster.

    Backup History

    Select the backup set to restore.

    Note

    The timestamps of the backups in the Backup History drop-down list are displayed in UTC. The timestamps of backups in the Backups list are displayed in the system time format. Make sure that you choose the correct historical backup. For example, the timestamp of a backup set in the Backup History is 2020-05-08T02:00:00Z. The corresponding timestamp in the backup list is 10:00:00 on May 8, 2020 (UTC+08:00).

    Database Engine

    The database engine version of the PolarDB cluster. The default version is the same as the version of the deleted cluster and cannot be changed.

    Database Edition

    The database edition of the PolarDB cluster. Select Enterprise Edition.

    Edition

    Only Cluster Edition (Recommended) is supported. You do not need to change this parameter value.

    CPU Architecture

    Enterprise Edition: The CPU architecture of the PolarDB cluster. This parameter is automatically set to the CPU architecture of the released cluster. You do not need to change this parameter value.

    Nodes

    Enterprise Edition: If your source cluster is of Cluster Edition (Recommended), the cluster consists of one primary node and one read-only node by default. You can select two nodes (a primary node and a read-only node) or one node (a primary node).

    Primary Zone

    The primary zone in which the cluster is deployed.

    • A zone is an independent geographical location in a region. All zones in a region provide the same level of service performance.

    • You can deploy your PolarDB cluster and ECS instance in the same zone or in different zones.

    • You need to specify only the primary zone. The system automatically selects a secondary zone.

    Enable Hot Standby Cluster

    Select whether to Enable Hot Standby Cluster.

    Specification

    Select General-purpose or Dedicated for Cluster Edition (Recommended)Cluster Edition.

    • Dedicated: Computing resources such as CPUs that are allocated to each cluster are exclusive to the cluster. This improves the stability and reliability of the cluster.

    • General-purpose: Idle computing resources such as CPUs are shared among clusters on the same server for cost-effectiveness.

    PolarProxy Type

    By default, this parameter is set to Dedicated Enterprise.

    Storage type

    PolarDB provides two storage types: PSL5 and PSL4.

    • PSL5: the storage type supported in the historical versions of PolarDB. It 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 keep a high disk performance.

    Note

    The storage types of existing clusters cannot be changed. To use PSL4, we recommend that you purchase a new cluster, set the storage type to PSL4, 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 is provided based on a serverless architecture. This way, you do not need to specify the storage capacity when you purchase clusters. The storage capacity of the clusters can be automatically scaled up as the volume of data increases. You are charged for the actual data volume.

    • Subscription: You must purchase a specific amount of storage capacity when you create the cluster.

    Storage Cost

    You do not need to specify this parameter. You are charged on an hourly basis based on the actual storage that you use. For more information, see Specifications and pricing.

    Note

    You do not need to specify the storage capacity when you create a cluster. The system scales the storage capacity when the amount of data is increased or decreased.

    Storage Capacity

    The amount of storage capacity that you want to purchase for your cluster. The storage capacity ranges from 50 GB to 100 TB, in 10 GB increments.

  7. Click Next: Cluster Configurations and configure the following parameters.

    Parameter

    Description

    Cluster Name

    The name of the cluster. The name must meet the following requirements:

    • It cannot start with http:// or https://.

    • It must be 2 to 256 characters in length.

    If this parameter is left empty, the system automatically generates a cluster name. You can change the cluster name after the cluster is created.

    Resource Group

    Select a resource group from the drop-down list. For more information, see Create a resource group.

    Note

    A resource group is a group of resources that belong to an Alibaba Cloud account. Resource groups allow you to manage resources in a centralized manner. A resource belongs to only one resource group. For more information, see Use RAM to create and authorize resource groups.

    Network Type

    Configure the virtual private cloud (VPC) and vSwitch.

    The network type can only be VPC. You do not need to configure this parameter. Make sure that the PolarDB cluster is created in the same VPC as the ECS instance to which you want to connect. Otherwise, the cluster and the ECS instance cannot communicate over an internal network to achieve optimal performance.

    • If an existing VPC meets your network requirements, select the VPC. For example, if you have an existing ECS instance and the VPC to which the ECS instance belongs meets your network requirements, select this VPC.

    • Otherwise, use the default VPC and the default vSwitch.

      • Default VPC:

        • Only one VPC is specified as the default VPC in the region that you select.

        • The CIDR block of the default VPC uses a 16-bit subnet mask. For example, the CIDR block of the default VPC can be 192.168.0.0/16. This CIDR block provides up to 65,536 private IP addresses.

        • The default VPC does not count towards the quota of VPCs that you can create on Alibaba Cloud.

      • Default vSwitch:

        • Only one vSwitch is specified as the default vSwitch in the zone that you select.

        • The CIDR block of the default vSwitch uses a 20-bit subnet mask. For example, the CIDR block of the default vSwitch can be 192.168.0.0/20. This CIDR block provides up to 4,096 private IP addresses.

        • The default vSwitch does not count towards the quota of vSwitches that you can create in a VPC.

    • If the default VPC and vSwitch cannot meet your requirements, you can create your own VPC and vSwitch. For more information, see Create and manage a VPC.

    Enable TDE

    Specifies whether to enable Transparent Data Encryption (TDE). After TDE is enabled, PolarDB encrypts the data files of your cluster. You do not need to modify the code to allow access to your cluster. However, TDE reduces the performance of your cluster by 5% to 10%.

    Note

    TDE cannot be disabled after it is enabled.

    Duration

    Select a Duration for the new cluster.

    Note

    This parameter is available only when Billing Method is set to Subscription.

    Quantity

    Select the number of clusters that you want to purchase.

  8. Complete the rest of the steps based on the billing method of the cluster.

    • Pay-as-you-go

      1. Click Next: Confirm Order.

      2. On the Confirm Order page, confirm the order information, read and select the Terms of Service, and then click Buy Now.

    • Subscription

      1. Click Next: Confirm Order.

      2. On the Confirm Order page, confirm your order information. Read and accept the terms of service, and then click Buy Now.

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

    After you complete the payment, wait 10 to 15 minutes to view the newly created cluster on the Clusters page.

    Note

    The amount of time required to restore data to a new cluster depends on the size of the backup set. It takes more time for the system to restore data from a larger backup set. After the cluster is created, you can return to the PolarDB console and view the new cluster on the Clusters page.

Related API operations

API

Description

CreateDBCluster

Creates a PolarDB cluster.