Migrate user-created databases to RDS instances

You can migrate databases from ECS to ApsaraDB for RDS High-availability Edition to ensure high availability, reliability, security, and convenience of database services. This topic uses a MySQL database as an example to describe how to use DTS to migrate a user-created database from an ECS instance to an RDS instance.

1. Log on to the DTS console.
2. In the left-side navigation pane, select Data Migration.
3. Select the region where the RDS instance is located, and click Create Migration Task.
4. Configure the migration task.
   1. Specify a task name.

      You can use the default name or specify one.

   2. Configure the source database.
      DTS supports user-created databases that are accessible through the Internet, VPN Gateway, an Express Connect circuit, or Smart Access Gateway. The source database used in this topic is a user-created database in an ECS instance. For migration solutions for other types of databases, see DTS documentation.

      Parameter	Description
      Instance Type	The user-created database in an ECS instance.
      Instance Region	The region where the source ECS instance is located.
      ECS Instance ID	The ID of the ECS instance. DTS supports ECS instances of the classic network and VPC types.
      Database Type	The type of the user-created database in the source ECS instance. The database type is MySQL in this example.
      Port Number	The listening port number for the MySQL database.
      Database Account	The account other than root to access the MySQL database in the source ECS instance. Note The account here must be an account other than root. Otherwise, an error occurs when you test connectivity.
      Database Password	The password for the account other than root.

   3. Click Test Connectivity in the lower-right corner of the Source Database section.

      If Test Passed is returned, it indicates that the connection to the source database is normal.

   4. Configure information of the destination database.

      Parameter	Description
      Instance Type	The type of the RDS instance.
      Instance Region	The region where the RDS instance is located.
      RDS Instance ID	The ID of the RDS instance.
      Database Account	The account of the RDS instance. For more information about how to create an account for an RDS instance, see Create databases and accounts for an ApsaraDB RDS MySQL instance. Note The account here must be an account other than root. Otherwise, an error occurs when you test connectivity.
      Database Password	The password of the account to access the database.

   5. Click Test Connectivity in the lower-right corner of the Destination Database section.

      If Test Passed is returned, it indicates that the connection to the source database is normal.

   6. Click Set Whitelist and Next.
5. Configure migration types and objects.
   1. Configure migration types.
      • To perform zero-downtime data migration, select Schema Migration, Full Data Migration, and Incremental Data Migration.
      • To perform full data migration, select both Schema Migration and Full Data Migration.
   2. Configure migration objects.

      In the Available list, select the database objects to be migrated, such as databases, tables, or columns. Then click > to add them to the Selected list.

      Note

      By default, the object names remain the same as those in the local MySQL database after objects are migrated to a user-created MySQL database in an ECS instance. If an object that you migrate has different names in the source and destination instances, you need to use the object name mapping feature provided by DTS. For more information, see Mappings of database, table, and column names.

6. Click Precheck.

   Before the migration task starts, DTS checks items such as connectivity, permissions, and log formats.

   If the precheck is successful, you can see the status and progress of the migration task in the Migration Tasks section.