Sample Scenario #
Add host.
a. Choose Resource > Host and click Add Host.
b. Enter host data in the pop-up interface.
c. Click OK to add new host information.
Add database instances.
a. Choose Resource > Database Instance and click Add Instances.
b. Enter the corresponding data in the pop-up interface, such as IP: 127.0.0.1, port: 3306, type: MySQL, connected user: root, password: 123456.
c. After clicking OK, the corresponding registration data will be added to the database instance list.
d. Click Test Connection to test whether the database instance can be successfully connected.
Add compute node.
a. Choose Cluster > Compute Node, and click Add Compute Node.
b. In the pop-up interface, enter the relevant information of the corresponding compute node.
c. Click OK to add compute node data.
d. Click Test Connection to test whether the compute node can be successfully connected.
Add storage node.
a. Choose Cluster > Storage Node, and click Add Storage Node.
b. In the pop-up interface, enter the relevant information of the corresponding storage node.
c. Click OK to add storage node data.
d. Click Test Connection to test whether the storage node can be successfully connected.
Create cluster.
a. Choose Cluster > Cluster, and click Create Cluster.
b. In the pop-up interface, enter the relevant information of the corresponding cluster.
c. Click OK to add a cluster.
d. Click Config to configure the compute nodes and storage nodes of the cluster.
e. Click the Detail button to view the relevant information of compute nodes, storage nodes and logical databases in the cluster.
Create a logical database.
a. Choose Cluster > Schema, and click Create Schema.
b. In the pop-up interface, enter the name of the logical database and select the storage node required by the logical database. Note: All compute nodes are selected and cannot be modified.
c. Click storage node and compute node to view the storage node and compute node information applied to the logical database respectively.
Plugin - Data Sharding
a. In the Plugin > Data Sharding menu, data sharding is currently available, and more plugin features will be added and supported in the future.
b. After selecting the corresponding cluster and the corresponding logical database under the cluster, click Create Sharding Tables to create sharding table and broadcast table using DistSQL under the corresponding logical database.
c. After creation, you can also use DistSQL to modify table rules.
d. After creating the sharding rule, you can click Add table structure to create the actual database table using the normal table creation statement.
