Create Sharding Tables #

Scenarios

When users’ usage scenarios require database sharding, they can create sharding rules in data sharding to enable the sharding of the real data source.

Notes

• Chinese names of sharding tables are not supported.
• Creating more than one sharding table at a time is not supported.

Requirements

• Require existing clusters.
• Require existing schema.

Procedure

1. Login to SphereEx-Console.

2. In the upper-left corner of the console, select Plugin > Data Sharding.

3. Click on the Create Sharding Tables on the top right corner.

4. Fill in the sharding information, see the table below for specific parameters.

   Parameters	Description
   Cluster	Filling by the filter
   Schema	Filling by the filter
   Table Type	Required field, select one from the table types: Sharding Table, Broadcast Table, Single Table.
   Table Statements	Required field, fill in the table statements
   Example	Examples of sharding table statements

5. Click OK to complete the creation of sharding tables.