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.
You have completed a cross-region backup. For more information, see Back up data across regions.
- 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.
- Log on to the RDS console.
- In the left-side navigation pane, click Cross-region Backup.
- Find the target RDS instance and click its ID.
- On the Data Backup tab, find the target backup set and in the Actions column click Restore.
- 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.
- Optional. If the new RDS instance uses the Subscription billing method, set the Duration and Quantity parameters.
- Click Buy Now.
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.
|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.|