1、引入maven 依赖
<!-- mybatis-plus 多数据源 -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.3.2</version>
</dependency>
2、增加多数据源配置
#==============================数据库相关配置========================================
# master--分享中心数据源
spring.datasource.dynamic.primary=master
spring.datasource.dynamic.strategy = com.baomidou.dynamic.datasource.strategy.LoadBalanceDynamicDataSourceStrategy
spring.datasource.dynamic.datasource.master.url = jdbc:mysql://IP:13306/master?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
spring.datasource.dynamic.datasource.master.username = 用户名
spring.datasource.dynamic.datasource.master.password = 密码
spring.datasource.dynamic.datasource.master.driver-class-name = com.mysql.jdbc.Driver
#非主库数据源
spring.datasource.dynamic.datasource.slave.url = jdbc:mysql://IP:13306/slave?useUnicode=true&characterEncoding=utf8&useSSL=false
spring.datasource.dynamic.datasource.slave.username = username
spring.datasource.dynamic.datasource.slave.password = password
spring.datasource.dynamic.datasource.slave.driver-class-name = com.mysql.jdbc.Driver
3、增加指定数据源的注解, 默认是master 库
//@DS("master")
public interface BannerMapper extends BaseMapper<BannerDO> {
List<BannerDO> list();
}
@DS("slave")
public interface UserMapper extends BaseMapper<UserDO> {
}
4、测试类正常调试