Updated on 2022-12-08 GMT+08:00

Step 4: Create a Schema

You can create a schema on the Instances or Schemas page. This section uses the Instances page as an example to describe how to create a schema.

Figure 1 Schemas page

Procedure

  1. Log in to the DDM console, and in the navigation pane, choose Instances. In the instance list, locate the required DDM instance and click Create Schema in the Operation column.
  2. On the displayed page, specify a sharding mode, enter a schema name, select the number of shards per DB instance, and click Next: Select DB Instance.

    Figure 2 Creating a schema
    Sharding mode:
    • Sharded: One schema corresponds to multiple MySQL DB instances.
    • Unsharded: One schema corresponds only to one MySQL DB instance, and only one database shard is created for that instance.

    The schema name contains 2 to 24 characters and must start with a letter. Only letters, digits, and underscores (_) are allowed.

    The shards per DB instance ranges from 1 to 64.

  3. On the RDS DB Instances tab page, select the required RDS DB instances. You can choose to configure the instances as the unsharded table storage nodes. Click Preview.
  4. On the displayed page, enter the administrator password and click Test Connection. After all the test is successful, click Finish.

    Figure 3 Test Connection