1.官方文档
https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/single/
2.建两个数据库
shardingsphereconf.yaml中添加：
...
dataSources:
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl: jdbc:mysql://192.168.83.130:3310/shardingSphereTest?useUnicode=true&autoReconnect=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai
username: root
password: root
ds_2:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl: jdbc:mysql://192.168.83.130:3311/shardingSphereTest?useUnicode=true&autoReconnect=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai
username: root
password: root
...
3.配置垂直分片
在两个数据库中分别建表user和user_order
shardingsphereconf.yaml中添加：
...
rules:
- !SHARDING
tables:
user:
actualDataNodes: ds_1.user
user_order:
actualDataNodes: ds_2.user_order
...
user、user_order代表逻辑名，actualDataNodes为实际数据源及表名
4.打印sql
shardingsphereconf.yaml中添加：
...
props:
sql-show: true
...
官方文档：
https://shardingsphere.apache.org/document/current/cn/user-manual/common-config/props/
5.参考代码
链接： https://pan.baidu.com/s/18RtNH4ihvqiun-iVKae7jg?pwd=1111
提取码：1111
需要用init.sql中语句建表，更换数据库链接和账号密码