| spring.shardingsphere.datasource.names=ds |
| |
| spring.shardingsphere.datasource.ds.type=com.zaxxer.hikari.HikariDataSource |
| spring.shardingsphere.datasource.ds.driver-class-name=com.mysql.jdbc.Driver |
| spring.shardingsphere.datasource.ds.jdbc-url=jdbc:mysql://localhost:3306/demo_ds?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8 |
| spring.shardingsphere.datasource.ds.username=root |
| spring.shardingsphere.datasource.ds.password= |
| |
| spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds.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.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.binding-tables=t_order,t_order_item |
| spring.shardingsphere.sharding.broadcast-tables=t_address |
