Migrate the data of a self-managed MySQL instance to the cloud

Billing

Import the full backup file into the destination RDS instance

1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups.
2. On the Next tab, click 3. Import Data. In the Import Backup wizard, read the messages that are displayed and click Next until you enter the Data import step.
   Note The Import Backup wizard walks you through the migration process.

   • 1. Back Up Source Database: Perform a full backup on the self-managed MySQL instance. For more information, see Migrate the data of a self-managed MySQL 5.7 or MySQL 8.0 instance to the cloud.
   • 2. Upload Backup Files to OSS: Upload the full backup file to an OSS bucket. For more information, see Migrate the data of a self-managed MySQL 5.7 or MySQL 8.0 instance to the cloud.
3. Configure the following parameters and click OK.

   Parameter	Description
   Region	Select the region that you specified in Step 1. The selected region must be the region to which the OSS bucket that stores the full backup file belongs.
   OSS Bucket	Select the OSS bucket that stores the full backup file of the self-managed MySQL instance. For more information, see Upload objects.
   OSS file name	Select the full backup file that is stored as an object in the OSS bucket. You can enter the name of the full backup file in the OSS file name field to search for the file. This search feature supports fuzzy match and exact match.
   Note	Enter a description that helps you identify the full backup file.
   Zone	Select the zone to which the OSS bucket that stores the full backup file belongs. After you select a zone, ApsaraDB RDS creates a snapshot in the zone in single-digit seconds. This greatly reduces the time that is required to import the full backup file into the OSS bucket. Note After the full backup file is imported into ApsaraDB RDS, you can restore the data of the full backup file to a new RDS instance. The new RDS instance resides in the zone that you select.
   Storage Capacity	Specify the amount of storage space that is required for the full backup file. Valid values: 20 to 6000: Unit: GB. Note By default, the amount of storage space required is 3 times the size of the full backup file. If the file size multiplied by 3 does not exceed 20 GB, this parameter defaults to 20.

   Note If ApsaraDB RDS is not authorized to access OSS, click Authorize in the lower part of the 3. Import Data step. In the lower-left corner of the page that appears, click Confirm Authorization Policy.
4. After ApsaraDB RDS creates a task to check the full backup file, wait until the Status of the task changes from Verifying to Completed. You can view the status of the task on the User Backups tab.
   Note The time that is required to complete the task varies based on the status of the self-managed MySQL instance during the full backup. For example, if a large number of redo log records are generated from a large number of write operations or large transactions are run during the full backup, the time that is required to complete the task increases.

Restore the data of the full backup file to a new RDS instance

1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups.
2. Find the full backup file. Then, click Restore in the Actions column to the right of the Backup ID/Name column.
3. Configure the following parameters and click Next: Instance Configuration.

   Parameter	Description
   Zone of Primary Node	The zone to which the primary RDS instance belongs. Note If you did not select a zone for the OSS bucket that stores the full backup file when you import the file, this parameter is displayed. If you selected a zone for the OSS bucket that stores the full backup file when you import the file, this parameter is not displayed.
   Storage type	ESSD PL1: An enhanced SSD (ESSD) of performance level 1 (PL1) is a regular ESSD. Standard SSD: A standard SSD is an elastic block storage device that is designed based on the distributed storage architecture of Alibaba Cloud. You can store data on standard SSDs to separate computing from storage. Note For more information about storage types, see Storage types.
   Instance Type	General-purpose: specifies the general-purpose instance family. A general-purpose instance exclusively occupies the allocated memory and I/O resources. However, it shares CPU and storage resources with the other general-purpose instances that are deployed on the same server. Note Each instance type supports a specific number of cores, memory capacity, maximum number of connections, and maximum IOPS. For more information, see Primary ApsaraDB RDS instance types.
   Capacity	The storage capacity that is used to store data files, system files, binary log files, and transaction files in the RDS instance. You can adjust the storage capacity at a step size of 5 GB.

