双数据源笔记

笔记笔记 这就是笔记。。。

更新了多数据源配置：https://blog.csdn.net/weixin_42563880/article/details/108829516

基本配置

spring:
  #排除DruidDataSourceAutoConfigure
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  datasource:
    dynamic:
      #设置默认的数据源或者数据源组,默认值即为master
      primary: master
      datasource:
        master:
          url: ${blade.datasource.master.url}
          driver-class-name: ${blade.datasource.master.driverClassName}
          username: ${blade.datasource.master.username}
          password: ${blade.datasource.master.password}
        slave:
          url: ${blade.datasource.slave.url}
          driver-class-name: ${blade.datasource.slave.driverClassName}
          username: ${blade.datasource.slave.username}
          password: ${blade.datasource.slave.password}

数据源切换@DS(“slave”)注解不生效
问题解决链接 ：https://www.cnblogs.com/xiaohouzixiashan/p/11847747.html
因为代码存在事务，在操作数据源的方法上加上@Transactional(propagation = Propagation.REQUIRES_NEW)

	@DS("slave")
	@Transactional(propagation = Propagation.REQUIRES_NEW)
	public void insert(QuarantineDto quarantineDto) {
		quarantineInoculateDetailsMapper.insert(quarantineDto);
	}