. . . . . . . . . . . . . . . . . . . . . . 467 9.1.1 Apache ShardingSphere ‐ Version: 5.2.0 ( Release Date: Sept 5th, 2022 ) . . . . . 467 9.2 All Releases . . . . . . . . . . . . . . . . . . . . . Apache ShardingSphere document, v5.2.0 ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: bar_key: bar_value overwrite: # Whether overwrite persistent configuration with local configuration Notes 1. Cluster mode deployment is recommended for production environment. 2. The ‘ZooKeeper’registry

. . . . . . . . . . . . . . . . . . . . . . 506 9.1.1 Apache ShardingSphere ‐ Version: 5.2.1 ( Release Date: Oct 18th, 2022 ) . . . . . 506 9.2 All Releases . . . . . . . . . . . . . . . . . . . . . Apache ShardingSphere document, v5.2.1 ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value Notes 1. Cluster mode deployment is recommended for production environment. 2. The ZooKeeper registry

. . . . . . . . . . . . . . . . . . . 391 8.1.1 Apache ShardingSphere ‐ Version: 5.0.0‐beta ( Release Date: Jun 19th, 2021 ) . . 391 8.2 All Releases . . . . . . . . . . . . . . . . . . . . . . . . shardingsphere-jdbc-core ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 2.1.2 2. Rules Configuration Local build > cd shardingsphere/shardingsphere-agent > mvn clean install Remote download（No release） > weget http://xxxxx/shardingsphere-agent.tar.gz > tar -zxvcf shardingsphere-agent.tar.gz Add

. . . . . . . . . . . . . . . . . . . . 444 xi 8.1.1 Apache ShardingSphere ‐ Version: 5.1.0 ( Release Date: Feb 16th, 2022 ) . . . . . 444 8.2 All Releases . . . . . . . . . . . . . . . . . . . . . shardingsphere-jdbc-core ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 2.1.2 Rules Configuration directory: shardingsphere‐agent/shardingsphere‐agent‐distribution/target/apache‐ shardingsphere‐${latest.release.version}‐shardingsphere‐agent‐bin.tar.gz Agent configuration • Directory structure Create agent

. . . . . . . . . . . . . . . . . . . . . . 489 8.1.1 Apache ShardingSphere ‐ Version: 5.1.2 ( Release Date: June 13th, 2022 ) . . . . 489 8.2 All Releases . . . . . . . . . . . . . . . . . . . . . Apache ShardingSphere document, v5.1.2 ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: directory: shardingsphere‐agent/shardingsphere‐agent‐distribution/target/apache‐ shardingsphere‐${latest.release.version}‐shardingsphere‐agent‐bin.tar.gz Agent configuration • Directory structure Create agent

6.1.1 Apache ShardingSphere ‐ Version: 5.0.0‐alpha ( Release Date: Nov 10, 2020 ) . . 291 6.1.2 ShardingSphere UI ‐ Version: 5.0.0‐alpha ( Release Date: Nov 22, 2020 ) . . . . . 291 6.2 All Releases shardingsphere-jdbc-core ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 2.1.2 2. Rules Configuration if it has not dealt with concurrency properly. As multiple requests waiting for each other to release database connection resources, it will generate hunger wait and cause the crossing deadlock problem

. . . . . . . . . . . . . . . . . . . . . 557 14.1.1 Apache ShardingSphere ‐ Version: 5.4.1 ( Release Date: October 18th, 2023 ) . . 557 14.2 All Releases . . . . . . . . . . . . . . . . . . . . . dbc-core ${latest.release.version} 14 Apache ShardingSphere document Notice: Please change ${latest.release.version} to the actual version. 3. Create center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value Notes 1. Cluster mode deployment is recommended for production environment. 2. The ZooKeeper registry

. . . . . . . . . . . . . . . . . . . . . 587 14.1.1 Apache ShardingSphere ‐ Version: 5.5.0 ( Release Date: April 23rd, 2024 ) . . . . 587 14.2 All Releases . . . . . . . . . . . . . . . . . . . . ere-jdbc ${latest.release.version} 14 Apache ShardingSphere document Notice: Please change ${latest.release.version} to the actual version. 3. Create center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value Notes 1. Cluster mode deployment is recommended for production environment. 2. The ZooKeeper registry

. . . 83 8.1.1 ElasticJob ‐ Version: 3.0.4 ( Release Date: Oct 18, 2023 ) . . . . . . . . . . . . . . 83 8.1.2 ElasticJob‐UI ‐ Version: 3.0.2 ( Release Date: Oct 31, 2022 ) . . . . . . . . . . . . 83 such as jobs scale out, so that they can focus more on business coding; At the same time, it can release operators too, so that they do not have to worry about jobs high availability and management, and shardingsphere.elasticjob elasticjob-bootstrap ${latest.release.version} 4.2 Develop Job public class MyJob implements SimpleJob { @Override

shardingsphere.elasticjob elasticjob-bootstrap ${latest.release.version} 4.2 作业开发 public class MyJob implements SimpleJob { @Override elasticjob elasticjob-error-handler-email ${latest.release.version} public class JobDemo { public static void main(String[] args) elasticjob elasticjob-error-handler-wechat ${latest.release.version} public class JobDemo { public static void main(String[] args)