spring mysql 主从 springboot配置主从数据库

1、pom.xml添加依赖

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

2、修改yml配置文件：master配置主库，slave配置从库

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    dynamic:
      primary: master
      datasource:
        master:
          username: root
          password: root
          url: jdbc:mysql://localhost:3306/mhxysy
        slave:
          username: root
          password: root
          url: jdbc:mysql://localhost:3306/cms

3、使用：在数据访问层方法上添加@DS注解，指定要是用的数据库，完成

@Repository
public interface AdminMapper {
    @DS("master")
    @Select("select * from admin")
    List<Admin> selectAllFromMaster();

    @DS("slave")
    @Select("select * from admin")
    List<Admin> selectAllFromSlave();
}