shardingJDBC 分表配置

shardingsphere 分表配置

spring.shardingsphere.datasource.names=point0   #数据库

spring.shardingsphere.datasource.point0.jdbcUrl=jdbc:mysql://XXXX:3306/point?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
spring.shardingsphere.datasource.point0.username=XX
spring.shardingsphere.datasource.point0.password=XX
spring.shardingsphere.datasource.point0.driver-class-name=com.mysql.jdbc.Driver

spring.shardingsphere.datasource.point0.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.point0.minimum-idle=150
spring.shardingsphere.datasource.point0.maximum-pool-size=200
spring.shardingsphere.datasource.point0.auto-commit=true
spring.shardingsphere.datasource.point0.idle-timeout=30000
spring.shardingsphere.datasource.point0.pool-name=ShareHikariCP0
spring.shardingsphere.datasource.point0.max-lifetime=1800000
spring.shardingsphere.datasource.point0.connection-timeout=30000
spring.shardingsphere.datasource.point0.connection-test-query=SELECT 1

spring.shardingsphere.sharding.default-data-source-name=point0

#账户表 分表配置
spring.shardingsphere.sharding.tables.account.actual-data-nodes=point0.account_$->{0..31}
spring.shardingsphere.sharding.tables.account.table-strategy.inline.sharding-column=user_id
spring.shardingsphere.sharding.tables.account.table-strategy.inline.algorithm-expression=account_$->{user_id % 32}
spring.shardingsphere.sharding.tables.account.key-generator.column=id
spring.shardingsphere.sharding.tables.account.key-generator.type=SNOWFLAKE
spring.shardingsphere.sharding.tables.account.key-generator.props.worker.id=${random.int[0,1024]}
spring.shardingsphere.sharding.tables.account.key-generator.props.max.tolerate.time.difference.milliseconds=10