springboot使用sharding-jdbc进行读写分离

	org.apache.shardingsphere
	sharding-jdbc-spring-boot-starter
	4.0.0-RC1



	com.alibaba
	druid-spring-boot-starter
	1.2.9



	org.mybatis.spring.boot
	mybatis-spring-boot-starter
	2.2.1

• 1.1.1.1为个人数据IP自行替换
• ly123456为个人数据库密码自行替换

spring:
 #读写分类配置
  shardingsphere:
    # 配置数据源
    datasource:
      names: master,slave
      # master-ds0数据库连接信息
      master:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://1.1.1.1:3306/km_manager_data?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
        username: root
        password: ly123456
        maxPoolSize: 100
        minPoolSize: 5
      # slave-ds1数据库连接信息
      slave:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://1.1.1.1:3306/km_manager_data?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
        username: root
        password: ly123456
        maxPoolSize: 100
        minPoolSize: 5
      ds:
        maxPoolSize: 100
    # 配置默认数据源ds0 默认数据源,主要用于写
    sharding:
      default-data-source-name: dataSource
    # 读写分离 单个读写分离
    masterslave:
      # 配置主从名称
      name: dataSource
      # 配置主库master,负责数据的写入
      master-data-source-name: master
      # 配置从库slave节点
      slave-data-source-names: slave
      # 配置slave节点的负载均衡均衡策略,采用轮询机制
      load-balance-algorithm-type: round_robin
    # 显示sql
    props:
      sql:
        show: false
mybatis:
  mapper-locations: classpath*:mapper/*.xml

• 正常使用mybatis进行CRUD即可