ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database that implements JDBC specifications 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 to support heterogeneous languages. Currently, MySQL and PostgreSQL pro‐ tocols are provided. It can use any kind of terminal that is compatible with MySQL or PostgreSQL pro‐ tocol to operate data, which

ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database that implements JDBC specifications 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 to support heterogeneous languages. Currently, MySQL and PostgreSQL pro‐ tocols are provided. It can use any kind of terminal that is compatible with MySQL or PostgreSQL pro‐ tocol to operate data, which

. . . 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 . . . . . . . . . . . . . . . . . ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database that implements JDBC specifications standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections

. . . 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 . . . . . . . . . . . . . . . . . ultimate performance. • Ecosystem Compatibility The proxy can be accessed by any application using MySQL/PostgreSQL protocol, and the driver can connect to any database that implements JDBC specifications standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 7 Apache ShardingSphere document ShardingSphere-JDBC ShardingSphere-Proxy Database Any MySQL/PostgreSQL Connections

根据配置的影子数据源映射对执行的数 据源进行改写。执行 SQL 会路由到配 置的影子数据源中执行。 影子表判定 影子算法判定 数据源路由 Shadow Algorithm Shadow Data Source Router CyborgFlow 中的 Shadow DB cyborg-database-shadow 演示 gateway c y b o r g - a g e n t & cyborg-dashboard： 真实流量的调用链路 压测流量的调用链路 CyborgFlow POC3 文字 真实流量的调用 SQL 详情 压测流量的调用 SQL 详情 CyborgFlow POC4 文字 连接 MySQL 生产库 ds 查询 连接 MySQL 影子库 ds_shadow 查询 2022 年 1 月 15 日 加入交流群 技术干货

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 PostgreSQL connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy

4.1.4 SQL Parser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 openGauss . 4.1.6 Feature Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 PostgreSQL connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer and any JDBC adapted databases. 1.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy

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

Apache ShardingSphere 5.x 版本开始致力于可插拔架构，项目的功能组件能够灵活的以可插拔的方式 进行扩展。目前，数据分片、读写分离、数据加密、影子库压测等功能，以及对 MySQL、PostgreSQL、 SQLServer、Oracle 等 SQL 与协议的支持，均通过插件的方式织入项目。开发者能够像使用积木一样定 制属于自己的独特系统。Apache ShardingSphere 规范的数据库，目前支持 MySQL，Oracle，SQLServer，PostgreSQL 以及任何 遵循 SQL92 标准的数据库。 1.1.2 ShardingSphere-Proxy 定位为透明化的数据库代理端，提供封装了数据库二进制协议的服务端版本，用于完成对异构语言的支 持。目前提供 MySQL 和 PostgreSQL 版本，它可以使用任何兼容 MySQL/PostgreSQL 协议的访问客户端 协议的访问客户端 (如：MySQL Command Client, MySQL Workbench, Navicat 等) 操作数据，对 DBA 更加友好。 • 向应用程序完全透明，可直接当做 MySQL/PostgreSQL 使用。 • 适用于任何兼容 MySQL/PostgreSQL 协议的的客户端。 1.1.3 ShardingSphere-Sidecar（TODO） 定位为 Kubernetes

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 Currently, MySQL and PostgreSQL (compatible with PostgreSQL‐based databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench,