4.1 Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.5 Roadmap . 42 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Source . . requirement for a data storage and computing platform. Guar‐ antee the HA of your distributed database cluster with ShardingSphere’s Operator on Ku‐ bernetes, and the native HA of your existing data sources

. 10 Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2 Quick Start 43 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Source . . 2.0 1.3.2 Running Modes Apache ShardingSphere provides two running modes: standalone mode and cluster mode. Standalone mode It can achieve data persistence in terms of metadata information such as

3 Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . users for quick test startup, stand‐alone running and cluster running, Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5 create a .shardingsphere file in the root directory to store configuration data by default. 3.2.4 Cluster mode Suitable for use in distributed scenarios which provides metadata sharing and state coordination

3 Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . users for quick test startup, stand‐alone running and cluster running, Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5 create a .shardingsphere file in the root directory to store configuration data by default. 3.2.4 Cluster mode Suitable for use in distributed scenarios which provides metadata sharing and state coordination

Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 i 3.2.4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . SQL92 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 4.2 Cluster Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 4.2.1 Background users for quick test startup, stand‐alone running and cluster running, Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5

Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 5 Roadmap 45 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Source . . . . . . . . . . . . . . . . 546 13.1.2 MODE What is the difference between cluster mode Cluster and Compati- ble_Cluster? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 546 13

Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 5 Roadmap 45 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Source . . Architecture 10 4 Running Modes Apache ShardingSphere provides two running modes: standalone mode and cluster mode. 4.1 Standalone Mode It can achieve data persistence in terms of metadata information such

表示可以包含一个或多个 [] 表示数组，可以与减号相互替换使用 模式配置 参数解释 mode (?): # 不配置则默认单机模式 type: # 运行模式类型。可选配置：Standalone、Cluster repository (?): # 久化仓库配置 overwrite: # 是否使用本地配置覆盖持久化配置 单机模式 mode: type: Standalone repository: 是否使用本地配置覆盖持久化配置 4.1. ShardingSphere-JDBC 51 Apache ShardingSphere document, v5.2.0 集群模式 (推荐) mode: type: Cluster repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 namespace: # 注册中心命名空间 server-lists: # 注册中心连接地址 单机模式 mode: type: Standalone repository: type: File overwrite: false 集群模式 (推荐) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists: localhost:2181 retr

each data node to manage their own transactions on the premise that any distributed trans‐ action manager is not on. They do not have any coordination and communication ability, or know other data nodes Model defined by X/OPEN, in which created AP (Application Pro‐ gram), TM (Transaction Manager) and RM (Resource Manager) can guarantee a high transaction con‐ sistency. TM and RM use XA protocol for bidirectional XA driver provided by database manufacturers and TransactionManager is provided by trans‐ action manager manufacturers. Traditional transaction managers need to be bound with application server, which

DataSource dataSource; 强制路由 简介 Apache ShardingSphere 使用 ThreadLocal 管理分片键值进行强制路由。可以通过编程的方式向 Hint‐ Manager 中添加分片值，该分片值仅在当前线程内生效。 Hint 的主要使用场景： • 分片字段不存在 SQL 和数据库表结构中，而存在于外部业务逻辑。 • 强制在主库进行某些数据操作。 5.1. defaultType: XA providerType: Narayana SpringBoot: spring: shardingsphere: props: xa-transaction-manager-type: Narayana Spring Namespace: 5.1. ShardingSphere-JDBC 80 Apache ShardingSphere document, v5.0.0 Narayana Bitronix 事务 引入 Maven 依赖