Help Center/ Data Replication Service/ Best Practices/ Real-Time Migration/ From RDS for MySQL to DDM/ 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 of the management console and select CN-Hong Kong.
  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 mode, 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.

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