4.1 Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.5 Roadmap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 3.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 ii 3.3 Readwrite‐splitting . . . .

. 10 Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2 Quick Start . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 3.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 3.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 ii 3.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 3.3 Readwrite‐splitting . . . . . .

Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 5 Roadmap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3 Readwrite‐splitting . . . . . .

Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 5 Roadmap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.2.9 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 8.3 Readwrite‐splitting . . . . . .

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

provided by different database dialect, it is categorized into keyword, expression, literal value and operator. SQL is then converted into abstract syntax tree by syntactic parser. For example, the following single‐sharding route (equal mark as the operator of sharding key), multiple‐sharding route (IN as the operator of sharding key) and range sharding route (BETWEEN as the operator of sharding key). SQL without sharding not include joint query or only includes joint query between binding tables. When the sharding operator is equal mark, the route result will fall into a single database (table); when sharding operators

时，需要引入此模块 --> org.apache.shardingsphere shardingsphere-cluster-mode-repository-zookeeper-curator ${shardingsphere.version} 5.1. ShardingSphere-JDBC 83 Apache ShardingSphere document, v5.0.0 shardingsphere-cluster-mode-repository-etcd ${shardingsphere.version} 规则配置 -data-source ", "localhost:2181", new Properties()); // 配置 Cluster Config ModeConfiguration modeConfig = new ModeConfiguration("Cluster", registryCenterConfig, true); // 创建 ShardingSphereDataSource

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 484 13.1.1 MODE 集群模式 Cluster 和 Compatible_Cluster 区别? . . . . . . . . . . . 484 13.2 JDBC . . . . . . . . . . . . . . . . . . . . . . 表示可以包含一个或多个 [] 表示数组，可以与减号相互替换使用 模式配置 参数解释 mode (?): # 不配置则默认单机模式 type: # 运行模式类型。可选配置：Standalone、Cluster repository (?): # 持久化仓库配置 单机模式 mode: type: Standalone repository: type: # 持久化仓库类型 props: # bar_value 9.1. ShardingSphere-JDBC 53 Apache ShardingSphere document 集群模式 (推荐) mode: type: Cluster repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 namespace: # 注册中心命名空间 server-lists: # 注册中心连接地址