. . . . . . . . . . . . . . . . . . . . . . . . . . . 337 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 340 6.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.2 Design Philosophy ShardingSphere adopts the database plus design philosophy ShardingSphere document, v5.2.0 ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: shardingsphere:

. . . . . . . . . . . . . . . . . . . . . . . . . . . 364 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 367 6.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.5. Roadmap 9 2 Quick Start In shortest time, this chapter provides users ShardingSphere document, v5.2.1 ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: shardingsphere:

table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING (column_list)] 子查询 子查询和外层查询同时指定分片键，且分片键的值保持一致时，由内核提供稳定支持。 apache.shardingsphere.sharding.api.config.ShardingTableRuleConfiguration 可配置属性： 名称 数据类型 说明 默认值 log icTable String 分片逻辑表名称 • a ctualDa taNodes (?) String 由数据源名 + 表名组成， 以小数点分隔。多个表 以逗号分隔，支持行表 达式 使用已知数据源与逻辑 trategyConfiguration 可配置属性： 名称 数据类型 说明 writeDataSourceName String 写库数据源名称 readDataSourceNames List 读库数据源列表 类名称：org.apache.shardingsphere.readwritesplitting.api.strategy.DynamicReadwriteSp

驱动包、log4j 的 jar 包 myBatis-3.4.1.jar mysql-connector-java-5.1.37-bin.jar log4j.jar 2) 导入 log4j 的配置文件 log4j:configuration SYSTEM "log4j.dtd"> <log4j:configuration log4j="http://jakarta.apache.org/log4j/"> value="info" /> log4j:configuration> 2.2 创建测试表 -- 创建库 CREATE DATABASE test_mybatis; -- 使用库 USE test_mybatis; -- 创建表

databases in the same log . . . . . . . . . . . . . . . . . . . . . . 215 To distinguish databases and users in the same log . . . . . . . . . . . . . . . . . 216 To split into different log files . . . . yaml or properties leading incorrect result when loading Oracle metadata？ . . . . . . 369 7.9 API Change Histories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 370 7.9.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 385 Spring namespace configuration change history . . . . . . . . . . . . . . . . . . 412 Spring Boot Starter Configuration . . . . . . .

when integrating ShardingSphere with Spring Boot 2.x ? . . . . . . . . . . . . . . . . 356 7.9 API Change Histories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 357 7.9.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 372 Spring namespace configuration change history . . . . . . . . . . . . . . . . . . 399 Spring Boot Starter Configuration . . . . . . . Apache Top‐Level Project on April 16, 2020. Welcome to interact with community via the official mail list and the ShardingSphere Slack. 1.1 Introduction Apache ShardingSphere including 3 independent products:

. . 50 Third‐party Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Change History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 4.5.5 Observability . . . . . . . . . . . . . . . . . . . . . . . . 65 Column shadow algorithm DML statement support list . . . . . . . . . . . . . . 65 5 User Manual 67 5.1 ShardingSphere‐JDBC . . . . . . . . . . . . 7.26 26. [Other] Why is the database sharding result not correct when using Proxool?312 7.8 API Change Histories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313 7.8.1 ShardingSphere‐JDBC

. . 70 Third‐party Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Change History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 3.4.5 Observability became an Apache Top Level Project on April 16, 2020. Welcome communicate with community via mail list. 1.1 Introduction 1.1.1 ShardingSphere-JDBC ShardingSphere‐JDBC defines itself as a lightweight c-core ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 2.1.2 2. Rules Configuration ShardingSphere‐JDBC

. . . . . . . . . . . . . . . . . . . . . . . . . 503 ix BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 506 11.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides users with a simplest ${latest.release.version} 14 Apache ShardingSphere document Notice: Please change ${latest.release.version} to the actual version. 3. Create YAML configuration file # JDBC database

. . . . . . . . . . . . . . . . . . . . . . . . . . . 474 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 477 11.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides users with a simplest ${latest.release.version} 14 Apache ShardingSphere document Notice: Please change ${latest.release.version} to the actual version. 3. Create YAML configuration file # JDBC database