ITeye博客

mysql 读写分离

e_e · 2023-07-18 18:45 · mysql · springboot · 编程语言 · Markdown

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})

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。