Mysql主从架构配置

yml配置
#  main:
#    allow-bean-definition-overriding: true #读写分离BEAN定义覆盖
##主从复制配置
#  shardingsphere:
#    datasource:
#      names:
#        master,slave,******* #(多个)
##主数据
#      master:
#        type: com.alibaba.druid.pool.DruidDataSource
#        driver-class-name: com.mysql.cj.jdbc.Driver
#        url: jdbc:mysql://你的主库URL/ruiji?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
#        username: root
#        password: ****
##从数据(可配置多个)
#      slave:
#        type: com.alibaba.druid.pool.DruidDataSource
#        driver-class-name: com.mysql.cj.jdbc.Driver
#        url: jdbc:mysql://你的从库URL/ruiji?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
#        username: root
#        password: *****
#    masterslave:
#      #读写分离配置
#      load-balance-algorithm-type: round_robin #轮询查询
#      #最终数据源
#      name: dataSource
#      master-data-source-name: master
#      slave-data-source-names: slave
#    props:
#      sql:
#        show: true  #开启sql显示
依赖
 <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>4.0.0-RC1</version>
</dependency>