ShardingSphere(一)读写分离

<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
    <version>4.0.0-RC1</version>
  </dependency>
  <dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-namespace</artifactId>
    <version>4.0.0-RC1</version>
  </dependency>

spring:
  shardingsphere:
    enabled: true
    datasource:
      names: master,slave
      master:
        username: root
        password: 111111
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/sharding?useUnicoe=true&characterEncoding=utf-8&serverTimezone=GMT
        type: com.alibaba.druid.pool.DruidDataSource
      slave:
        username: root
        password: 111111
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3307/sharding?useUnicoe=true&characterEncoding=utf-8&serverTimezone=GMT
        type: com.alibaba.druid.pool.DruidDataSource
    masterslave:
      load-balance-algorithm-type: round_robin
      name: master_slave
      master-data-source-name: master
      slave-data-source-names: slave
#    encrypt:
#      encryptors:
#        aes_encryptor:
#          type: aes
#          qualifiedColumns: user.PASS_WORD
#          props:
#            aes.key.value: qwwerwefrwe
    props:
      #query.with.cipher.column: true
      sql:
        show: true

shardingSphere默认master数据库执行delete,update,insert,slave数据库执行select，见读写分离架构图，
读写分离适合数据量不是很多的情况，通过读写分离，扩展从库，来缓解查询的压力。