Retro Eye care Haitian Deep Dark Default
Logo
Table Group Management

Table Group Management #

Create Table Group #

Scenarios

When the user’s scenario needs require binding the sharding table.

Notes

  • The sharding table has been created.
  • The table that needs to be bound cannot join any of the current table groups.

Prerequisites

  • The cluster has been created.
  • The schema has been created.

Procedure

  1. Login to SphereEx-Console.
  2. In the upper-left corner of the console, select Plugin > Data Sharding.
  3. Click on the Table Groups on the top right corner.
  4. Click the Create Table Group button in the upper right corner of the new page.
  5. Fill in the table group information. See the following table for specific parameters.
ParametersDescription
First MemberRequired field. Select the sharding table in the current schema from the drop-down list, and select any one of the tables of expected binding rules. There is no primary or secondary distinction.
Other MembersRequired field, select from the drop-down list. The sharding table in the current schema and other tables that comply with the table binding rules with the first member can be selected.
  1. Click OK to complete the creation of the table group.

Member Management #

Scenarios

When the user’s scenario needs to manage the existing table group.

Notes

  • Table groups have been created.
  • When the table group member is 1, the table group will be deleted.

Procedure

  1. Login to SphereEx-Console.
  2. In the upper-left corner of the console, select Plugin > Data Sharding.
  3. Click on the Table Group on the top right corner.
  4. Select a table group and click Member Management on the right.
  5. Select group members in the pop-up dialog box.
ParametersDescription
Optional MemberDrop down the text box, the existing table in the table group. Select and click to remove out of the table group.
Group MemberDrop down the text box, The sharding table in the current schema and the table that meets the binding table rules with the members of the current table group. Select Add to join the table group.
  1. Click OK to complete the selection of members.