分布式开发(4)-mysql集群2-ShardingSphere-分库分表&读写分离配置

1. 下载
   下载链接https://shardingsphere.apache.org/document/legacy/4.x/document/cn/downloads/
   
   解压缩，将mysql驱动放入lib目录中
   驱动链接：https://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.47/mysql-connector-java-5.1.47.jar

2. 配置server认证信息：conf/server.yaml

authentication:
  users:
    root:
      password: root
    sharding:
      password: sharding 
      authorizedSchemas: sharding_db

props:
  executor.size: 16  # Infinite by default.线程数
  sql.show: false #是否展示sql

配置config-sharding.yaml，分库分表

配置config-master_slave.yaml，读写分离