Help Center/ Data Replication Service/ Best Practices/ Real-Time Migration/ From MySQL Schema and Logic Table to DDM/ Procedure/ Preparing for the Destination DDM Instance/ Creating a Schema and Associating It with the RDS for MySQL Instance
Updated on 2024-07-15 GMT+08:00
View PDF
Share

Creating a Schema and Associating It with the RDS for MySQL Instance

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List on the left and choose Databases > Distributed Database Middleware.
  4. On the Instances page, locate the required DDM instance and click Create Schema in the Operation column.
  5. On the displayed page, specify a sharding method, enter a schema name, set the number of shards, select the required DDM accounts, and click Next.

    In this example, the schema is unsharded, and the schema name is db_test_info.

    Currently, only data can be migrated from the RDS for MySQL to DDM. To migrate table structures and other objects, you need to create schemas in the destination DDM instance based on table structures of the source RDS for MySQL instance.