Configuration – multiple features, server properties

In this section, we will discuss how to realize the rule configuration of data sharding based on read/write splitting. Please note that the data source used in this process should be the one after aggregating read/write splitting.

DistSQL

The SQL syntax is consistent with each feature when used singularly. For more detailed syntax, please refer to the following sections:

• Configuration – sharding
• Configuration – read/write splitting
• Configuration – mode

Now for the example! Perform the following steps:

1. First, create the read/write splitting rules:

   CREATE READWRITE_SPLITTING RULE ds_0 (
      WRITE_RESOURCE=write_ds_0,
      READ_RESOURCES(write_ds_0_read_ds_0, write_ds_0_read_ds_1),TYPE(NAME=ROUND_ROBIN)
   ), ds_1 (
      WRITE_RESOURCE=write_ds_1,
      READ_RESOURCES(write_ds_1_read_ds_0, write_ds_1_read_ds_1),TYPE(NAME...