3.3.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Complex primary‐secondary database architecture . . . . . . . . . . . . . . . . . 35 3.3.5 Related References Feder‐ ation Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Sphere provides complex data query and analysis capabilities across data sources, simpli‐ fying 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

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 IN, BETWEEN AND, >, <, >=, <= are used; StandardShardingStrategy needs to be used together. • Complex Keys Sharding Algorithm ComplexKeysShardingAlgorithm is to process the sharding case in which multiple sharding keys are used; ComplexShardingStrategy needs to be used together. It has a relatively complex logic that requires developers to deal by themselves. • Hint Sharding Algorithm HintShardingAlgorithm

8.3.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 Complex primary‐secondary database architecture . . . . . . . . . . . . . . . . . 40 8.3.5 Related References Fe de ra ti on Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Sphere provides complex data query and analysis capabilities across data sources, simpli‐ fying 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

ShardingSphere-Scaling (Experimental) 9 3 Concepts The functions of Apache ShardingSphere are pretty complex with hundreds of modules, but the con‐ cepts are very simple and clear. Most modules are horizontal 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 AND, >, <, >=, <= are used. • Complex Keys Sharding Algorithm It is to process the sharding case in which multiple sharding keys are used. It has a relatively complex logic that requires developers

-P${proxy_port} 2.2. ShardingSphere-Proxy 9 3 Concepts The functions of Apache ShardingSphere are pretty complex with hundreds of modules, but the con‐ cepts are very simple and clear. Most modules are horizontal 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 AND, >, <, >=, <= are used. • Complex Keys Sharding Algorithm It is to process the sharding case in which multiple sharding keys are used. It has a relatively complex logic that requires developers

3.3.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Complex primary‐secondary database architecture . . . . . . . . . . . . . . . . . 36 3.3.5 Related References Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Sphere is capable of querying and analyzing complex data across data sources, simplifying and improving the stress testing scenario, ShardingSphere shadow DB is used for providing data isolation support for complex testing work. The obtained testing result can accurately reflect the system’s true capacity and

ShardingSphere-Scaling (Experimental) 9 3 Concepts The functions of Apache ShardingSphere are pretty complex with hundreds of modules, but the con‐ cepts are very simple and clear. Most modules are horizontal 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 AND, >, <, >=, <= are used. • Complex Keys Sharding Algorithm It is to process the sharding case in which multiple sharding keys are used. It has a relatively complex logic that requires developers

8.3.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 Complex primary‐secondary database architecture . . . . . . . . . . . . . . . . . 40 8.3.5 Related References Fe de ra ti on Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Sphere provides complex data query and analysis capabilities across data sources, simpli‐ fying 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

ShardingSphere document 8.2.7 核心概念 XA 协议 XA 协议最早的分布式事务模型是由 X/Open 国际联盟提出的 X/Open Distributed Transaction Processing (DTP) 模型，简称 XA 协议。 8.2.8 使用限制 虽然 Apache ShardingSphere 希望能够完全兼容所有的分布式事务场景，并在性能上达到最优，但在 CAP 分片策略只能选其一 standard: # 用于单分片键的标准分片场景 shardingColumn: # 分片列名称 shardingAlgorithmName: # 分片算法名称 complex: # 用于多分片键的复合分片场景 shardingColumns: # 分片列名称，多个列以逗号分隔 shardingAlgorithmName: # 分片算法名称 hint: # Hint -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-*

ShardingSphere document 8.2.7 核心概念 XA 协议 XA 协议最早的分布式事务模型是由 X/Open 国际联盟提出的 X/Open Distributed Transaction Processing (DTP) 模型，简称 XA 协议。 8.2.8 使用限制 虽然 Apache ShardingSphere 希望能够完全兼容所有的分布式事务场景，并在性能上达到最优，但在 CAP 分片策略只能选其一 standard: # 用于单分片键的标准分片场景 shardingColumn: # 分片列名称 shardingAlgorithmName: # 分片算法名称 complex: # 用于多分片键的复合分片场景 shardingColumns: # 分片列名称，多个列以逗号分隔 shardingAlgorithmName: # 分片算法名称 hint: # Hint -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-*