Application Scenario

This document is applicable to the use of Baidu AI Cloud data transmission service DTS to transfer Tencent Cloud Database MySQL data online to Baidu AI Cloud RDS without stopping service.

Environmental Preparation

• Tencent Cloud Database MySQL 5.6 instance
• Baidu AI Cloud RDS MySQL 5.6 instance

Operation Steps

Check the public access of Tencent Cloud Database.

1. Log in to Tencent Cloud access console and enter the details page of the instance to be migrated;
2. In the instance Tab "Instance Details", check whether the "External Network Address" of the instance is enabled. If not, click the "Start" button and follow the prompts.

3. For the enabled instance, record the [External Network Address] and the port for the following steps.

4. In Tab "Security Group", edit the security group group bound to the instance to allow DTS server access. For detailed DTS public network IP address range, please see: DTS Public Network IP Address Range.

Check the parameter setting of Tencent Cloud Database.

1. On the instance details page, enter the instance Tab "Database Management" -> Secondary Tab "Parameter Setting";
2. In the parameter list, check whether the parameter meets the requirements: Whether the value of "binlog_format" is "ROW", and whether the value of "binlog_row_format" is "FULL".

3. By default, the "binlog_row_image" value of Tencent Cloud Database MySQL instance is "MINIMAL", not meeting the migration requirements. If the parameter value does not meet the requirements, click the Edit button next to the parameter value to modify.

Authorize the migration account

1. Connect Tencent Cloud Database instance with MySQL admin account. You can execute "mysql -h external network address -u high privilege account -p -P external network port" in the command line. The Chinese part is replaced according to the actual external network address/port and account of the instance;
2. After the connection, perform authorization. You can authorize the existing account for migration or create a new account for migration. Please see the following authorization statement: GRANT SELECT, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT, SHOW VIEW ON ?.? TO 'MigratedAccount' @ 'CVM Server' IDENTIFIED BY 'Migration Password'; Please fill in the "Migration Account" and the "Migration Password" as required; fill in the "Hostname" concerning DTS Public Network IP Address Range, to release access restriction only to DTS server IP, or fill in % open access to all IPs.
3. After authorization, continue to refresh the system privilege table to ensure that the account privilege takes effect immediately. Execute "FLUSH PRIVILEGES;".

Create Baidu AI Cloud DTS migration task

Source library and target library configuration

1. Login to Baidu AI Cloud access console, and purchase data migration instance;
2. Click the "Configure Task" button to start the configuration of migration task for the instance;
3. Enter "Task Name" as required; in "Source Library Information", select "Public Network Self-built Database" as the instance type, select "MySQL" as the database engine, and then fill in the external network IP/port of Tencent Cloud Database instance and account information for migration; in "Target Library Information", select the Baidu AI Cloud RDS instance as the migration target.

4. Click the "Authorize Whitelist and Go to Next" button to continue to configure the migration type and library table.

Migration type and library table

1. In migration type, select: Structure, full, and incremental;
2. Select the object to migrate in the "Source Library Objects" box, and then click the "Add Selected" button. The object appears in the "Selected Objects" box.

3. To change the name of the migrated object in the target library, you can click the Edit button on the right of the object to rename.

4. Click "Save and Pre-check" to start the pre-check.

Task verification and startup

1. Wait for a while. Then, the page indicates the task verification is successful.

2. Click the "Start Task Now" button to start the task.