sharding-jdbc-example/orchestration-example/orchestration-spring-boot-postgresql-example/src/test/resources/application-local-zookeeper-sharding-master-slave.properties

spring.shardingsphere.datasource.names=ds_master_0,ds_master_1,ds_master_0_slave_0,ds_master_0_slave_1,ds_master_1_slave_0,ds_master_1_slave_1

spring.shardingsphere.datasource.ds_master_0.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.ds_master_0.driver-class-name=org.postgresql.Driver
spring.shardingsphere.datasource.ds_master_0.jdbc-url=jdbc:postgresql://localhost:5432/shardingsphere?currentSchema=demo_ds_master_0
spring.shardingsphere.datasource.ds_master_0.username=postgres
spring.shardingsphere.datasource.ds_master_0.password=

spring.shardingsphere.datasource.ds_master_0_slave_0.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.ds_master_0_slave_0.driver-class-name=org.postgresql.Driver
spring.shardingsphere.datasource.ds_master_0_slave_0.jdbc-url=jdbc:postgresql://localhost:5432/shardingsphere?currentSchema=demo_ds_master_0_slave_0
spring.shardingsphere.datasource.ds_master_0_slave_0.username=postgres
spring.shardingsphere.datasource.ds_master_0_slave_0.password=
spring.shardingsphere.datasource.ds_master_0_slave_1.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.ds_master_0_slave_1.driver-class-name=org.postgresql.Driver
spring.shardingsphere.datasource.ds_master_0_slave_1.jdbc-url=jdbc:postgresql://localhost:5432/shardingsphere?currentSchema=demo_ds_master_0_slave_1
spring.shardingsphere.datasource.ds_master_0_slave_1.username=postgres
spring.shardingsphere.datasource.ds_master_0_slave_1.password=

spring.shardingsphere.datasource.ds_master_1.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.ds_master_1.driver-class-name=org.postgresql.Driver
spring.shardingsphere.datasource.ds_master_1.jdbc-url=jdbc:postgresql://localhost:5432/shardingsphere?currentSchema=demo_ds_master_1
spring.shardingsphere.datasource.ds_master_1.username=postgres
spring.shardingsphere.datasource.ds_master_1.password=

spring.shardingsphere.datasource.ds_master_1_slave_0.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.ds_master_1_slave_0.driver-class-name=org.postgresql.Driver
spring.shardingsphere.datasource.ds_master_1_slave_0.jdbc-url=jdbc:postgresql://localhost:5432/shardingsphere?currentSchema=demo_ds_master_1_slave_0
spring.shardingsphere.datasource.ds_master_1_slave_0.username=postgres
spring.shardingsphere.datasource.ds_master_1_slave_0.password=
spring.shardingsphere.datasource.ds_master_1_slave_1.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.ds_master_1_slave_1.driver-class-name=org.postgresql.Driver
spring.shardingsphere.datasource.ds_master_1_slave_1.jdbc-url=jdbc:postgresql://localhost:5432/shardingsphere?currentSchema=demo_ds_master_1_slave_1
spring.shardingsphere.datasource.ds_master_1_slave_1.username=postgres
spring.shardingsphere.datasource.ds_master_1_slave_1.password=

spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=user_id
spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds_$->{user_id % 2}
spring.shardingsphere.sharding.binding-tables=t_order,t_order_item
spring.shardingsphere.sharding.broadcast-tables=t_address

spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds_$->{0..1}.t_order_$->{0..1}
spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id
spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order_$->{order_id % 2}
spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
spring.shardingsphere.sharding.tables.t_order.key-generator.props.worker.id=123
spring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds_$->{0..1}.t_order_item_$->{0..1}
spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
spring.shardingsphere.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item_$->{order_id % 2}
spring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id
spring.shardingsphere.sharding.tables.t_order_item.key-generator.type=SNOWFLAKE
spring.shardingsphere.sharding.tables.t_order_item.key-generator.props.worker.id=123

spring.shardingsphere.sharding.master-slave-rules.ds_0.master-data-source-name=ds_master_0
spring.shardingsphere.sharding.master-slave-rules.ds_0.slave-data-source-names=ds_master_0_slave_0, ds_master_0_slave_1
spring.shardingsphere.sharding.master-slave-rules.ds_1.master-data-source-name=ds_master_1
spring.shardingsphere.sharding.master-slave-rules.ds_1.slave-data-source-names=ds_master_1_slave_0, ds_master_1_slave_1

spring.shardingsphere.orchestration.name=local_sharding_master_slave
spring.shardingsphere.orchestration.overwrite=true
spring.shardingsphere.orchestration.registry.type=zookeeper
spring.shardingsphere.orchestration.registry.server-lists=localhost:2181
spring.shardingsphere.orchestration.registry.namespace=lorchestration-spring-boot-postgresql-local