This topic describes how to restore the data of an RDS for MySQL instance across regions. Specifically, you can restore data to a new RDS instance in the source or destination region.

Prerequisites

You have completed a cross-region backup. For more information, see Back up data across regions.

Precautions

  • If the original RDS instance has the database proxy enabled and does not have a superuser account, you may need to reset the password to connect to the new RDS instance to which data is restored.
  • You cannot restore data to the original RDS instance by using a cross-region backup file.

Procedure

  1. Log on to the RDS console.
  2. In the left-side navigation pane, click Cross-region Backup.
  3. Find the target RDS instance and click its ID.
    跨地域恢复
  4. On the Data Backup tab, find the target backup set and in the Actions column click Restore.
    选择备份
  5. On the Restore Database page, click the Subscription or Pay-As-You-Go tab and set the following parameters.
    Parameter Descripition
    Restore Mode
    • By Backup Set: You can restore the data in the selected backup set to the new RDS instance.
    • By Time: You can select any time point within the log backup retention period to restore the data from this time point to the new RDS instance.
    Backup Set When the Restore Mode parameter is set to By Backup Set, you must select a backup set for data restoration.
    Restore Point When the Restore Mode parameter is set to By Time, you must select a time point from which you want to restore data.
    Note Both local and cross-region log backup sets can be used for time-based data restoration.
    Region The ID of the region where the new RDS instance is located. You can use a cross-region backup set to restore data only to a new RDS instance in the source or destination region.
    Zone An independent physical area within a region. Different zones in the same region are basically the same. The new RDS instance can be located in the same region or in a different region from the ECS instance.
    CPU and Memory The type (including CPU and memory specifications) of the new RDS instance. Each instance type supports a specific number of CPU cores, memory size, maximum number of connections, and maximum IOPS. For more information, see Instance types.
    Capacity Used for storing data, system files, binary log files, and transaction files.
    Network Type
    • Classic Network: a classic network.
    • VPC (recommended): A VPC is an isolated network environment that provides better security and performance than a classic network. If you select VPC, you must also select a VSwitch.
  6. Optional. If the new RDS instance uses the Subscription billing method, set the Duration and Quantity parameters.
  7. Click Buy Now.
  8. On the Order Confirmation page, select Terms of Service, Service Level Agreement, and Terms of Use, then click Pay Now to complete the payment.

What to do next

In the upper-left corner of the RDS console, select the region where the new RDS instance is located, then you can view the new RDS instance.

After the new RDS instance is created, you must configure a whitelist and create accounts. If you want to connect to the new RDS instance through the Internet, you must also apply for a public IP address. Then you can connect to the new RDS instance.

APIs

API Description
CheckCreateDdrDBInstance Used to check whether an RDS instance has a cross-region backup set that can be used for cross-region restoration.
CreateDdrInstance Used to restore data to a new RDS instance in the specified destination region.
ModifyInstanceCrossBackupPolicy Used to modify cross-region backup settings.
DescribeInstanceCrossBackupPolicy Used to query cross-region backup settings.
DescribeCrossRegionBackups Used to list cross-region data backup files.
DescribeCrossRegionLogBackupFiles Used to list cross-region log backup files.
DescribeAvailableCrossRegion Used to query the destination regions available to a specified region.
DescribeAvailableRecoveryTime Used to query the time period to which a selected backup file can restore an RDS instance.
DescribeCrossRegionBackupDBInstance Used to query the cross-region backup settings in a specified region.