to ShardingSphere‐Proxy data source configuration rules) 3. Create a role or user with creation permission for ShardingSphere‐Proxy 4. Start Zookeeper service (for persistent configuration) Start ShardingSphere-Proxy (refer to ShardingProxy data source configuration rules) 3. Create a role or user with creation permission for ShardingProxy 4. Start Zookeeper service (for persistent configuration) Start ShardingProxy (refer to ShardingProxy data source configuration rules) 3. Create a role or user with creation permission for ShardingProxy 4. Start Zookeeper service (for persistent configuration) Start ShardingProxy

It includes a query optimizer, distributed transaction engine, distributed execution engine, permission engine and scheduling engine. 2.3.2 L2 Feature Layer Used to provide enhancement capabilities to mode of configuration. Please refer to the following links for other configuration items: * Permission configuration * Property configuration 9.2. ShardingSphere-Proxy 162 Apache ShardingSphere document service; 2. Create to be registered MySQL databases; 3. Create role and user in MySQL with creation permission for ShardingSphere‐Proxy; 4. Start Zookeeper service; 5. Add mode and authentication configurations

service; 2. Create to be registered MySQL databases; 3. Create role and user in MySQL with creation permission for ShardingSphere‐Proxy; 4. Start Zookeeper service; 5. Add mode and authentication configurations include Replication privileges. Execute the following SQL to confirm whether the user has migration permission or not: SHOW GRANTS 'user'; 5.4. ShardingSphere-Scaling 216 Apache ShardingSphere document, configuration into a single‐table rule objects Aut horityRuleBuilder Used to convert permission user configuration into permission rule objects Sh ardingRuleBuilder Used to convert sharding user configuration

It includes a query optimizer, distributed transaction engine, distributed execution engine, permission engine and scheduling engine. L2 Feature Layer Used to provide enhancement capabilities. All to mode of configuration. Please refer to the following links for other configuration items: * Permission configuration * Property configuration 3. Configure conf/config-*.yaml 4.2. ShardingSphere-Proxy service; 2. Create to be registered MySQL databases; 3. Create role and user in MySQL with creation permission for ShardingSphere‐Proxy; 4. Start Zookeeper service; 5. Add mode and authentication configurations

It includes a query optimizer, distributed transaction engine, distributed execution engine, permission engine and scheduling engine. L2 Feature Layer Used to provide enhancement capabilities. All to mode of configuration. Please refer to the following links for other configuration items: * Permission configuration * Property configuration 3. Configure conf/config-*.yaml Modify files named with service; 2. Create to be registered MySQL databases; 3. Create role and user in MySQL with creation permission for ShardingSphere‐Proxy; 4. Start Zookeeper service; 5. Add mode and authentication configurations

service; 2. Create to be registered MySQL databases; 3. Create role and user in MySQL with creation permission for ShardingSphere‐Proxy; 4. Start Zookeeper service; 5. Add mode and authentication configurations include Replication privileges. Execute the following SQL to confirm whether the user has migration permission or not: SHOW GRANTS FOR 'user'; Result Example: +------------------------------------------ configuration into a single‐table rule objects Aut horityRuleBuilder Used to convert permission user configuration into permission rule objects Sh ardingRuleBuilder Used to convert sharding user configuration

It includes a query optimizer, distributed transaction engine, distributed execution engine, permission engine and scheduling engine. 2.3.2 L2 Feature Layer Used to provide enhancement capabilities to mode of configuration. Please refer to the following links for other configuration items: * Permission configuration * Property configuration 3. Configure conf/config-*.yaml 9.2. ShardingSphere-Proxy service; 2. Create to be registered MySQL databases; 3. Create role and user in MySQL with creation permission for ShardingSphere‐Proxy; 4. Start Zookeeper service; 9.2. ShardingSphere-Proxy 364 Apache ShardingSphere

connectionTim eoutMil‐ liseconds int 15000 Connection timeout in milliseconds digest Str ing no need Permission token to connect to ZooKeeper 6.2. Configuration 54 Apache ShardingSphere ElasticJob document

SQL route result group to be executed by each database case within the maxConnectionSizePerQuery permission range and calculate the most optimized connection mode of this request. 3.1. Sharding 42 Apache