This document describes how to perform data migration in the DTS console. An example of data migration from MySQL to RDS for MySQL is used to explain the procedure. Other storage engines follow a similar procedure.
Create a target RDS database.
During data migration, if the database to be migrated is not defined in the target RDS instance, DTS automatically creates it. In some cases where the database name does not comply with the RDS Definition Standard, you must create the target RDS database in the RDS console before configuring the migration task.
The RDS Definition Standard states the RDS database name can be up to 64 characters in length and consist of lowercase letters, numbers, underscore (_), or hyphen (-). It must start with a letter and end with a letter or number.
Create migration accounts.
To create a migration task, you must provide the migration accounts of the source instance and the target RDS instance. For different storage engines, specific database access privileges are also required. For more information, see the corresponding documents in the DTS User Guide. For example,
Follow these steps to configure a migration task.
Log on to the Alibaba Cloud DTS console.
Click Data migration in the left-side navigation pane.
Click Create migration task.
Configure the Source endpoint and target endpoint.
Task Name: DTS automatically generates a name for the migration task. You can edit the name according to your business requirements.
Select the Connection method (Non-encrypted connection or SSL secure connection) , and then click Test the connection to verify the input contents.
Parameter Description Instance type Select On-premises databases. Instance region Select the region in closest geographic proximity to the source instance. Database engine Select MySQL. Host name or IP address Enter the MySQL database connection string. Port Select the MySQL database listener port. Database account Enter the MySQL database account name. Database password Enter the MySQL database account password.
Click Test the connection to verify the input contents.
Parameter Description Instance type Select RDS Instance. Instance region Select the region of the RDS instance. RDS instance ID Select the target RDS instance ID. Database account Enter the access account name of the RDS instance database. Database password Enter the access account password of the RDS instance database.
Configure Migration type and migration objects.
Migration type: includes Schema migration, Existing data migration, and Incremental replication.
- For existing data migration, select schema migration and existing data migration.
- For zero downtime data migration, select schema migration, existing data migration, and incremental replication.
Migration objects: include database, table, and column.
Note: By default, the object names are the same as in the source and target database. To use the object name mapping function, see Object name mapping.
Perform Pre-check before the migration task is started. If the pre-check fails,
- Click Failed to check the details of the failed items.
- Click View to view the reason and solution.
Troubleshoot the issues and perform pre-check again until the pre-check is successful.
After the pre-check passes, start the migration task.
When the task is started, you can view the migration status and progress in the task list.