sharding-jdbc总结（二）读写分离

水深无声 2022-01-11 03:29 118阅读 0赞

之前由一篇[总结springboot与sharding-jdbc整合][springboot_sharding-jdbc]

**目录**

配置多数据源

结果运行

--------------------

# 配置多数据源 #

sharding.jdbc.datasource.names=sharding_0,sharding_1
    # 多数据源
    sharding.jdbc.datasource.sharding_0.type=com.alibaba.druid.pool.DruidDataSource
    sharding.jdbc.datasource.sharding_0.driver-class-name=com.mysql.jdbc.Driver
    sharding.jdbc.datasource.sharding_0.url=jdbc:mysql://localhost:3306/sharding_0?characterEncoding=utf-8
    sharding.jdbc.datasource.sharding_0.username=root
    sharding.jdbc.datasource.sharding_0.password=123456
    
    sharding.jdbc.datasource.sharding_1.type=com.alibaba.druid.pool.DruidDataSource
    sharding.jdbc.datasource.sharding_1.driver-class-name=com.mysql.jdbc.Driver
    sharding.jdbc.datasource.sharding_1.url=jdbc:mysql://localhost:3306/sharding_1?characterEncoding=utf-8
    sharding.jdbc.datasource.sharding_1.username=root
    sharding.jdbc.datasource.sharding_1.password=123456
    
    
    # 读写分离配置
    sharding.jdbc.config.masterslave.load-balance-algorithm-type=round_robin
    sharding.jdbc.config.masterslave.name=dataSource
    sharding.jdbc.config.masterslave.master-data-source-name=sharding_0
    sharding.jdbc.config.masterslave.slave-data-source-names=sharding_1
    
    mybatis.mapperLocations=classpath:mapper/*Mapper.xml
    
    logging.level.com.example.demo.dao=debug

# 结果运行 #

两个库没有同步，插入了之后，从库读不到。证明我们配置以及成功了

2019-06-19 14:49:47.591 DEBUG 18692 --- \[           main\] com.example.demo.dao.UserDao.insert      : ==>  Preparing: insert into t\_user\_0 (user\_id,name,age) values (?,?,?)   
2019-06-19 14:49:47.703 DEBUG 18692 --- \[           main\] com.example.demo.dao.UserDao.insert      : ==> Parameters: 77(Integer), 77(String), 77(Integer)  
2019-06-19 14:49:47.708 DEBUG 18692 --- \[           main\] com.example.demo.dao.UserDao.insert      : <==    Updates: 1  
1  
2019-06-19 14:49:47.715 DEBUG 18692 --- \[           main\] com.example.demo.dao.UserDao.select      : ==>  Preparing: select \* from t\_user\_0 where user\_id = ?   
2019-06-19 14:49:47.717 DEBUG 18692 --- \[           main\] com.example.demo.dao.UserDao.select      : ==> Parameters: 77(Integer)  
2019-06-19 14:49:47.728 DEBUG 18692 --- \[           main\] com.example.demo.dao.UserDao.select      : <==      Total: 0  
\[\]

[springboot_sharding-jdbc]: https://blog.csdn.net/weixin_38336658/article/details/92783577