Database Backup provides an emergency recovery feature to automatically obtain backup sets and generate snapshots. An ApsaraDB RDS emergency instance (DBS sandbox instance) can be generated within a minute.

Background information

DBS provides a complete sandbox solution for MySQL and Oracle databases based on copy data management (CDM). You can use the DBS sandbox feature to restore data in a backup set within seconds. Read and write operations performed within sandbox instances do not affect source databases. You can perform a variety of operations in sandbox instances, such as analysis, testing, and verification. For more information, see Overview.

Billing

ApsaraDB RDS provides the physical backup feature for ApsaraDB RDS instances and charges the corresponding fees.

After you enable the emergency recovery (DBS sandbox) feature, DBS charges you based on the storage capacity and specifications of sandboxed instances. For more information, see DBS sandbox fees.

Prerequisites

  • An ApsaraDB ApsaraDB RDS for MySQL database with local SSDs is used.
  • The database must reside within one of the following regions:
    • China (Beijing)
    • China (Shanghai)
    • China (Hangzhou)
    • China (Shenzhen)
  • A virtual private cloud (VPC) is created to connect to emergency instances. For more information, see Create a default VPC network and vSwitch.

Enable the emergency recovery feature

You must enable the emergency recovery feature before you can create an emergency instance. No fees are incurred when you enable the emergency recovery feature.

  1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the RDS instance resides.
    Select a region
  2. On the page that appears, find the instance for which you want to enable emergency recovery and click its ID.
  3. In the left-side navigation pane, click Backup and Restoration.
  4. On the Backup and Restoration page, click the Crash Recovery tab.
    Emergency instance
  5. Click Enable/Manage DBS Emergency Recovery.
    You are redirected to the DBS console.
  6. In the Backup Configuration dialog box, configure the following parameters and click OK.
    Sandbox backup configurations
    Note
    • Billing Method: the billing method for the sandbox instance. You can select only Commercial Capacity. For more information, see DBS sandbox fees.
    • Retention Period: the number of days for which you want to retain the sandbox instance. By default, the instance is retained for seven days.
  7. Click Done.
    The emergency recovery (sandbox) feature is enabled.

Create an emergency instance

  1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the RDS instance resides.
    Select a region
  2. On the page that appears, find the instance for which you enable emergency recovery and click its ID.
  3. In the left-side navigation pane, click Backup and Restoration.
  4. On the Backup and Restoration page, click the Emergency Recovery tab.
  5. Click Create Emergency Instance (DBS sandbox instance).
    You are redirected to the DBS console. In the DBS console, click the backup schedule to go to the Backup Schedule Configuration page.
  6. On the Configure Task page, click Create a sandbox instance in the upper-right corner.
  7. On the Create a sandbox instance task page, configure the following parameters.
    Create a sandbox instance task
    Section Parameter Description
    N/A Task Name The name of the restoration task. DBS generates a task name. We recommend that you set a descriptive name that makes it easy to identify. Task names do not have to be unique.
    Set Time Restored To Time Range Available to Restore The time range available to restore the source instance. DBS displays the available time range.
    Restore To The point in time to which you want to restore the source instance. The value must be within the time range that is specified by the Time Range Available to Restore parameter.
    Sandbox instance information settings Sandbox instance target The following types are supported:
    • NFS remote disk: creates an NFS remote file system that contains all database files. You must mount the file system on a client in a VPC and start the database instance.
    • DBS sandbox instance: allows you to create a DBS-managed database instance and remotely connect to the instance.
    Instance Region The region where the sandbox instance is deployed.
    Peer VPC The VPC to which the sandbox instance belongs.
    Peer VSwitch The VSwitch to which the sandbox instance belongs.
    Authorize DBS configuration to DAS Specifies whether to authorize Database Autonomy Service (DAS) to configure DBS. If you select this option, the system activates DAS of the Basic Edition that is free of charge for the new sandbox instance.
    Note DAS ensures the stability, security, and efficiency of databases. For more information, see What is DAS?
  8. Click Recover immediately.
    The system performs prechecks and goes to the Sandbox Instance Tasks page. When Status changes to Running, you can access the emergency instance. Sandbox endpoint