mysql 读写分离
mysql 读写分离
1. 引入包
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.32</version>
</dependency>
2. yml配置
spring:
datasource:
dynamic:
datasource:
master:
poolName: write-pool
url: jdbc:mysql://192.168.10.10:6001/db?useUnicode=true&characterEncoding=UTF-8&noAccessToProcedureBodies=true&autoReconnect=true&failOverReadOnly=false&rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
username: user_1
password: password1
driver-class-name: com.mysql.cj.jdbc.Driver
hikari:
max-pool-size: 100
min-idle: 50
slave:
poolName: read-pool
url: jdbc:mysql://192.168.10.10:6002/db?useUnicode=true&characterEncoding=UTF-8&noAccessToProcedureBodies=true&autoReconnect=true&failOverReadOnly=false&rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
username: user_1
password: password2
driver-class-name: com.mysql.cj.jdbc.Driver
hikari:
max-pool-size: 100
min-idle: 50
3. 配置bean:MasterSlaveAutoRoutingPlugin ,此插件自动完成dataSource配置读取与创建,自动封装增删改查拦截器
@Configuration
@MapperScan(basePackages = {"com.iv.**.mapper"})
public class DynamicDataSourceConfiguration {
/**
* 读写分离插件
*
* @return MasterSlaveAutoRoutingPlugin
*/
@Bean
public MasterSlaveAutoRoutingPlugin masterSlaveAutoRoutingPlugin() {
return new MasterSlaveAutoRoutingPlugin();
}
}
4.如果无法启动,则exclude,DataSourceAutoConfiguration.class
@SpringBootApplication(exclude={DataSourceAutoConfiguration.class})