核心配置就是Math.abs(id.hashCode())%x,x为要分库或分表的数量。
spring:
shardingsphere:
props:
sql:
show: true #控制台打印sql
datasource:
names: ds0,ds1
ds0:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/seal_0?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
username: root
password: 123456
ds1:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/seal_1?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
username: root
password: 123456
sharding:
tables:
user:
actual-data-nodes: ds$->{0..1}.user_$->{0..2}
key-generator:
column: id
type: SNOWFLAKE
props:
worker.id: 100
max.vibration.offset: 2
database-strategy:
inline:
sharding-column: id
algorithm-expression: ds$->{Math.abs(id.hashCode())%2}
table-strategy:
inline:
sharding-column: id
algorithm-expression: user_$->{Math.abs(id.hashCode())%3}
mybatis:
config-location: classpath:mybatis-config.xml
mapper-locations:
- classpath*:com/zhut/**/sqlmap/*.xml