Step 4: Create a Schema

You can create a schema in two ways: on the Instances page or on the Schemas page. This section uses the DDM instance page as an example to describe how to create a schema.

Figure 1 Instances page
Figure 2 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 3 Creating a schema
    Sharding mode:
    • Sharded: One schema corresponds to multiple DB instances.
    • Unsharded: One schema corresponds only to one 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 Finish.