If you have created a cross-region backup, you can use the backup file to restore data to a new instance in the destination region where the backup is stored.
Prerequisites
A cross-region backup is created. For more information, see Cross-region backup.
For more data restoration solutions, see Data restoration overview.
To restore data across regions for an ApsaraDB RDS for MySQL instance, see Restore data across regions for ApsaraDB RDS for MySQL.
To restore data across regions for an ApsaraDB RDS for SQL Server instance, see Restore data across regions for ApsaraDB RDS for SQL Server.
Restore to a new instance across regions
Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Backups. In the top navigation bar, select a region.
On the Cross-region Backup tab, click the Backup Instances tab. Then, click the source instance ID to go to the Cross-region Backup Recovery page.
In the Actions column for the target backup set, click Restore.
In the dialog box that appears, click OK.
NoteYou can restore data only to a new instance. Restoring data to an existing instance is not supported.
On the Restore Database page, configure the following parameters.
Parameter
Description
Billing Method
Subscription : A prepaid billing method where you pay for resources in advance. This option is cost-effective for long-term use and offers greater discounts for longer subscription periods.
Pay-As-You-Go: A postpaid billing method where you are billed hourly for the resources you use. This option is ideal for short-term needs because you can release the instance at any time to save costs.
Restore Mode
By Backup Set: Restores the data from a specific backup set to the new instance.
By Time: Restores data to a specific point in time within the log retention period.
By Backup Set
If you set Restore Mode to By Backup Set, select the backup set that you want to restore.
Restoration Time
If you set Restore Mode to By Time, select the point in time to which you want to restore the data.
NoteBoth local and cross-region log backups can be used for a point-in-time recovery (PITR).
Region
The destination region for the new instance.
Zone
You can deploy an instance in a single zone or across multiple zones:
Single-zone deployment: The primary and standby nodes are deployed in the same zone.
Multi-zone deployment (recommended): The primary and standby nodes are deployed in different zones to support disaster recovery.
NoteAfter you create an instance, you can view information about its primary and standby nodes on the Service Availability page.
RDS Basic Edition instances support only single-zone deployment.
Instance Type
Each instance type offers different vCPU cores, memory, maximum connections, and maximum IOPS. For more information, see Primary instance types.
Capacity
The storage capacity, which includes space for data, system files, binlog files, and transaction files.
Duration
This parameter is required only if you select Subscription for the billing method.
NoteParameters such as the database engine, version, and edition are inherited from the source instance and cannot be changed.
Click Next: Instance Configuration and configure the network and resource group parameters.
Parameter
Description
Network Type
VPC: A virtual private cloud (VPC) is an isolated network environment that offers better security and performance than the classic network. If you select this network type, you must specify the VPC and VSwitch of Primary Node. If you selected Multi-zone Deployment in the previous step, you must also specify the VSwitch of Secondary Node.
Resource Group
The resource group for the new instance.
-
Click Next: Confirm Order.
Review the parameter settings and select the quantity. For subscription instances, also select the subscription duration. Click Pay Now and complete the payment.
NoteFor subscription instances, we recommend that you enable Auto-renewal to avoid manual renewals and prevent service interruptions caused by forgetting to renew.
(Optional) After the instance is created, log on to it to verify the data. For more information, see Connect to an ApsaraDB RDS for PostgreSQL instance.
Related topics
After you create an instance, you must configure an IP address whitelist and create an account. If you want to connect to the instance over the public network, you must also apply for a public endpoint. You can then connect to the instance.