lightweight Java framework that provides additional services at Java’s JDBC layer. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates SQLServer and any JDBC adapted databases. 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Performance Low loss Relatively High loss Decentralization Yes No Static entry No Yes 3.2 Using ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates

lightweight Java framework that provides additional services at Java’s JDBC layer. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates SQLServer and any JDBC adapted databases. 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Performance Low loss Relatively High loss Decentralization Yes No Static entry No Yes 3.2 Using ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates

1.1 ShardingSphere-JDBC ShardingSphere‐JDBC 定位为轻量级 Java 框架，在 Java 的 JDBC 层提供的额外服务。 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy 定位为透明化的数据库代理端，通过实现数据库二进制协议，对异构语言提供支 持。 1.2 产品功能 1.3 产品优势 • 极致性能 ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意 性能 损耗低 损耗略高 无中心化 是 否 静态入口 无 有 3.2 ShardingSphere-Proxy 独立部署 ShardingSphere‐Proxy 定位为透明化的 Command Client, MySQL Work‐ bench, Navicat 等。 3.2. ShardingSphere-Proxy 独立部署 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意

1.1 ShardingSphere-JDBC ShardingSphere‐JDBC 定位为轻量级 Java 框架，在 Java 的 JDBC 层提供的额外服务。 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy 定位为透明化的数据库代理端，通过实现数据库二进制协议，对异构语言提供支 持。 1.2 产品功能 1.3 产品优势 • 极致性能 ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意 性能 损耗低 损耗略高 无中心化 是 否 静态入口 无 有 3.2 ShardingSphere-Proxy 独立部署 ShardingSphere‐Proxy 定位为透明化的 Command Client, MySQL Work‐ bench, Navicat 等。 3.2. ShardingSphere-Proxy 独立部署 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意

1.1 ShardingSphere-JDBC ShardingSphere‐JDBC 定位为轻量级 Java 框架，在 Java 的 JDBC 层提供的额外服务。 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy 定位为透明化的数据库代理端，通过实现数据库二进制协议，对异构语言提供支 持。 1.2 产品功能 1.3 产品优势 • 极致性能 ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意 性能 损耗低 损耗略高 无中心化 是 否 静态入口 无 有 3.2 ShardingSphere-Proxy 独立部署 ShardingSphere‐Proxy 定位为透明化的 Command Client, MySQL Work‐ bench, Navicat 等。 3.2. ShardingSphere-Proxy 独立部署 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意

is a lightweight Java framework that provides additional services at Java’s JDBC layer. ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates databases. 1.3. Deployment 5 Apache ShardingSphere document, v5.2.1 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Performance Low loss Relatively High loss Decentralization Yes No Static entry No Yes 1.3.2 Using ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates

provides additional services at Java’s JDBC layer. 1 Apache ShardingSphere document, v5.2.0 ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates databases. 1.3. Deployment 7 Apache ShardingSphere document, v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections Count Cost More Less Heterogeneous language Java Performance Low loss Relatively High loss Decentralization Yes No Static entry No Yes Independent ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates

关注它们之间的协作多于数据库自身。 ShardingSphere-JDBC ShardingSphere‐JDBC 定位为轻量级 Java 框架，在 Java 的 JDBC 层提供的额外服务。 ShardingSphere-Proxy ShardingSphere‐Proxy 定位为透明化的数据库代理端，通过实现数据库二进制协议，对异构语言提供支 持。 1 Apache ShardingSphere document document, v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意 性能 损耗低 损耗略高 无中心化 是 否 静态入口 无 有 ShardingSphere-Proxy 独立部署 ShardingSphere‐Proxy 定位为透明化的数据 bench, Navicat 等。 1.3. 部署形态 7 Apache ShardingSphere document, v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy 数据库 任意 MySQL/PostgreSQL 连接消耗数 高 低 异构语言 仅 Java 任意 性能 损耗低 损耗略高 无中心化 是 否 静态入口 无 有 混合部署架构

standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database ng=UTF-8 username: root password: rules: sharding: tables: ... 2.2 ShardingSphere-Proxy 2.2.1 Get ShardingSphere-Proxy ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm /opt/shardingsphere‐proxy‐bin/ Please refer to Configuration Manual for more details. 2.2. ShardingSphere-Proxy 8 Apache ShardingSphere document, v5.1.2 2.2.3 Import Dependencies If the backend database

standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database modeConfig, dataSourceMap, ruleConfigs, props); 7 Apache ShardingSphere document, v5.1.1 2.2 ShardingSphere-Proxy 2.2.1 Rule Configuration Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. Edit % directory sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.4 Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: