Data Management:Emergency recovery for a self-hosted MySQL database

Billing

This solution involves the following fees:

Step 1: Create a backup schedule

Go to the DBS purchase page to create a backup schedule. For more information, see Create a backup schedule.

Step 2: Configure the backup schedule

For more information, see Configure a physical backup schedule for a MySQL database.

Step 3: Configure a disaster recovery policy

Enable the sandbox feature and configure a sandbox policy to quickly restore data to an RDS temporary instance that serves as a disaster recovery instance.

1. Log on to Data Management Service (DMS) 5.0.

2. In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

3. On the Backup Schedules page, click Manage in the Actions column corresponding to a backup schedule.

4. On the Configure Task page, click Set Sandbox Feature in the Sandbox Information section.

5. In the Set Sandbox Policy dialog box, enable the sandbox and set the data retention period in days.

   Parameter	Description
   Sandbox feature	Turn on the switch to enable this feature.
   Sandbox data retention period	Specifies how many days sandbox snapshots are retained. The default retention period is 7 days. A sandbox snapshot becomes available after creation and is automatically deleted when its retention period ends. Deletion removes only the incremental snapshot backup, that is, the changes relative to the previous snapshot. A longer retention period requires more storage space and incurs higher storage fees. If you want to keep only the most recent snapshot, you can set the retention period to 0.

6. Click OK.

   After you enable the sandbox feature, the Sandbox Instance Time Range in the DBS console displays Data preparing. The first time you enable the feature, the system copies the latest full backup set to the sandbox storage and generates a mountable snapshot. Depending on the size of the backup data, this process may take 5 to 20 minutes.

   When the Sandbox Instance Time Range displays a specific available time range, you can create an RDS temporary instance and restore data to it.

   When the sandbox feature is ready, the Sandbox Information panel also displays status information such as Instance Count and Total Sandbox Storage Capacity.

   The following table describes the Sandbox instance time range status.

   Sandbox state	Description
   Sandbox feature disabled	Displays Not enabled.
   Preparation phase after enabling	Displays Data preparing.
   Preparation complete	Displays the restorable time range for the sandbox instance. Note This is the time range covered by the existing backup sets.

Step 4: Perform a disaster recovery

Create an RDS temporary instance to quickly restore data when a disaster occurs in your self-managed MySQL database.

1. Log on to Data Management Service (DMS) 5.0.

2. In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

3. Find the target backup schedule ID and click Manage in the Actions column on the right.

4. On the Sandbox Instance Tasks page, click Recover Sandbox Instance.

5. In the dialog box, configure the following parameters.

   Section	Parameter	Description
   Sandbox instance point in time	Sandbox data time range	Displays the recoverable time range from the first sandbox snapshot to the current time. The actual recoverable range may be shorter. Note Data can be recovered for the period from the first snapshot in the sandbox storage to the end time of the last binlog in the log backup. However, recovery is not guaranteed for data from the last binlog to the current time.
   	Recovery method	Restore by snapshot time point: You can only select a time point from an existing snapshot, and the restoration time is shorter. Recovery by custom point in time: If you enabled incremental log backup, you can restore to any point in time within the recoverable range. The recovery duration depends on the size of the logs that need to be applied. If incremental log backup is not enabled, you can restore only to the time points of full backups.
   Sandbox instance configurations	Sandbox instance type	RDS Instance. This is a fixed value.
   	Edition	Select the edition for the new sandbox instance. For more information, see Product Edition Overview.
   	Instance region	Defaults to the region of the backup schedule. This setting cannot be changed.
   	Peer VPC	Select Virtual Private Cloud (VPC). Note To access a sandbox instance from an ECS instance, ensure that the VPC where the ECS instance is located is selected here. To learn how to create a VPC, see Create and manage a Virtual Private Cloud.
   	Peer vSwitch	Select the target vSwitch to specify the IP address range for accessing the sandbox instance.
   	Instance specification	Select the specifications for the new sandbox instance. The available specifications are subject to what is displayed in the console.

6. Click OK.

   The system runs a pre-check and automatically creates an RDS for MySQL temporary instance. When the Sandbox Instance Status changes to Completed, you can click the address link in the Sandbox Instance Address column to go to the RDS console and access the temporary instance.

   The sandbox instance list also displays information such as Recovery point in time, Sandbox instance specification, and Recovery duration. The Actions column provides a Release sandbox instance link. You can use this link to release the temporary instance when it is no longer needed.

Related operations