props: # Properties of persist repository namespace: # Namespace of registry center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value overwrite: # Whether overwrite (recommended) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists: localhost:2181 retryIntervalMilliseconds: 500 timeToLiveSeconds: 60 overwrite: false Related String Type of persist repository namespace String Namespace of registry center server‐lists String Server lists of registry center props Properties Properties of persist repository Notes 1. Cluster

props: # Properties of persist repository namespace: # Namespace of registry center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value Notes 1. Cluster mode deployment (recommended) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists: localhost:2181 retryIntervalMilliseconds: 500 timeToLiveSeconds: 60 Related References • Installation String Type of persist repository namespace String Namespace of registry center server‐lists String Server lists of registry center props Properties Properties of persist repository Notes 1. Cluster

78 Apache ShardingSphere document, v5.0.0-beta Agent Configuration It is found under the local package directory and unzip directory : agent.yaml ˋˋˋyaml applicationName: shardingsphere‐agent # application lower. Software Environment Jenins: The latest version Sysbench: 1.0.20 ShardingSphere-Proxy: package from master branch MySQL Server: 5.7.28 Test Program According to the above hardware environment (runs on the ${host-jenkins} ma‐ chine). 1. sysbench_install: Pull the latest code, package the Proxy compression package The following tasks are run on a separate Sysbench pressure generating machine via

Agent configuration • Directory structure Create agent directory, and unzip agent distribution package to the directory. ˋˋˋshell mkdir agent tar ‐zxvf apache‐shardingsphere‐latest.release.version − Type of persist repository namespace String Namespace of registry center serverLists String Server lists of registry center props Properties Properties of persist repository 5.1. ShardingSphere-JDBC 71 props: # Properties of persist repository namespace: # Namespace of registry center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value overwrite: # Whether overwrite

-javaagent:\absolute path\shardingsphere-agent.jar Agent Configuration It is found under the local package directory and unzip directory : agent.yaml applicationName: shardingsphere-agent # application name example. mode: type: Cluster repository: type: ZooKeeper props: namespace: governance_ds server-lists: localhost:2181 overwrite: true // Create ShardingSphereDataSource DataSource dataSource = Yam namespace=governance-spring-boot- shardingsphere-test spring.shardingsphere.mode.repository.props.server-lists=localhost:2181 spring.shardingsphere.mode.overwrite=true Use ShardingSphereDataSource in Spring

Agent configuration • Directory structure Create agent directory, and unzip agent distribution package to the directory. ˋˋˋshell mkdir agent tar ‐zxvf apache‐shardingsphere‐latest.release.version − Type of persist repository namespace String Namespace of registry center serverLists String Server lists of registry center props Properties Properties of persist repository 5.1. ShardingSphere-JDBC 74 props: # Properties of persist repository namespace: # Namespace of registry center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value overwrite: # Whether overwrite

Limitations Hint based shadow algorithm No Column based shadow algorithm SQL does not support lists：‐ Does not support DDL. • Does not support scope, group, subqueries such as BETWEEN, GROUP BY ⋯HAVING props: # Properties of persist repository namespace: # Namespace of registry center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value Notes 1. Cluster mode deployment (recommended) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists: localhost:2181 retryIntervalMilliseconds: 500 timeToLiveSeconds: 60 Using the persistent repository

props: # Properties of persist repository namespace: # Namespace of registry center server-lists: # Server lists of registry center foo_key: foo_value bar_key: bar_value Notes 1. Cluster mode deployment (recommended) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists: localhost:2181 retryIntervalMilliseconds: 500 timeToLiveSeconds: 60 Using the persistent repository String Type of persist repository namespace String Namespace of registry center server‐lists String Server lists of registry center props Properties Properties of persist repository Notes 1. Cluster

xsd "> lists="yourhost:2181" namespace= "my-job" base-sleep-time-milliseconds="1000" max-sleep-time-milliseconds="3000" elasticjob.xsd "> lists="yourhost:2181" namespace= "dd-job" base-sleep-time-milliseconds="1000" max-sleep-time-milliseconds="3000" "> lists="yourhost:2181" namespace= "my-job" base-sleep-time-milliseconds="1000" max-sleep-time-milliseconds="3000"

mode: type: Cluster repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 namespace: # 注册中心命名空间 server-lists: # 注册中心连接地址 foo_key: foo_value bar_key: bar_value 注意事项 1. 生产环境建议使用集群模式部署。 2. 集群模式部署推荐使用 ZooKeeper 集群模式 (推荐) mode: type: Cluster repository: type: ZooKeeper props: namespace: governance server-lists: localhost:2181 retryIntervalMilliseconds: 500 timeToLiveSeconds: 60 使用持久化仓库需要额外引入对应的 Maven 依赖，推荐使用： ClusterPersistRepositoryConfiguration 可配置属性： 名称 数据类型 说明 type String 持久化仓库类型 namespace String 注册中心命名空间 server‐lists String 注册中心连接地址 props Properties 持久化仓库所需属性 注意事项 1. 生产环境建议使用集群模式部署。 2. 集群模式部署推荐使用 ZooKeeper 注册中心。