多数据源配置

导入依赖




<dependency>
	<groupId>com.baomidou</groupId>
	<artifactId>mybatis-plus-boot-starter</artifactId>
	<version>${mybatis-plus.version}</version>
</dependency>
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid-spring-boot-starter</artifactId>
	<version>${druid.version}</version>
</dependency>
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>${mysql.version}</version>
</dependency>


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


spring.datasource.dynamic.primary=one#需要指定默认的数据源或者数据源组
spring.datasource.dynamic.datasource.one.url=jdbc:mysql:replication://localhost:3306,localhost:3306/aaa?useSSL=false&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&useOldAliasMetadataBehavior=true&autoReconnect=true&roundRobinLoadBalance=true&serverTimezone=GMT%2B8
spring.datasource.dynamic.datasource.one.driver-class-name=com.mysql.jdbc.ReplicationDriver
spring.datasource.dynamic.datasource.aaa.username=aaa
spring.datasource.dynamic.datasource.aaa.password=aaa@123


spring.datasource.dynamic.datasource.two.url=jjdbc:mysql:replication://localhost:3307,ocalhost:3307/bbb?useSSL=false&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&useOldAliasMetadataBehavior=true&autoReconnect=true&roundRobinLoadBalance=true&serverTimezone=GMT%2B8
spring.datasource.dynamic.datasource.two.driver-class-name=com.mysql.jdbc.ReplicationDriver
spring.datasource.dynamic.datasource.bbb.username=bbb
spring.datasource.dynamic.datasource.bbb.password=bbb@123


原来的一些配置

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.max-active=10
spring.datasource.druid.initial-size=4
spring.datasource.druid.min-idle=4
spring.datasource.druid.min-evictable-idle-time-millis=1800000
spring.datasource.druid.max-wait=10000
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.validation-query=select 1
spring.datasource.druid.time-between-eviction-runs-millis=60000
spring.datasource.druid.keep-alive=true
spring.datasource.druid.keep-alive-between-time-millis=300000

变更成类似
spring.datasource.dynamic.datasource.aaa.druid.validation-query=select 1


多数据源使用：使用 @DS 切换数据源。
@DS 可以注解在方法上或类上，同时存在就近原则 方法上注解 优先于 类上注解。
没有@DS	默认数据源
@DS("databaseName")	databaseName可以为组名也可以为具体某个库的名称