Database Backup (DBS) allows you to perform disaster recovery drills to rehearse a database restore on a regular basis. You can perform disaster recovery drills to verify whether the backup data is correct and whether 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 prevent disaster recovery failures, we recommend that you perform disaster recovery drills on a regular basis to ensure that your disaster recovery system remains effective.

To perform traditional disaster recovery drills, you must deploy a large number of additional server devices. In contrast, DBS allows you to perform disaster recovery drills without the need to purchase or deploy additional machine devices. Integrated with 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 disaster recovery drill report is generated. After the drill is complete, DBS deletes the sandbox instance. This way, you can conveniently perform recovery drills at minimal costs.

Billing

The disaster recovery drill feature is free of charge.

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

Prerequisites

  • The data source for which you want to restore data resides in one of the following regions: China (Beijing), China (Shanghai), China (Hangzhou), and China (Shenzhen). The disaster recovery drill feature is available only in the preceding regions.
  • The data source uses one of the following database versions:
    • Self-managed MySQL databases: 5.6 and 5.7
    • ApsaraDB RDS for MySQL databases that use local SSDs: 5.6, 5.7, and 8.0
  • The data source uses the physical backup method, and the sandbox feature is enabled for your backup schedule. For more information, see Enable the sandbox feature.

Enable the disaster recovery drill feature

  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.
  3. Find the data source for which you want to restore data and click Recovery Drill in the Actions column.
    Data Source-Recovery Drill
    Note You can also click Set recovery drill on the details page of a backup schedule to enable the disaster recovery drill feature. The configuration parameters are the same as those described in this topic.
  4. Set the following parameters.
    Parameter Description
    Schedule Name The backup schedule that you want to use.
    Recovery drill enable Specifies whether to enable the disaster recovery drill feature. Valid values: Enable and Disable.
    Recovery drill frequency The frequency at which you want to perform disaster recovery drills. Default value: Regular.
    Recovery drill cycle The days on which you want to perform disaster recovery drills during a week. For example, if you select Monday and Friday, the system performs disaster recovery drills every Monday and Friday.
    Note You must select at least one day from a week.
    Recovery drill start time The start time for each disaster recovery drill. Select an exact hour of the day.
    Recovery drill data The backup data for which you want to perform a disaster recovery drill. By default, DBS restores the latest backup data set.
    Recovery drill targetType 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 disaster recovery drill. You do not need to purchase additional devices. Default value: DBS sandbox instance.
    Report receiver The email address used to receive the reports of disaster recovery drills.
    Database Account The username of a database account that has the query permissions.
    Password The password of the database account.
    Note If you do not set this parameter, DBS uses the password of the data source by default.
    Set recovery drill
  5. Click OK.
    The disaster recovery drill feature is enabled. DBS performs a disaster recovery drill at the next start time as scheduled. The execution time depends on the backup data size.

View the reports of disaster recovery drills

  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.
  3. Click the ID of the data source for which disaster recovery drills are performed.
    Data Source
  4. Click the name of the DBS backup schedule on which disaster recovery drills are performed.
    The details page of the backup schedule appears.
  5. In the left-side navigation pane, click Recovery drill list.
  6. Find the disaster recovery drill that you want to view and click View report in the Actions column.
    View report