You can use the instance restoration feature of ApsaraDB MyBase for MySQL to restore backup data to a new instance. This topic describes how to restore the data of an ApsaraDB MyBase for MySQL instance.
Prerequisites
Your original instance must meet the following requirements:
The instance is in the Running state and is not locked.
The instance does not have ongoing migration tasks.
If you want to restore data from a log backup generated at a specified point in time, make sure that the log backup feature is enabled for the original instance.
Procedure
Log on to the ApsaraDB for MyBase console.
In the upper-left corner of the Dedicated Clusters page, select the region where the original instance is deployed.
In the left-side navigation pane, click Dedicated Clusters. On the page that appears, find the dedicated cluster that you want to manage and click Details in the Actions column. Then, the Dedicated Cluster Information appears.
In the left-side navigation pane, click Instances. You can use one of the following methods to restore data:
Find the original instance. In the Actions column, click More and then click Restore Database.
Find the original instance, and click Details in the Actions column. On the page that appears, click Backup and Restoration.
Scenario 1: The original ApsaraDB MyBase for MySQL instance uses a local SSD. On the Backup and Restoration page, find the backup that you want to restore. In the Actions column, click
and then click Restore.
Scenario 2: The original ApsaraDB MyBase for MySQL instance uses an enhanced SSD (ESSD). On the Backup and Restoration page, find the backup that you want to restore. In the Actions column, click Restore.
In the Restore Database panel, configure the parameters. The following table describes the parameters.
Parameter
Description
VSwitch
Specify the vSwitch to which the new instance is connected. If no vSwitches are available, click the button below the drop-down list to create a vSwitch.
Restore Mode
By Time: You can restore data from a log backup generated at a specified point in time. The specified point in time must be within the specified log retention period. The time is accurate to the second.
By Backup Set: You can restore data from a specified backup set.
Restore Point
If you select By Time for Restore Mode, you must specify a point in time.
By Backup Set
If you select By Backup Set for Restore Mode, you must specify the point in time at which the backup set from which you want to restore data was generated.
Instance Type
Specify the instance type for the new instance.
Storage Capacity
Specify the storage capacity for the new instance.
Click OK.