mybatis-plus实现代码层面的读写分离

梦想的征途

已于 2022-10-01 13:07:52 修改

阅读量1.5k

点赞数

分类专栏： java 文章标签： mybatis java spring boot

于 2020-12-03 11:27:56 首次发布

本文链接：https://blog.youkuaiyun.com/u012017645/article/details/110523112

版权

java 专栏收录该内容

27 篇文章

订阅专栏

博客介绍了在Spring Boot中集成MyBatis-Plus的多数据源配置。首先添加相关依赖，接着设置数据源，主库master负责增删改，从库slave_1、slave_2负责查询。然后编写配置类，最后进行测试，不同接口操作不同数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、添加mybatis-plus相关依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.3.0</version>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.3.0</version>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.0.0</version>
</dependency>

二、设置数据源配置

spring:
  application:
    name: rtt
  datasource:
    dynamic:
      primary: master
      datasource:
        master: 
          url: jdbc:mysql://192.168.0.1:3306/datasync?&useUnicode=true&characterEncoding=utf8&serverTimezone=CTT
          username: mysql
          password: mysql
          driver-class-name: com.mysql.cj.jdbc.Driver
        slave_1:
          url: jdbc:mysql://192.168.0.2:3306/datasync?&useUnicode=true&characterEncoding=utf8&serverTimezone=CTT
          username: mysql
          password: mysql
          driver-class-name: com.mysql.cj.jdbc.Driver
        slave_2:
          url: jdbc:mysql://192.168.0.3:3306/datasync?&useUnicode=true&characterEncoding=utf8&serverTimezone=CTT
          username: mysql
          password: mysql
          driver-class-name: com.mysql.cj.jdbc.Driver

master为主库，负责增删改；slave_1、slave_2为从库，负责查询。

三、编写mybatis-plus配置类

@Configuration
@EnableTransactionManagement
@MapperScan("com.zq.datasync.mapper")
public class MybatisPlusConfig {
    /**
     * 分页配置
     * @return
     */
    @Bean
    public PaginationInterceptor paginationInterceptor(){
        return new PaginationInterceptor();
    }

    /**
     * 乐观锁配置
     * @return
     */
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }

    /**
     * 读写分离配置
     * @return
     */
    @Bean
    public MasterSlaveAutoRoutingPlugin masterSlaveAutoRoutingPlugin() {
        return new MasterSlaveAutoRoutingPlugin();
    }
}

四、测试

@RestController
@RequestMapping("/person")
public class PersonController {
    @Autowired
    private IPersonService personService;

    @PostMapping("save")
    public ResponseResult add(@RequestBody Person person) {
        personService.save(person);
        return ResponseResultUtil.success();
    }

    @PutMapping("update")
    public ResponseResult update(@RequestBody Person person) {
        Person o = personService.getById(person.getId());
        if (o != null) {
            BeanCopyUtil.copyPropertiesIgnoreNull(person, o);
            personService.updateById(o);
        }
        return ResponseResultUtil.success();
    }

    @DeleteMapping("delete/{id}")
    public ResponseResult delete(@PathVariable Long id) {
        personService.removeById(id);
        return ResponseResultUtil.success();
    }

    @GetMapping("list")
    @DS("slave")
    public ResponseResult list() {
        return ResponseResultUtil.success(personService.list());
    }
}

当调用/person/save、/person/update、/person/delete/1接口时，操作的是master数据库；当调用/person/list接口时，轮训操作slave_1、slave_2数据库。