migrate the data from other data sources, while simul‐ taneously performing data sharding. Q ue ry Fe de ra ti on Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer document mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username}

Template or direct use of JDBC. • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Supports any kind of JDBC standard database: MySQL, Oracle, SQLServer Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2. ShardingSphere-Proxy 8 Apache ShardingSphere document, v5.0.0

Template or direct use of JDBC. • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP. • Support any kind of JDBC standard database: MySQL, Oracle, SQLServer, Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2. ShardingSphere-Proxy 6 Apache ShardingSphere document, v5.0.0-beta

Template or direct use of JDBC; • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.3 ShardingSphere-Scaling (Experimental) 2.3.1 Rule Configuration

Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer : mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} : 2.2. ShardingSphere-Proxy 14 Apache ShardingSphere document, v5.2.0 gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 2.2. ShardingSphere-Proxy 15 3 Features

Template or direct use of JDBC; • Supports any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2. ShardingSphere-Proxy 9 3 Concepts The functions of Apache ShardingSphere

migrate the data from other data sources, while simul‐ taneously performing data sharding. Q ue ry Fe de ra ti on Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer document mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username}

Template, or direct use of JDBC; • Support any third‐party database connection pool, such as DBCP, C3P0, BoneCP, HikariCP; • Support any kind of JDBC standard database: MySQL, PostgreSQL, Oracle, SQLServer 1 mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} ${proxy_username} Use the openGauss client to connect to the ShardingSphere‐Proxy: gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 2.2. ShardingSphere-Proxy 14 3 Features

node. 5.2. Elastic Schedule 12 Apache ShardingSphere ElasticJob document C hi ld no de na me E p h e m e r a l n o d e Description el ec ti on :r aw ‐l at ex :ˋ i ns ta nc eˋ Y E S The IP address of io n: ra w‐ la te x: la tc h N O Distributed locks elected by the master nodeUsed for dis‐ tributed locks of curator s ha rd in g: ra w‐ la te x: ne ce ss ar y N O The flag for re‐sharding. If the middleThe sharding will not be triggered when the job is executed sh ar di ng :r aw ‐l at ex :ˋ p ro ce ss in gˋ Y E S The node held by the master node during sharding.If there is this node, all

的 ORM 框架，如：JPA, Hibernate, Mybatis, Spring JDBC Template 或直接 使用 JDBC； • 支持任何第三方的数据库连接池，如：DBCP, C3P0, BoneCP, HikariCP 等； • 支持任意实现 JDBC 规范的数据库，目前支持 MySQL，PostgreSQL，Oracle，SQLServer 以及任何 可使用 JDBC 访问的数据库。 ShardingSphere‐Proxy： mysql -h${proxy_host} -P${proxy_port} -u${proxy_username} -p${proxy_password} 使用 PostgreSQL 客户端连接 ShardingSphere‐Proxy： psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 ShardingSphere‐Proxy： 7.2. ShardingSphere-Proxy 16 Apache ShardingSphere document gsql -r -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} -W ${proxy_password} 7.2. ShardingSphere-Proxy 17 8 功能 Apache