Migrate a MySQL database from Google Cloud to Alibaba Cloud

Edit in GitHub

Last Updated: Jul 15, 2020 Edit in GitHub

This topic describes how to migrate a MySQL database from Google Cloud to Alibaba Cloud and the corresponding precautions.

Prerequisites

You have created an Alibaba Cloud RDS MySQL instance.
You have created an account with read/write privileges.

Limits

Structure migration does not support migration of events.
For MySQL databases, DTS reads floating-point values (FLOAT and DOUBLE data types) with round(column,precision). If the column definition does not specify the precision, the precision is 38 for FLOAT values and 308 for DOUBLE values.
If the object name mapping function is used for an object, migration of objects relying on the object may fail.
For incremental migration, you must enable binlog for the source MySQL instance.
For incremental migration, binlog_format of the source database must be set to ROW.

Note You can modify parameters of Google Cloud databases by choosing Instance details > Configuration > Edit configuration > Add database flags.
For incremental migration, if the source database version is MySQL 5.6 or later, binlog_row_image must be set to FULL.
For incremental migration, if the source instance has binlog file ID disorder caused by cross-host migration, the incremental migration may have data loss.

Precautions

DTS automatically attempts to recover abnormal tasks of the past seven days. This may cause the new data in the target instance to be overwritten by the source database data. Therefore, you must revoke the write permission of the DTS account that is used to access the target instance by running the revoke command.

Procedure

Log on to your database instance on Google Cloud. On the Instance details page, view Public IP address.

Note If a public IP address is not enabled, perform related settings by going to Configuration > Edit configuration > Set connectivity.
Choose Configuration > Edit configuration > Set connectivity > Add network, and then add the IP address of the region of the source database instance obtained from DTS.
Log on to the DTS console.
In the left-side navigation pane, click Data Migration. In the right pane, click Create Migration Task in the upper-right corner.

Enter information about the source and target databases. The following table describes the parameters.


Database type	Parameter	Description
Source database (on Google Cloud)	Instance Type	Type of the instance in the source database. Select On-premises Databases.
	Instance Region	If you have configured access control for your instance, you must allow the specified Internet IP segment of the region to access the instance before configuring a migration task. Note You can click Get DTS IP to view and copy the IP segment of the region.
	Database Engine	Source database type. Select MySQL .
	Host Name or IP Address	Public IP address of the database
	Port	Default port 3306
	Database account	Default superuser account root
	Database Password	Password of the root account
Target database (on Alibaba Cloud)	Instance Type	Type of the instance in the target database. Select RDS Instance.
	Instance Region	Region of the target instance
	RDS Instance ID	ID of the instance in the selected region. Select the ID of the target instance.
	Database account	An account with read and write permissions under the target instance
	Database Password	Account password
	Connection method	Select Non-encrypted connection or SSL secure connection. The latter greatly increases CPU consumption.

Click Test the Connection and confirm that the test results for both the source and target databases are Test passed.
Click Authorize Whitelist and Enter into Next Step.
Select the migration type. In the Migration objects area, select the target database and click to add the database to the Selected objects area.

Note To maintain data consistency before and after migration, we recommend that you migrate the structure, full data, and incremental data.
Click Pre-check and wait until the pre-check ends.

Note If the check fails, you can rectify faults according to error items and restart the task.
Click Next. In the Confirm Purchase Configuration dialog box, read and select Service Terms of Data Transmission (Pay-As-You-Go), then click Buy and Start Now.

Note Currently, structure migration and full migration are free of charge, while incremental migration is charged by the hour according to link specifications.
Wait until the migration task is completed.