springboot读写分离配置

不想吃饭!

已于 2023-03-09 10:39:05 修改

阅读量335

点赞数

文章标签： spring boot java log4j

于 2023-03-09 10:23:41 首次发布

本文链接：https://blog.csdn.net/weixin_46089846/article/details/129416686

版权

本文介绍了如何在SpringBoot应用中配置读写分离，包括设置多数据源、编写配置类，以及在代码中如何切换数据源。通过Mybatis的一层代理实现自动数据库切换，适合需要进行数据库读写分离的开发者参考。

摘要由CSDN通过智能技术生成

1.设置多数据源

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    druid:
      read:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3310/jpgs?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=Asia/Shanghai&verifyServerCertificate=false&zeroDateTimeBehavior=CONVERT_TO_NULL&tinyInt1isBit=false&allowMultiQueries=true&useAffectedRows=true
        username: root
        password: 123456
      write:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3310/jpgs?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=Asia/Shanghai&verifyServerCertificate=false&zeroDateTimeBehavior=CONVERT_TO_NULL&tinyInt1isBit=false&allowMultiQueries=true&useAffectedRows=true
        username: root
        password: 123456

2.编写配置类

public class DataSourceHolder {
   

    public static final String WRITE_DATASOURCE = "write";
    public static final String READ_DATASOURCE = "read";

    private static final ThreadLocal<String> local = new ThreadLocal<>();


    public static void putDataSource(String dataSource) {
   
        local.set(dataSource);
    }

    public static String getDataSource() {
   
        return