Mysql读写分离（SpringBoot2 + Druid + MybatisPlus + Sharding-JDBC）

开发环境：
SpringBoot2 + Druid + MybatisPlus + Sharding-JDBC

一、引入jar包

pom.xml文件中引入以下依赖。

<!-- Sharding-JDBC for spring boot -->
<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
    <version>4.0.0-RC1</version>
</dependency>

<!-- Sharding-JDBC for spring namespace -->
<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-namespace</artifactId>
    <version>4.0.0-RC1</version>
</dependency>

<!-- Druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.18</version>
    <scope>compile</scope>
</dependency>

<!--Mybatis plus-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.1.2</version>
</dependency>

<!--mysql connector-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.16</version>
</dependency>

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>

二、配置文件

application.yml中添加如下分库分表的设置。

spring:
  main:
    # 允许Bean定义被后定义的Bean覆盖
    allow-bean-definition-overriding: true
  shardingsphere:
    # 定义数据源
    datasource:
      names: master,slave0
      master:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/master
        username: test
        password: test
      slave0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/slave
        username: test
        password: test
    # 定义读写分离相关
    masterslave:
      name: ds_ms
      master-data-source-name: master
      slave-data-source-names: slave0
      load-balance-algorithm-type: round_robin
    # 打印SQL，方便调试
    props:
      sql:
        show: true

三、测试结果

1、写入主库。

2、读从读库查询，且轮训的查询。