- 必须实现数据库读写分离,参考网址为:https://blog.csdn.net/FengRenYuanDeFZ/article/details/89420201
- 引入依赖
-
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.3.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.mysql</groupId> <artifactId>masterslave</artifactId> <version>0.0.1-SNAPSHOT</version> <name>masterslave</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <!-- mybatis-plus begin --> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatisplus-spring-boot-starter</artifactId> <version>1.0.5</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus</artifactId> <version>2.1.8</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <!-- mybatis-plus end --> <!--mysql--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.34</version> <scope>runtime</scope> </dependency> <!-- 模板引擎 --> <dependency> <groupId>org.apache.velocity</groupId> <artifactId>velocity-engine-core</artifactId> <version>2.0</version> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.1</version> </dependency> <!--主从配置依赖--> <dependency> <groupId>com.baomidou</groupId> <artifactId>dynamic-datasource-spring-boot-starter</artifactId> <version>2.4.2</version> </dependency> <!--主从end--> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
3.数据库配置,我用的是yml配置文件,此处需注意如果本地项目已经用了默认的从datasource下寻找url,需要在启动类上调用@SpringBootApplication(exclude = {DruidDataSourceAutoConfigure.class}) 引入的包为import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure; 不然启动项目时会一直报找不到url的错误,还有需要注意的是yml中的数据库的默认配置主从库都要单独跟随,不然也会报错
-
server: port: 8555 spring: datasource: dynamic: primary: master datasource: master: username: root password: root driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168.0.252:3306/istest?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC druid: #以下均为默认值 initial-size: 3 max-active: 8 min-idle: 2 max-wait: -1 min-evictable-idle-time-millis: 30000 max-evictable-idle-time-millis: 30000 time-between-eviction-runs-millis: 0 validation-query: select 1 validation-query-timeout: -1 test-on-borrow: false test-on-return: false test-while-idle: true pool-prepared-statements: true max-open-prepared-statements: 100 filters: stat,wall share-prepared-statements: true slave: username: root password: root driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168.0.65:3306/istest?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC druid: #以下均为默认值 initial-size: 3 max-active: 8 min-idle: 2 max-wait: -1 min-evictable-idle-time-millis: 30000 max-evictable-idle-time-millis: 30000 time-between-eviction-runs-millis: 0 validation-query: select 1 validation-query-timeout: -1 test-on-borrow: false test-on-return: false test-while-idle: true pool-prepared-statements: true max-open-prepared-statements: 100 filters: stat,wall share-prepared-statements: true logging: config: classpath:logback-spring.xml level: root: debug mybatis-plus: mapper-locations: classpath:/mapper/*.xml typeAliasesPackage: com.mysql.masterslave.model.entity
配置上以上操作后基本配置就算完成了,剩下的就是自己的方法逻辑,此过程中关键引入dynamic-datasource-spring-boot-starter 依赖,在service使用@RS()注解,不传参或不调用@RS()注解默认使用主库,@DS("slave_1")使用slave_1库。
注意:@DS可以注解在方法上、类上、接口、枚举,同时存在方法注解优先于类上注解。
涉及多数据源操作时,
1.不能使用事务,否则数据源不会切换,使用的还是是第一次加载的数据源
删除掉操作多数据源的方法或者类、接口 上的 注解 @Transactional(rollbackFor = Exception.class) 即可。
2.第一次加载的数据源之后,第二次(第三次...)操作其它数据源,如果数据源不存在,使用的还是第一次加载的数据源
3.数据源名称最好不要包含下滑线,下滑线的数据源切换不了
4.当前文件下a方法调用本文件b方法,如果吧DS作用在b方法上,数据源切换不了(遇到了这样的问题,service层的a方法调用了同文件中的b方法,切换失败,作用在mapper层上后就可以切换成功,具体为什么不知道,有知道的大佬欢迎留言)