. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 4.5 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 4.5.1 Background Availability Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 Dynamic Readwrite‐Splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 4.6.5 Use Norms . . . . . . . . . databases in the same log . . . . . . . . . . . . . . . . . . . . . . 215 To distinguish databases and users in the same log . . . . . . . . . . . . . . . . . 216 To split into different log files . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 4.5 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 4.5.1 Background Availability Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 Dynamic Readwrite‐Splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 4.6.5 Use Norms . . . . . . . . . DatabaseSQLEntry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 6.8 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 6.8.1 ReadwriteSplittingType

Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3.1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Transaction . . . . . Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 452 10.4 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 452 10.4.1 ReadQue

Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3.1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134 Transaction . . . . . /w ri te S pl it ti ng Read/write splitting can be used to cope with business access with high stress. Sharding‐ Sphere provides flexible read/write splitting capabilities and can achieve read access

Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 3.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 3.3.1 Background Availability Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Dynamic Read/Write Splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 3.4.7 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 Readwrite Splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Transaction . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 4.4 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 4.4.1 Background DatabaseSQLEntry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226 6.5 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226 6.5.1 ReplicaLoadBalanceAlgorithm access entry to provide additional features transparently, such as: redirect (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority)

with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 ii 3.3 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 3.3.1 Background Availability Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Dynamic Read/Write Splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 3.4.7 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Readwrite Splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 Transaction . . . . .

DatabaseSQLEntry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 285 vi 5.5 Readwrite‐splitting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 286 5.5.1 ReplicaLoadBalanceAlgorithm competition, so the relational database still holds an unshakable position. Sharding refers to splitting the data in one database and storing them in multiple tables and databases according to some certain effectively avoid the data concen‐ trating on one node and increase the architecture availability. Splitting data through database sharding and table sharding is an effective method to deal with high TPS

9.1. ShardingSphere-JDBC 62 Apache ShardingSphere document 参数解释 读写分离 rules: - !READWRITE_SPLITTING dataSourceGroups: (+): # 读写分离逻辑数据源名称，默认使用 Groovy 的行表达式 SPI 实现来 解析 write_data_source_name: 算法类型的详情，请参见内置负载均衡算法列表。 操作步骤 1. 添加读写分离数据源 2. 设置负载均衡算法 3. 使用读写分离数据源 配置示例 rules: - !READWRITE_SPLITTING dataSourceGroups: readwrite_ds: writeDataSourceName: write_ds readDataSourceNames: - read_ds_0 classpath 中添加 jta.properties 来定制化 Atomikos 配置项。 详情请参见 Atomikos 官方文档 。 数据恢复 在项目的 logs 目录中会生成 xa_tx.log, 这是 XA 崩溃恢复时所需的日志，请勿删除。 Narayana 事务 背景信息 Apache ShardingSphere 提供 XA 事务，集成了 Narayana 的实现。 前提条件

ShardingSphere-JDBC 57 Apache ShardingSphere document, v5.2.0 参数解释 静态读写分离 rules: - !READWRITE_SPLITTING dataSources: (+): # 读写分离逻辑数据源名称 static-strategy: # 读写分离类型 write-data-source-name: (+): # 负载均衡算法名称 type: # 负载均衡算法类型 props: # 负载均衡算法属性配置 # ... 动态读写分离 rules: - !READWRITE_SPLITTING dataSources: (+): # 读写分离逻辑数据源名称 dynamic-strategy: # 读写分离类型 auto-aware-data-source-name: ShardingSphere document, v5.2.0 操作步骤 1. 添加读写分离数据源 2. 设置负载均衡算法 3. 使用读写分离数据源 配置示例 rules: - !READWRITE_SPLITTING dataSources: readwrite_ds: staticStrategy: writeDataSourceName: write_ds readDataSourceNames: