推荐链接:
总结——》【Java】
总结——》【Mysql】
总结——》【Spring】
总结——》【SpringBoot】
SpringBoot——》动态切换数据源
一、数据库
/*
Schema:dynamic_master
Info:主库
Date:2022/09/07 13:49:38
*/
-- 1、创建数据库
CREATE DATABASE `dynamic_master` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
-- 2、创建表
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- 3、插入数据
INSERT INTO `user` VALUES (1, '赵');
INSERT INTO `user` VALUES (2, '钱');
INSERT INTO `user` VALUES (3, '孙');
INSERT INTO `user` VALUES (4, '李');
/*
Schema:dynamic_slave
Info:从库
Date:2022/09/07 13:49:38
*/
-- 1、创建数据库
CREATE DATABASE `dynamic_slave` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
-- 2、创建表
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- 3、插入数据
INSERT INTO `user` VALUES (11, '周');
INSERT INTO `user` VALUES (22, '吴');
INSERT INTO `user` VALUES (33, '郑');
INSERT INTO `user` VALUES (44, '王');
二、项目
【gitee】https://gitee.com/xiaoxianwansui/springboot-dynamic-datasource.git
1、pom.xml:引入核心依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.9</version>
</dependency>
<!--测试框架 - start -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
2、application.yml:配置数据源
3、@DS():动态切换数据源
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {
@Autowired
private UserMapper userMapper;
@Override
@DS("master")
public List<User> listOfMaster() {
return userMapper.selectList(new QueryWrapper<>());
}
@Override
@DS("slave")
public List<User> listOfSlave() {
return userMapper.selectList(new QueryWrapper<>());
}
}
三、启动
1、Console控制台
2、Druid Monitor监控
1)登录
2)数据源
3)SQL监控
四、测试
1、读取主库:/user/listOfMaster
http://127.0.0.1:8888/user/listOfMaster