1234567891011121314151617181920212223242526272829303132333435 |
- sharding.jdbc.datasource.names=ds_0
- sharding.jdbc.datasource.ds_0.type=org.apache.commons.dbcp.BasicDataSource
- sharding.jdbc.datasource.ds_0.driver-class-name=com.mysql.jdbc.Driver
- sharding.jdbc.datasource.ds_0.url=jdbc:mysql://localhost:3306/demo_ds_0
- sharding.jdbc.datasource.ds_0.username=root
- sharding.jdbc.datasource.ds_0.password=123456
- #sharding.jdbc.config.sharding.default-data-source-name= ds_0
- #sharding.jdbc.config.sharding.default-database-strategy.standard.sharding-column=order_code
- #sharding.jdbc.config.sharding.default-database-strategy.standard.algorithm-class-name=io.shardingsphere.example.spring.boot.mybatis.algorithm.DatabaseShardingAlgorithm
- #sharding.jdbc.config.sharding.default-key-generator-class-name= io.shardingsphere.example.spring.boot.mybatis.service.IDGenerator
- sharding.jdbc.config.sharding.tables.t_order.database-strategy.standard.sharding-column=order_code
- sharding.jdbc.config.sharding.tables.t_order.database-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseDatabaseShardingAlgorithm
- sharding.jdbc.config.sharding.tables.t_order.actual-data-nodes=ds_0.t_order_$->{2018..2019}_$->{0..1}
- sharding.jdbc.config.sharding.tables.t_order.table-strategy.standard.sharding-column=order_code
- sharding.jdbc.config.sharding.tables.t_order.key-generator-column-name=order_id
- sharding.jdbc.config.sharding.tables.t_order.table-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseTableShardingAlgorithm
- #sharding.jdbc.config.sharding.tables.t_order_item.actual-data-nodes=ds_$->{0..1}.t_order_item_$->{0..1}
- #sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
- #sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item_$->{order_id % 2}
- #sharding.jdbc.config.sharding.tables.t_order_item.key-generator-column-name=order_item_id
- sharding.jdbc.config.sharding.tables.t_order_item.database-strategy.standard.sharding-column=order_code
- sharding.jdbc.config.sharding.tables.t_order_item.database-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseDatabaseShardingAlgorithm
- sharding.jdbc.config.sharding.tables.t_order_item.actual-data-nodes=ds_0.t_order_item_$->{2018..2019}_$->{0..1}
- sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.standard.sharding-column=order_code
- sharding.jdbc.config.sharding.tables.t_order_item.key-generator-column-name=order_item_id
- sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseTableShardingAlgorithm
- sharding.jdbc.config.sharding.binding-tables[0]= t_order,t_order_item
- sharding.jdbc.config.sharding.props.sql.show= true
|