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.
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
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.