All Products
Search
Document Center

Restore ApsaraDB RDS for MySQL databases within seconds

Last Updated: May 30, 2020

Database Backup (DBS) can restore terabytes of data within ten seconds based on technologies such as database physical backup and snapshot mounting. It also provides read and write capabilities to meet the requirements for data restoration after incorrect operations, recovery rehearsals, emergency disaster recovery, DevOps, and data analytics.

Click here to request a free trial of DBS>>.

How it works

DBS can restore data within seconds. You must create a physical backup instance and enable second-level restoration in the DBS console. The system automatically obtains full data, and captures incremental data on a regular basis. The system then merges the full and incremental data and generates snapshots at specified points in time, such as every 10 minutes. You can select any of these snapshots for database restoration.1

Scenarios

Data restored by the second-level restoration feature is stored in a storage pool, and the read and write performance of the restored data is limited by the storage pool. Therefore, we recommend that you do not use this feature for long-term disaster recovery. If you need to use the database on a long-term basis, we recommend that you initiate regular restore tasks to restore the database to a server with higher performance.

The second-level restoration feature is applicable in the following scenarios:

  • Temporary emergency disaster recovery
  • Regular recovery rehearsals
  • Application development and testing
  • DevOps for continuous development
  • Implementation of runtime analysis and report procedures without affecting the production database
  • Building of a public cloud database environment to migrate local databases onto the cloud

Limits

  • The second-level restoration feature supports only built-in storage and does not support OSS. For more information about the available storage types for the backup data, see Built-in storage and OSS.

Procedure

1. Enable second-level restoration

Log on to the DBS console. On the Backup Schedules page, click the backup schedule to go to the Configure Task page. In the Task Running Information section, click Set up second level recovery.
The second-level restoration task enters the Data preparing state.

2. Start a second-level restoration task

After the data has been prepared, a time range is displayed. Data within this time range will be restored through second-level restoration. Click Second level recovery database in the upper-right corner of the Configure Task page to start a second-level restoration task.1
Select a point in time and VPC.

3. Obtain the mount target of the backup data

In the left-side navigation pane of the Configure Task page, click Second level recovery task. On the page that appears, view the restoration progress and NFS mount target.

2