. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 Metadata Repository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 Sharding Algorithm . . Standalone, Cluster repository (?): # Persist repository configuration 4.1. ShardingSphere-JDBC 55 Apache ShardingSphere document, v5.2.1 Standalone Mode mode: type: Standalone repository: type: # Type persist repository props: # Properties of persist repository foo_key: foo_value bar_key: bar_value Cluster Mode (recommended) mode: type: Cluster repository: type: # Type of persist repository props:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Metadata Repository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Sharding Algorithm . . Standalone type: # Type of mode configuration. Values could be: Standalone, Cluster repository (?): # Persist repository configuration overwrite: # Whether overwrite persistent configuration with local document, v5.2.0 Standalone Mode mode: type: Standalone repository: type: # Type of persist repository props: # Properties of persist repository foo_key: foo_value bar_key: bar_value overwrite: # Whether

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431 Metadata Repository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431 Sharding Algorithm . . Standalone, Cluster repository (?): # Persist repository configuration 9.1. ShardingSphere-JDBC 61 Apache ShardingSphere document Standalone Mode mode: type: Standalone repository: type: # Type of persist repository props: # Properties of persist repository foo_key: foo_value bar_key: bar_value Cluster Mode (recommended) mode: type: Cluster repository: type: # Type of persist repository props:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400 Metadata Repository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400 Sharding Algorithm . . Standalone, Cluster repository (?): # Persist repository configuration 9.1. ShardingSphere-JDBC 59 Apache ShardingSphere document Standalone Mode mode: type: Standalone repository: type: # Type of persist repository props: # Properties of persist repository foo_key: foo_value bar_key: bar_value Cluster Mode (recommended) mode: type: Cluster repository: type: # Type of persist repository props:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 Metadata Repository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 Sharding Algorithm . . Standalone, Cluster M e m o r y r e p o s i t o r y Persi stRep osito ryCon figur ation Persist repository configurationMem‐ ory type does not need persist, could be nullStandalone type uses StandalonePer‐ mode.repository.standalone.StandalonePersistRepositoryConfiguration Attributes: Name DataType Description type String Type of persist repository props Properties Properties of persist repository Cluster

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130 Metadata Repository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130 Sharding Algorithm . . Standalone, Cluster M e m o r y r e p o s i t o r y Persi stRep osito ryCon figur ation Persist repository configurationMem‐ ory type does not need persist, could be nullStandalone type uses StandalonePer‐ mode.repository.standalone.StandalonePersistRepositoryConfiguration Attributes: Name DataType Description type String Type of persist repository props Properties Properties of persist repository Cluster

不配置则默认单机模式 type: # 运行模式类型。可选配置：Standalone、Cluster repository (?): # 久化仓库配置 overwrite: # 是否使用本地配置覆盖持久化配置 单机模式 mode: type: Standalone repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 foo_key: foo_value ShardingSphere-JDBC 51 Apache ShardingSphere document, v5.2.0 集群模式 (推荐) mode: type: Cluster repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 namespace: # 注册中心命名空间 server-lists: # 注册中心连接地址 foo_key: 集群模式部署推荐使用 ZooKeeper 注册中心。 配置示例 单机模式 mode: type: Standalone repository: type: File overwrite: false 集群模式 (推荐) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists:

org.apache.shardingsphere shardingsphere-cluster-mode-repository-zookeeper-curator ${shardingsphere.version} org.apache.shardingsphere shardingsphere-cluster-mode-repository-etcd ${shardingsphere.version} 5.1. ShardingSphere-JDBC org.apache.shardingsphere shardingsphere-cluster-mode-repository-zookeeper-curator ${shardingsphere.version}

org.apache.shardingsphere shardingsphere-cluster-mode-repository-zookeeper-curator ${shardingsphere.version} ShardingSphere-JDBC 83 Apache ShardingSphere document, v5.0.0 shardingsphere-cluster-mode-repository-etcd ${shardingsphere.version} 规则配置 以下示例将 ZooKeeper org.apache.shardingsphere shardingsphere-cluster-mode-repository-zookeeper-curator ${shardingsphere.version}

参数解释 mode (?): # 不配置则默认单机模式 type: # 运行模式类型。可选配置：Standalone、Cluster repository (?): # 持久化仓库配置 单机模式 mode: type: Standalone repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 foo_key: foo_value bar_key: 9.1. ShardingSphere-JDBC 53 Apache ShardingSphere document 集群模式 (推荐) mode: type: Cluster repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 namespace: # 注册中心命名空间 server-lists: # 注册中心连接地址 foo_key: 存在配置信息时，则以 ZooKeeper 中的配置为准。 配置示例 单机模式 mode: type: Standalone repository: type: JDBC 集群模式 (推荐) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists: localhost:2181