Database Backup allows you to perform recovery drills to restore databases on a regular basis. You can perform recovery drills to verify whether the backup data is correct and the disaster recovery system is reliable.

Background information

If a disaster occurs, data recovery may fail due to operation errors that occur during the recovery process or invalid backups of the source data. To avoid disaster recovery failures, we recommend that you perform recovery drills on a periodic basis to ensure that your disaster recovery system remains effective.

To perform traditional recovery drills, you must deploy a large number of additional server devices. However, DBS allows you to perform recovery drills without the need to purchase and deploy additional machine devices. Based on Copy Data Management (CDM), DBS allows you to create a database sandbox instance from your backup data. Then, your backup data can be validated and a recovery drill report is generated. After the drill is complete, DBS deletes the sandbox instance to reduce costs and ensure convenient recovery drills.

Billing

The recovery drill feature is free of charge.

You need only to pay for the usage of DBS sandbox instances based on the specification, duration, and storage of the instances. For more information, see DBS sandbox fees.
Note The specification of a MySQL sandbox instance created during a recovery drill is MySQL sandbox instance with one CPU core and 1 GB of memory.

Prerequisites

  • The database is in one of the following versions:
    • Self-managed databases: MySQL 5.6 and 5.7
    • Alibaba Cloud databases (local SSDs): ApsaraDB RDS for MySQL V5.6, 5.7, and 8.0
  • The Sandbox feature is enabled for the backup schedule. For more information, see Step 1: Enable the sandbox feature.

Enable recovery drill

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Data Source. On the Data Source page, select a region in the upper-left corner.
    Select a region
  3. Click recovery drill in the Actions column corresponding to the ID of the data source from which you want to restore data.
    Data Source-recovery drill
    Note You can also click Set recovery drill on the details page of a backup schedule to enable recovery drill. The configuration parameters are the same as those described in this topic.
  4. Configure the parameters described in the following table.
    Parameter Description
    Schedule Name Select a backup schedule.
    Recovery drill enable Valid values: Enable and Disable.
    Recovery drill frequency The frequency on which you want to perform recovery drills. Default value: Regular.
    Recovery drill cycle Select the days you want to perform the recovery drills during a week. For example, if you select Monday and Friday, the system performs the recovery drills every Monday and Friday.
    Note You must select at least one day from a week.
    Recovery drill start time Select the start time for each recovery drill. Unit: hours.
    Recovery drill data The backup data for which you want to perform recovery drill. By default, DBS restores the latest backup data set.
    Recovery drill target Type The type of the instance to which you want to restore the database. By default, the database is restored to a DBS sandbox instance to verify the recovery drill. You do not need to purchase additional devices. Default value: DBS sandbox instance.
    Report receiver Enter an email address to receive the recovery drill report.
    Database Account Enter the username of a database account that has the query permission.
    Password Enter the password of the database account.
    Note If you do not specify this parameter, DBS uses the password of the data source by default.
    Set recovery drill
  5. Click OK.
    Now, the recovery drill feature is enabled. DBS performs the recovery drill at the next start time of recovery drill. The execution time depends on the backup data size.

View the recovery drill report

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Data Source. On the Data Source page, select a region in the upper-left corner.
    Select a region
  3. Click the ID of the data source on which you want to perform recovery drills.
    Data Source
  4. Click the name of the DBS backup plan that you want to perform recovery drills.
    Go to the details page of the backup schedule.
  5. In the left-side navigation pane, click Recovery drill list.
  6. Click View Report in the Actions column corresponding to the ID of the recovery drill based on which you want to restore data.
    View Report