Home Explore Help
Register Sign In
yufeng
/
sharding-jdbc-test
Watch 1
Star 0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: e479e17e18
Branches Tags
sharding-jdb...
/
src
/
main
/
resources
/
application-sharding.properties

application-sharding.properties 2.7 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435 
  1. sharding.jdbc.datasource.names=ds_0
    2. 

  2. 

  3. sharding.jdbc.datasource.ds_0.type=org.apache.commons.dbcp.BasicDataSource
    4. 

  4. sharding.jdbc.datasource.ds_0.driver-class-name=com.mysql.jdbc.Driver
    5. 

  5. sharding.jdbc.datasource.ds_0.url=jdbc:mysql://localhost:3306/demo_ds_0
    6. 

  6. sharding.jdbc.datasource.ds_0.username=root
    7. 

  7. sharding.jdbc.datasource.ds_0.password=123456
    8. 

  8. 

  9. #sharding.jdbc.config.sharding.default-data-source-name= ds_0
    10. 

  10. #sharding.jdbc.config.sharding.default-database-strategy.standard.sharding-column=order_code
    11. 

  11. #sharding.jdbc.config.sharding.default-database-strategy.standard.algorithm-class-name=io.shardingsphere.example.spring.boot.mybatis.algorithm.DatabaseShardingAlgorithm
    12. 

  12. #sharding.jdbc.config.sharding.default-key-generator-class-name= io.shardingsphere.example.spring.boot.mybatis.service.IDGenerator
    13. 

  13. 

  14. sharding.jdbc.config.sharding.tables.t_order.database-strategy.standard.sharding-column=order_code
    15. 

  15. sharding.jdbc.config.sharding.tables.t_order.database-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseDatabaseShardingAlgorithm
    16. 

  16. sharding.jdbc.config.sharding.tables.t_order.actual-data-nodes=ds_0.t_order_$->{2018..2019}_$->{0..1}
    17. 

  17. sharding.jdbc.config.sharding.tables.t_order.table-strategy.standard.sharding-column=order_code
    18. 

  18. sharding.jdbc.config.sharding.tables.t_order.key-generator-column-name=order_id
    19. 

  19. sharding.jdbc.config.sharding.tables.t_order.table-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseTableShardingAlgorithm
    20. 

  20. 

  21. #sharding.jdbc.config.sharding.tables.t_order_item.actual-data-nodes=ds_$->{0..1}.t_order_item_$->{0..1}
    22. 

  22. #sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.inline.sharding-column=order_id
    23. 

  23. #sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.inline.algorithm-expression=t_order_item_$->{order_id % 2}
    24. 

  24. #sharding.jdbc.config.sharding.tables.t_order_item.key-generator-column-name=order_item_id
    25. 

  25. 

  26. sharding.jdbc.config.sharding.tables.t_order_item.database-strategy.standard.sharding-column=order_code
    27. 

  27. sharding.jdbc.config.sharding.tables.t_order_item.database-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseDatabaseShardingAlgorithm
    28. 

  28. sharding.jdbc.config.sharding.tables.t_order_item.actual-data-nodes=ds_0.t_order_item_$->{2018..2019}_$->{0..1}
    29. 

  29. sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.standard.sharding-column=order_code
    30. 

  30. sharding.jdbc.config.sharding.tables.t_order_item.key-generator-column-name=order_item_id
    31. 

  31. sharding.jdbc.config.sharding.tables.t_order_item.table-strategy.standard.precise-algorithm-class-name=com.huojutech.sharding.algorithm.PreciseTableShardingAlgorithm
    32. 

  32. 

  33. sharding.jdbc.config.sharding.binding-tables[0]= t_order,t_order_item
    34. 

  34. 

  35. sharding.jdbc.config.sharding.props.sql.show= true
    36.