Spring Boot starter 数据分片配置说明

    1. # 数据源的公共配置
    2. spring.shardingsphere.datasource.common.type=com.zaxxer.hikari.HikariDataSource
    3. spring.shardingsphere.datasource.common.driver-class-name=com.mysql.cj.jdbc.Driver
    5. # 数据源的名称，下面jdbc-url,username,password得加上数据源名称
    6. spring.shardingsphere.datasource.names=test0,test1
    7. spring.shardingsphere.datasource.test0.jdbc-url=jdbc:mysql://localhost:3306/test0
    8. spring.shardingsphere.datasource.test0.username=root
    9. spring.shardingsphere.datasource.test0.password=Fuyu.742423672
    11. spring.shardingsphere.datasource.test1.jdbc-url=jdbc:mysql://localhost:3306/test1
    12. spring.shardingsphere.datasource.test1.username=root
    13. spring.shardingsphere.datasource.test1.password=Fuyu.742423672
    15. # SQL 日志
    16. spring.shardingsphere.props.sql-show=true
    17. # 配置test库中的user表规则，表示有两个库，每个库三个表
    18. spring.shardingsphere.rules.sharding.tables.user.actual-data-nodes=test$->{0..1}.user_$->{0..2}
    20. # 配置user表的分库策略
    21. spring.shardingsphere.rules.sharding.tables.user.database-strategy.standard.sharding-column=id
    22. # 分库策略的算法名，该值会用在具体算法的配置名中
    23. spring.shardingsphere.rules.sharding.tables.user.database-strategy.standard.sharding-algorithm-name=database-inline
    24. # 配置分库策略的算法类型，此处为行表达式分片算法
    25. spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.type=INLINE
    26. # 行表达式分片算法的行表达式
    27. spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.algorithm-expression=test$->{id % 2}
    29. # 配置user表的分表策略
    30. spring.shardingsphere.rules.sharding.tables.user.table-strategy.standard.sharding-column=user_id
    31. spring.shardingsphere.rules.sharding.tables.user.table-strategy.standard.sharding-algorithm-name=hash-mod
    32. # 此处为哈希取模
    33. spring.shardingsphere.rules.sharding.sharding-algorithms.hash-mod.type=HASH_MOD
    34. # 对3取模
    35. spring.shardingsphere.rules.sharding.sharding-algorithms.hash-mod.props.sharding-count=3
    38. # 配置user表的主键生成算法，此处采用雪花算法
    39. spring.shardingsphere.rules.sharding.tables.user.key-generate-strategy.column=id
    40. spring.shardingsphere.rules.sharding.tables.user.key-generate-strategy.key-generator-name=snowflake
    41. # 分布式序列算法配置
    42. spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE
    43. spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id=123