【分库分表】ShardingSphere-Proxy：实现读写分离

--config-master_slave.yaml：
schemaName: master_slave_db

dataSources:
  master_ds:
    url: jdbc:mysql://127.0.0.1:3306/demo_ds_master?serverTimezone=UTC&useSSL=false
    username: root
    password: root
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
  slave_ds_0:
    url: jdbc:mysql://127.0.0.1:3306/demo_ds_slave_0?serverTimezone=UTC&useSSL=false
    username: root
    password: root
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50

masterSlaveRule:
  name: ms_ds
  masterDataSourceName: master_ds
  slaveDataSourceNames:
    - slave_ds_0

cd E:\apache-shardingsphere-incubating-4.0.1-sharding-proxy-bin\apache-shardingsphere-incubating-4.0.1-sharding-proxy-bin\bin
start.bat 3308  

mysql -P3308 -uroot -p      


use master_slave_db;

#主DB内手动创建表
CREATE TABLE demo_ds_master.t_order(   
  order_id bigint(20) primary key,
  user_id bigint(20) not null,
  status varchar(10) not null
);    
#从DB内手动创建表
CREATE TABLE demo_ds_slave_0.t_order(
  order_id bigint(20) primary key,
  user_id bigint(20) not null,
  status varchar(10) not null
);    

select * from t_order; 


#不指定向哪个DB内
insert into t_order values(11,1,'iniy');