Sharding-JDBC+ Mybatis-Plus 实现读写分离

深碍√TFBOYSˉ_ 2022-11-06 02:55 89阅读 0赞

# 前言 #

Sharding-jdbc是开源的数据库操作中间件；这篇文章主要通过Sharding-JDBC 和mybatis-plus 需要的配置文件和maven依赖。

# 实践 #

**一、添加maven依赖。**

<dependencies>
           <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.3.2</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
                <version>8.0.13</version>
    
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.10</version>
                <scope>compile</scope>
            </dependency>
    
            <dependency>
                <groupId>com.github.xiaoymin</groupId>
                <artifactId>knife4j-spring-boot-starter</artifactId>
                <version>2.0.5</version>
            </dependency>
    
            <dependency>
                <groupId>cn.hutool</groupId>
                <artifactId>hutool-all</artifactId>
                <version>5.5.7</version>
            </dependency>
    
            <dependency>
                <groupId>io.shardingsphere</groupId>
                <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
                <version>3.1.0</version>
                <exclusions>
                    <exclusion>
                        <artifactId>guava</artifactId>
                        <groupId>com.google.guava</groupId>
                    </exclusion>
                </exclusions>
            </dependency>
    
        </dependencies>

**二、添加application.yml 配置文件**

server:
      port: 8082
    spring:
      main:
       allow-bean-definition-overriding: true #当遇到同样名字的时否允许覆盖注册候，是
    sharding:
      jdbc:
        datasource:
          names: ds0,ds1
          ds0:
            driver-class-name: com.mysql.cj.jdbc.Driver
            type: com.zaxxer.hikari.HikariDataSource
            jdbc-url: jdbc:mysql://1.15.63.xxx:3306/sync_test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
            username: root
            password: 123456
          ds1:
            driver-class-name: com.mysql.cj.jdbc.Driver
            type: com.zaxxer.hikari.HikariDataSource
            jdbc-url: jdbc:mysql://1.15.63.xxx:3307/sync_test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
            username: root
            password: 123456
        config:
          sharding:
            default-data-source-name: ds0
          masterslave:
            name: ms
            master-data-source-name: ds0
            slave-data-source-names: ds1
          props:
            sql.show: true

**三、代码**

由于代码和mybatis -Plus 没有变化这里不再贴出。

从上述日志中可以发现，增删改出现在主库，而读出现在了从库  
![在这里插入图片描述][20210307190231554.png]  
![在这里插入图片描述][20210307190319120.png]

[20210307190231554.png]: /images/20221023/ef35767653bb439db644ad154e3bbc3f.png
[20210307190319120.png]: /images/20221023/dd6ac4a338c949ad8e64be8439aa9daf.png