shardingsphere 水平分库 水平分表

接上篇 读写分离的代码 基础上 配置文件做了改动 

1、根据用户id 生成 去做水平分库  id取模为奇数 在0库 偶数为1库 

2、根据性别进行分表 值为0 进0表 为1 就进1表

 

server.port=8080

#mysql
#spring.datasource.url=jdbc:mysql://localhost:3306/user_db?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
spring.shardingsphere.datasource.names=master0,master1,slave1,slave2
spring.shardingsphere.datasource.master0.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.master0.url=jdbc:mysql://localhost:3306/user_db_1?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
spring.shardingsphere.dataSource.master0.username=root
spring.shardingsphere.dataSource.master0.password=123456
spring.shardingsphere.dataSource.master0.maxPoolSize=20
spring.shardingsphere.dataSource.master0.driver-class-name=com.mysql.cj.jdbc.Driver


spring.shardingsphere.datasource.master1.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.master1.url=jdbc:mysql://localhost:3306/user_db_2?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
spring.shardingsphere.dataSource.master1.username=root
spring.shardingsphere.dataSource.master1.password=123456
spring.shardingsphere.dataSource.master1.maxPoolSize=20
spring.shardingsphere.dataSource.master1.driver-class-name=com.mysql.cj.jdbc.Driver



#根据id分表
# 指定t_user表的数据分布情况，配置数据节点 master.t_user0,master.t_user1
spring.shardingsphere.sharding.tables.t_user.actual-data-nodes=master$->{0..1}.t_user$->{0..1}
# 指定t_user表的主键生成策略为SNOWFLAKE
spring.shardingsphere.sharding.tables.t_user.key-generator.column=user_id
spring.shardingsphere.sharding.tables.t_user.key-generator.type=SNOWFLAKE


# 指定t_user表的分片策略，分片策略包括分片键和分片算法 按照性别进行分表
spring.shardingsphere.sharding.tables.t_user.table-strategy.inline.sharding-column=sex
spring.shardingsphere.sharding.tables.t_user.table-strategy.inline.algorithm-expression=t_user$->{sex}

#根据id取模进行分库
spring.shardingsphere.sharding.tables.t_user.database-strategy.inline.sharding-column=user_id
spring.shardingsphere.sharding.tables.t_user.database-strategy.inline.algorithm-expression=master$->{user_id % 2}


mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
#打印sql到控制台
spring.shardingsphere.props.sql.show=true
#设置访问druid监控页的账号和密码,默认没有
spring.datasource.druid.stat-view-servlet.login-username=admin
spring.datasource.druid.stat-view-servlet.login-password=admin
spring.main.allow-bean-definition-overriding=true