Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184 Impact on the System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 Limitations . . . . . . . Integration Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 490 11.2 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 490 11 ix BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 506 11.7 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 514 11

Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195 Impact on the System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195 Limitations . . . . . . . Integration Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 326 6.2 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 326 6.3 337 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 340 6.7 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349 6.7

Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201 Impact on the System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201 Limitations . . . . . . . Integration Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 6.2 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 6.3 364 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 367 6.7 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 376 6.7

Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Impact on the System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166 Limitations . . . . . . . Integration Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 461 11.2 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 461 11 474 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 477 11.7 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 485 11

Integration Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 286 7.6.2 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287 7.6.3 Performance Performance Test with Sysbench . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 7.6.6 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 300 SQL Parser Test The applications and databases that use Database Mesh to visit databases will form a large grid system, where they just need to be put into the right positions accordingly. They are all governed by the

reasonably making full use of the computation and storage capacity of existed database in distributed system, rather than a totally new database. As the cornerstone of enterprises, relational database still database. The application and database that use Database Mesh to visit database will form a large grid system, where they just need to be put into the right position accordingly. They are all gov‐ erned by same registry center, ShardingSphere can build an application system applicable to all kinds of scenarios. Architects can adjust the system architecture to the most applicable one to current business more

Integration Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 297 7.7.2 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 297 7.7.3 Performance Sysbench Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311 7.7.7 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 342 SQL Parser Test The applications and databases that use Database Mesh to visit databases will form a large grid system, where they just need to be put into the right positions accordingly. They are all governed by the

Integration Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 7.7.2 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 7.7.3 Performance Sysbench Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 323 7.7.7 Module Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354 SQL Parser Test The applications and databases that use Database Mesh to visit databases will form a large grid system, where they just need to be put into the right positions accordingly. They are all governed by the

2 2 Features • Elastic Schedule – Support job sharding and high availability in distributed system – Scale out for throughput and efficiency improvement – Job processing capacity is flexible and Schedule Elastic schedule is the most important feature in ElasticJob, which acts as a job processing system that enables the horizontal scaling of jobs by sharding, it’s also the origin of the project name“ElasticJob” ability to control whether the server is disabled should be delegated to the automated deployment system. leader node The master node information of the job server is divided into three sub‐nodes: election

ShardingSphereDriver 的驱动类，通过实现 org. apache.shardingsphere.infra.url.ShardingSphereURLLoader 的 SPI，可允许从多种来源 和 File System 获取并解析为 ShardingSphere 的 YAML 配置文件。如无特定声明，以下实现均采 用 YAML 1.1 作为 YAML 的编写规范，这并不阻止 org.apache.shardingsphere .yaml?placeholder-type=environment • jdbc:shardingsphere:classpath:config.yaml?placeholder-type=system_props 从绝对路径中加载配置文件 配置文件为 xxx.yaml，当 placeholder-type 为 none 或不标明时，配置文件格式与 YAML 配置 一致。当 placeholder-type placeholder-type=environment • jdbc:shardingsphere:absolutepath:/path/to/config.yaml? placeholder-type=system_props JDBC URL 参数 对于 org.apache.shardingsphere.infra.url.ShardingSphereURLLoader 的实现，并非所有 的 JDBC