4. Configure the following parameters and click Next: Confirm Order.

   Parameter	Description
   Network Type	The network type of the RDS instance. Select VPC. A virtual private cloud (VPC) is an isolated network that provides higher security and better performance than the classic network. If you select the VPC network type, you must also specify the VPC and vSwitch of Primary Node parameters. Note The RDS instance and the Elastic Compute Service (ECS) instance that you want to connect must reside in the same VPC. Otherwise, the RDS instance and the ECS instance cannot communicate over an internal network.
   Parameter Template	The parameter template that is used by the RDS instance. You can select a system parameter template or a custom parameter template. For more information, see Use a parameter template to manage parameters.
   Time Zone	The time zone of the RDS instance.
   Table Name Case Sensitivity	Specifies whether table names in the RDS instance are case-sensitive. If table names in the self-managed MySQL instance are case-sensitive, we recommend that you select Case-sensitive to facilitate data migration between the RDS instance and the self-managed MySQL instance.

5. Confirm the configuration of the RDS instance in the Parameters section, configure the Purchase Plan parameter, read and select Terms of Service, and then click Pay Now to complete the payment.
   Note ApsaraDB RDS requires 1 minute to 5 minutes to create the RDS instance. Wait until the instance is created.

Set the retention period of the full backup file

By default, the full backup file is retained for three days after it is imported into ApsaraDB RDS. For more information, see the "Import the full backup file into the destination RDS instance" section in this topic. You can adjust the retention period based on your business requirements.

1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups.
2. Click Set Retention Period in the Expiration Time column to the right of the Backup ID/Name column.
3. In the dialog box that appears, select a retention period from the drop-down list provided by ApsaraDB RDS. Alternatively, select Custom Retention Period, and then enter a retention period or click the up and down arrows to adjust the retention period.
   Note Expiration Time shows the expiration time of the full backup file. If the expiration time exceeds 2099, it is displayed as Permanent.
4. Click OK.

Add tags to the full backup file

After the full backup file is imported into ApsaraDB RDS, you can add tags to the file.

1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups.
2. Click +Add Tag in the Tags column to the right of the Backup ID/Name column.
3. Click Create Tag, enter the Key and Value of the tag, click OK to the right of the field to create the tag, and then click OK in the lower-right corner of the dialog box to add the tag.
   Note If you have created a tag, click Select Tag to add the tag to the full backup file.
4. If you want to change the tag of the full backup file, move the pointer over the tag and click Edit. In the tooltip that appears, repeat Step 3 to create or select a tag.

Check the information about the binary log data of the full backup file

If data changes are made in the self-managed MySQL instance during the full backup, the generated full backup file contains the information about binary log data. You can use the binary log data to restore the incremental data. For more information, see Migrate the data of a self-managed MySQL 5.7 or MySQL 8.0 instance to the cloud.

1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups.
2. Click View Details in the Actions column to the right of the Backup ID/Name column.
3. In the message that appears, check the information about the binary log data.
   Note Binlog Information includes the following information:

   • Master_Log_File:: the name of the first binary log file that shows incremental data.
   • Master_Log_Position:: the first log record that shows incremental data in the first binary log file showing incremental data.

Delete the full backup file

If you no longer need the full backup file, you can delete the file to save costs.

1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups.
2. Click Delete in the Actions column to the right of the Backup ID/Name column.
3. In the message that appears, click OK.

Other features

• Filter Columns: You can click the icon to show or hide columns on the User Backups tab. By default, the tab shows all columns.
  1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups. On the page that appears, click the User Backups tab.
  2. In the upper-right corner of the tab, click the icon. In the dialog box that appears, select the columns that you want to display or hide, and click the or icon to move the columns.
     Note The columns in the left-side list are hidden, and the columns in the right-side list are displayed.
  3. Click OK.
• Export Instance List : You can click the icon to export the backup information as a CSV file.
  1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups. On the page that appears, click the User Backups tab.
  2. In the upper-right corner of the tab, click the icon to export the backup information.
• Refresh: You can click the icon to refresh the User Backups tab.
  1. Log on to the ApsaraDB RDS console. In the top navigation bar, select a region. In the left-side navigation pane, click Backups and then click User Backups tab.
  2. Click the icon to refresh the User Backups tab.

Related operations

• Import a full backup file
• Modify a full backup file
• Query full backup files
• Delete a full backup file