Updated on 2024-10-14 GMT+08:00

Restoring Data Across Regions

Scenarios

RDS for MySQL supports cross-region backups. If a DB instance in one region fails, you can use backups stored in another region to restore data to a new instance in that region.

Prerequisites

  • Cross-region backups have been created. For details, see Configuring a Cross-Region Backup Policy.
  • Encrypted backups cannot be used to restore data to existing instances.
  • Instances with Transparent Data Encryption (TDE) enabled do not support cross-region restoration.
  • The kernel version of the target instance cannot be earlier than that of the original instance.

Restoring a Full Backup Across Regions

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. In the upper part of the page, select the region where the backup is stored.
  5. In the navigation pane on the left, choose Backups. On the displayed page, click the Cross-Region Backups tab.
  6. Locate the instance you want to restore and click View Cross-Region Backup in the Operation column.
  7. On the Full Backups page, locate the backup you want to restore and click Restore in the Operation column.

    Figure 1 Full backups

  8. In the displayed dialog box, select a restoration method and click OK.

    Create New Instance: Set parameters for the new instance and click Buy.
    Figure 2 Creating a new instance
    • The DB engine and version of the new instance are the same as those of the original instance and cannot be changed.
    • Other settings are the same as those of the original instance by default and can be modified. For details, see Buying an RDS for MySQL DB Instance.

Restoring an Incremental Backup Across Regions

  1. In the upper part of the page, select the region where the backup is stored.
  2. In the navigation pane on the left, choose Backups. On the displayed page, click the Cross-Region Backups tab.
  3. Locate the instance you want to restore and click View Cross-Region Backup in the Operation column.
  4. On the Binlog Backups page, click Restore to Point in Time.

    Figure 3 Restoring an incremental backup

  5. Select the restoration date and time range, enter a time point within the selected time range, and select a restoration method. Then, click OK.

    Create New Instance: Set parameters for the new instance and click Buy.
    • The DB engine and version of the new instance are the same as those of the original instance and cannot be changed.
    • Other settings are the same as those of the original instance by default and can be modified. For details, see Buying an RDS for MySQL DB Instance.