. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4 Features 18 4.1 DB Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.1.1 Background 4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 PostgreSQL

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4 Features 18 4.1 DB Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.1.1 Background 4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 PostgreSQL

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4 Features 18 4.1 DB Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.1.1 Background 4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 PostgreSQL pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Supports any kind of JDBC standard database: MySQL, Oracle, SQLServer, PostgreSQL and any SQL92 followed databases. 1.1. Introduction 2 Apache ShardingSphere

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 518 12 Reference 520 12.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 520 12.2 Database Gateway . . . 575 13.1.3 JDBC SQLException: Unable to unwrap to interface com.mysql. jdbc.Connection exception thrown when using MySQL XA transaction . . . 576 13.2 Proxy . . . . . . . . . . . . . . . . . in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database

. . . . . . . . . . . . . . . . . . . . . . . . . . 489 12 Reference 491 ix 12.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 12.2 Database Gateway . . . 547 13.2.3 JDBC SQLException: Unable to unwrap to interface com.mysql. jdbc.Connection exception thrown when using MySQL XA transaction . . . 547 13.3 Proxy . . . . . . . . . . . . . . . . . in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 7 Reference 354 7.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354 7.2 Database Gateway in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.3. Deployment 7 Apache ShardingSphere document, v5.2.0 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380 7 Reference 381 7.1 Database Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 381 7.2 Database Gateway in terms of efficiency, with ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.3. Deployment 5 Apache ShardingSphere document, v5.2.1 ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL

sharding, replica query, data en‐ crypt, shadow database, and SQL dialects / database protocols such as MySQL, PostgreSQL, SQLServer, Oracle supported are all weaved by plugins. Developers can customize their pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Support any kind of JDBC standard database: MySQL, Oracle, SQLServer, PostgreSQL and any SQL92 followed databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy languages. Friendlier to DBA, the MySQL version provided now can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is compatible of MySQL protocol to operate data. • Totally

19 4.1.4 SQL 解析 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 21 4.1.6 特性支持 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 PostgreSQL • 支持任意实现 JDBC 规范的数据库，目前支持 MySQL，PostgreSQL，Oracle，SQLServer 以及任何 可使用 JDBC 访问的数据库。 1.1.2 ShardingSphere-Proxy 定位为透明化的数据库代理端，提供封装了数据库二进制协议的服务端版本，用于完成对异构语言的支 持。目前提供 MySQL 和 PostgreSQL（兼容 openGauss 等基于

19 4.1.4 SQL 解析 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 21 4.1.6 特性支持 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 PostgreSQL • 支持任意实现 JDBC 规范的数据库，目前支持 MySQL，PostgreSQL，Oracle，SQLServer 以及任何 可使用 JDBC 访问的数据库。 1.1.2 ShardingSphere-Proxy 定位为透明化的数据库代理端，提供封装了数据库二进制协议的服务端版本，用于完成对异构语言的支 持。目前提供 MySQL 和 PostgreSQL（兼容 openGauss 等基于