mysql 读写分离

 mysql 读写分离

1. 引入包

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.32</version>
</dependency>

 

2. yml配置

spring:
  datasource:
    dynamic:
      datasource:
        master:
          poolName: write-pool
          url: jdbc:mysql://192.168.10.10:6001/db?useUnicode=true&characterEncoding=UTF-8&noAccessToProcedureBodies=true&autoReconnect=true&failOverReadOnly=false&rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
          username: user_1
          password: password1
          driver-class-name: com.mysql.cj.jdbc.Driver
          hikari:
            max-pool-size: 100
            min-idle: 50
        slave:
          poolName: read-pool
          url: jdbc:mysql://192.168.10.10:6002/db?useUnicode=true&characterEncoding=UTF-8&noAccessToProcedureBodies=true&autoReconnect=true&failOverReadOnly=false&rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
          username: user_1
          password: password2
          driver-class-name: com.mysql.cj.jdbc.Driver
          hikari:
            max-pool-size: 100
            min-idle: 50

 

3. 配置bean：MasterSlaveAutoRoutingPlugin ，此插件自动完成dataSource配置读取与创建，自动封装增删改查拦截器

@Configuration
@MapperScan(basePackages = {"com.iv.**.mapper"})
public class DynamicDataSourceConfiguration {

    /**
     * 读写分离插件
*
     * @return MasterSlaveAutoRoutingPlugin
     */
@Bean
public MasterSlaveAutoRoutingPlugin masterSlaveAutoRoutingPlugin() {
        return new MasterSlaveAutoRoutingPlugin();
}

}

 

4.如果无法启动，则exclude，DataSourceAutoConfiguration.class

@SpringBootApplication(exclude={DataSourceAutoConfiguration.class})