Shulou(Shulou.com)06/02 Report--

This article focuses on "how to use SpringBoot + Mybatis multi-source configuration to achieve read-write separation", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let the editor take you to learn "how to use SpringBoot + Mybatis multi-data source configuration to achieve read-write separation"!

Application scenario: there are some report statistics and query functions in the project, which do not require high real-time data, so consider the statistics and query of the report to operate slave db to reduce the pressure on master.

According to the test of multiple data on the Internet, it is found that the master data source is always used and cannot be switched to slave. After many debugging and modification, it has passed perfectly. The detailed steps and complete code are as follows:

Implementation: configure multiple data sources, use Spring AOP to intercept annotations to achieve dynamic switching of data sources.

1. Application.yml database configuration:

Druid: type: com.alibaba.druid.pool.DruidDataSource master: url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useUnicode=true driver-class-name: com.mysql.jdbc.Driver username: test password: 123 initial-size: 5 max-active: 10 min-idle: 5 max-wait: 60000 time-between-eviction-runs-millis: 3000 min-evictable-idle-time-millis: 300000 validation- Query: SELECT 'x' FROM DUAL test-while-idle: true test-on-borrow: true test-on-return: false filters: stat Wall Log4j2 slave: url: jdbc:mysql://127.0.0.1:3307/test?characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useUnicode=true driver-class-name: com.mysql.jdbc.Driver username: test password: 123 initial-size: 5 max-active: 10 min-idle: 5 max-wait: 60000 time-between-eviction-runs-millis: 3000 min-evictable-idle-time-millis: 300000 validation-query: SELECT'x' FROM DUAL test-while- Idle: true test-on-borrow: true test-on-return: false filters: stat Wall,log4j2

two。 Multi-source injection through MybatisAutoConfiguration:

@ Configuration@EnableTransactionManagementpublic class DataSourceConfiguration extends MybatisAutoConfiguration {@ Value ("${druid.type}") private Class

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.