You can use Data Transmission Service (DTS) to migrate existing data or incremental data to HybridDB for MySQL.

Prerequisites

You have created a database and a table that data can be migrated to in HybridDB for MySQL.

Create a task

Go to the Data Transmission Service console.

Go to the Data migration page and click Create migration task.



Source database and target database

You can use an RDS instance or create a MySQL database as the source database. If you select the RDS instance type as the source database, select the RDS instance ID, and enter the database account and password.

Note

DTS supports Existing data migration and Incremental replication migration type to migrate data from an RDS instance or a MySQL database to HybridDB for MySQL.

Select PetaData as the target database, and specify the instance ID, and database account and password.

Click Authorize whitelist and go to the next step for configuring the source database and table.



Configure the source database and table

Next, configure the migration class and list. In the left-side pane, select the source database and table, and then click the rightwards arrow in the middle of the page to add the database and table to the right pane.

In this example, two tables (btest and dmstest3) in the source database test_new are migrated.



Configure the target database and table

Click the Edit next to the source database test_new to edit the database name into the target database name in HybridDB for MySQL.

In this example, data is migrated to the targetdb database in HybridDB for MySQL.



Click OK.

Click Pre-check and start to start the pre-check.

Pre-check

Note You must have created the target database and table before migrating data to HybridDB for MySQL. Otherwise, the following error may occur during the pre-check:


Handle the error according to the prompt, pass the pre-check, and then click Next.

Start migration

Migrate data using DTS.

Check the migration result

If you migrate full data only, the migration task is in Finished status after the migration. If you migrate both full and incremental data, after the full data migration is finished, the incremental data migration task stays in Migrating status until the task is finished.