| spring.shardingsphere.datasource.names=ds_0,ds_1 |
| |
| spring.shardingsphere.datasource.ds_0.type=com.zaxxer.hikari.HikariDataSource |
| spring.shardingsphere.datasource.ds_0.driver-class-name=com.mysql.jdbc.Driver |
| spring.shardingsphere.datasource.ds_0.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8 |
| spring.shardingsphere.datasource.ds_0.username=root |
| spring.shardingsphere.datasource.ds_0.password= |
| |
| spring.shardingsphere.datasource.ds_1.type=com.zaxxer.hikari.HikariDataSource |
| spring.shardingsphere.datasource.ds_1.driver-class-name=com.mysql.jdbc.Driver |
| spring.shardingsphere.datasource.ds_1.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8 |
| spring.shardingsphere.datasource.ds_1.username=root |
| spring.shardingsphere.datasource.ds_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 |
| 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 |
| 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 |
| |