the following diagram. Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard rewrite. Optimization of ShardingSphere ShardingSphere has optimized in two ways. Firstly, it adopts stream process + merger ordering to avoid excessive memory occupation. SQL rewrite unavoidably occupies Transaction The earliest distributed transaction model of XA standard is X/Open Distributed Transaction Processing (DTP) model brought up by X/Open, XA for short. Distributed transaction based on XA standard has

the following diagram. Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard execution result sets to output through unified JDBC interface. Result merger in‐ cludes methods as stream merger, memory merger and addition merger using decorator merger. Parse Engine Compared to other without influencing the correctness of the query. It can be divided into single node optimization and stream merger optimization. Single Node Optimization It refers to the optimization that stops the SQL

the following diagram. Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard Co ncurrent per formance no loss severe loss slight loss Applied s cenar‐ ios Inconsistent processing by the business side short transaction & low‐ level concurrency long transaction & high concurrency effectively avoiding row locks. One primary database with multiple replica databases can further enhance processing capacity by dis‐ tributing queries evenly into multiple data replicas. Multiple primary databases

ShardingSphere document, v5.0.0 Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard rewrite. Optimization of ShardingSphere ShardingSphere has optimized in two ways. Firstly, it adopts stream process + merger ordering to avoid excessive memory occupation. SQL rewrite unavoidably occupies Transaction The earliest distributed transaction model of XA standard is X/Open Distributed Transaction Processing (DTP) model brought up by X/Open, XA for short. Distributed transaction based on XA standard has

the following diagram. Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard rewrite. Optimization of ShardingSphere ShardingSphere has optimized in two ways. Firstly, it adopts stream process + merger ordering to avoid excessive memory occupation. SQL rewrite unavoidably occupies Transaction The earliest distributed transaction model of XA standard is X/Open Distributed Transaction Processing (DTP) model brought up by X/Open, XA for short. Distributed transaction based on XA standard has

the following diagram. Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard Co ncurrent per formance no loss severe loss slight loss Applied s cenar‐ ios Inconsistent processing by the business side short transaction & low‐ level concurrency long transaction & high concurrency effectively avoiding row locks. One primary database with multiple replica databases can further enhance processing capacity by dis‐ tributing queries evenly into multiple data replicas. Multiple primary databases

the following diagram. Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard Co ncurrent per formance no loss severe loss slight loss Applied s cenar‐ ios Inconsistent processing by the business side short transaction & low‐ level concurrency long transaction & high concurrency effectively avoiding row locks. One primary database with multiple replica databases can further enhance processing capacity by dis‐ tributing queries evenly into multiple data replicas. Multiple primary databases

the following diagram. Theoretically, horizontal sharding has overcome the limitation of data processing volume in single ma‐ chine and can be extended relatively freely, so it can be taken as a standard Co ncurrent per formance no loss severe loss slight loss Applied s cenar‐ ios Inconsistent processing by the business side short transaction & low‐ level concurrency long transaction & high concurrency effectively avoiding row locks. One primary database with multiple replica databases can further enhance processing capacity by dis‐ tributing queries evenly into multiple data replicas. Multiple primary databases

ShardingSphere document 8.2.7 核心概念 XA 协议 XA 协议最早的分布式事务模型是由 X/Open 国际联盟提出的 X/Open Distributed Transaction Processing (DTP) 模型，简称 XA 协议。 8.2.8 使用限制 虽然 Apache ShardingSphere 希望能够完全兼容所有的分布式事务场景，并在性能上达到最优，但在 CAP -Prelease,docker 如果遇到以下问题，请确保 Docker daemon 进程已经运行。 I/O exception (java.io.IOException) caught when processing request to {}->unix:// localhost:80: Connection refused？ 2. 配置 conf/server.yaml 和 conf/config-* 语法用于查询数据迁移规则。### 语法 ShowMigrationRule ::= 'SHOW' 'MIGRATION' 'RULE' 返回值说明 列 说明 read 数据读取配置 write 数据写入配置 stream_channel 数据通道 9.2. ShardingSphere-Proxy 292 Apache ShardingSphere document 示例 • 查询数据迁移规则 SHOW

ShardingSphere document 8.2.7 核心概念 XA 协议 XA 协议最早的分布式事务模型是由 X/Open 国际联盟提出的 X/Open Distributed Transaction Processing (DTP) 模型，简称 XA 协议。 8.2.8 使用限制 虽然 Apache ShardingSphere 希望能够完全兼容所有的分布式事务场景，并在性能上达到最优，但在 CAP -Prelease,docker 如果遇到以下问题，请确保 Docker daemon 进程已经运行。 I/O exception (java.io.IOException) caught when processing request to {}->unix:// localhost:80: Connection refused？ 2. 配置 conf/server.yaml 和 conf/config-* 语法用于查询数据迁移规则。### 语法 ShowMigrationRule ::= 'SHOW' 'MIGRATION' 'RULE' 返回值说明 列 说明 read 数据读取配置 write 数据写入配置 stream_channel 数据通道 9.2. ShardingSphere-Proxy 286 Apache ShardingSphere document 示例 • 查询数据迁移规则 SHOW