. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4 Features 18 4.1 DB Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.1.1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . 444 xi 8.1.1 Apache ShardingSphere ‐ Version: 5.1.0 ( Release Date: Feb 16th, 2022 ) . . . . . 444 8.2 All Releases . . . . . . . . . . . . shardingsphere-jdbc-core <version>${latest.release.version}version> Notice: Please change ${latest.release.version} to the actual version. 2.1.2 Rules Configuration ShardingSphere‐JDBC

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4 Features 18 4.1 DB Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.1.1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 <version>${latest.release.version}version> Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4 Features 18 4.1 DB Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.1.1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391 8.1.1 Apache ShardingSphere ‐ Version: 5.0.0‐beta ( Release Date: Jun 19th, 2021 ) . . 391 8.2 All Releases . . . . . . . . . . . . . shardingsphere-jdbc-core <version>${latest.release.version}version> Notice: Please change ${latest.release.version} to the actual version. 2.1.2 2. Rules Configuration ShardingSphere‐JDBC

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 518 12 Reference 520 12.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 520 12.2 Database Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 587 14.1.1 Apache ShardingSphere ‐ Version: 5.5.0 ( Release Date: April 23rd, 2024 ) . . . . 587 14.2 All Releases . . . . . . . . . . . . driver is close to a native JDBC in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver

. . . . . . . . . . . . . . . . . . . . . . . . . . 489 12 Reference 491 ix 12.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 12.2 Database Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 557 14.1.1 Apache ShardingSphere ‐ Version: 5.4.1 ( Release Date: October 18th, 2023 ) . . 557 14.2 All Releases . . . . . . . . . . . . . driver is close to a native JDBC in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 7 Reference 354 7.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354 7.2 Database Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 467 9.1.1 Apache ShardingSphere ‐ Version: 5.2.0 ( Release Date: Sept 5th, 2022 ) . . . . . 467 9.2 All Releases . . . . . . . . . . . . driver is close to a native JDBC in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380 7 Reference 381 7.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 381 7.2 Database Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 506 9.1.1 Apache ShardingSphere ‐ Version: 5.2.1 ( Release Date: Oct 18th, 2022 ) . . . . . 506 9.2 All Releases . . . . . . . . . . . . driver is close to a native JDBC in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver

. . . . . . . . . 291 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 ) . . . . instead of a total overturn. Apache ShardingSphere begin to focus on pluggable architecture from version 5.x, features can be em‐ bedded into project flexibility. Currently, the features such as data sharding encapsulates database binary protocol to support heterogeneous languages. Friendlier to DBA, the MySQL version provided now can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.)

> shardingsphere-jdbc-core <version>${latest.release.version}version> 注意：请将 ${latest.release.version} 更改为实际的版本号。 2.1.2 规则配置 ShardingSphere‐JDBC 可以通过 Java，YAML，Spring shardingsphere‐agent/shardingsphere‐agent‐distribution/target/apache‐ shardingsphere‐${latest.release.version}‐shardingsphere‐agent‐bin.tar.gz 4.10. 可观察性 61 Apache ShardingSphere document, v5.1.1 agent 配置 agent 目录，解压 agent 二进制包到 agent 目录。 mkdir agent tar -zxvf apache-shardingsphere-${latest.release.version}-shardingsphere-agent-bin. tar.gz -C agent cd agent tree . ├── conf │ ├── agent.yaml │ └──

> shardingsphere-jdbc-core <version>${latest.release.version}version> 注意：请将 ${latest.release.version} 更改为实际的版本号。 2.1.2 规则配置 ShardingSphere‐JDBC 可以通过 Java，YAML，Spring shardingsphere‐${latest.release.version}‐shardingsphere‐agent‐bin.tar.gz agent 配置 • 目录说明 创建 agent 目录，解压 agent 二进制包到 agent 目录。 mkdir agent tar -zxvf apache-shardingsphere-${latest.release.version}-shardingsphere-agent-bin ase-${latest.release.version}.jar │ ├── shardingsphere-agent-metrics-prometheus-${latest.release.version}.jar │ ├── shardingsphere-agent-tracing-jaeger-${latest.release.version}.jar │ ├── shardings