数据主从分离

一. 配置模板

1. 配置模板

  1. schemaName: master_slave_db
  3. dataSources:
  4.   ds_master:
  5.     url: jdbc:mysql://localhost:3306/ds_master
  6.     username: root
  7.     password:
  8.     autoCommit: true
  9.     connectionTimeout: 30000
  10.     idleTimeout: 60000
  11.     maxLifetime: 1800000
  12.     maximumPoolSize: 65
  13.   ds_slave0:
  14.     url: jdbc:mysql://localhost:3306/ds_slave0
  15.     username: root
  16.     password:
  17.     autoCommit: true
  18.     connectionTimeout: 30000
  19.     idleTimeout: 60000
  20.     maxLifetime: 1800000
  21.     maximumPoolSize: 65
  22.   ds_slave1:
  23.     url: jdbc:mysql://localhost:3306/ds_slave1
  24.     username: root
  25.     password:
  26.     autoCommit: true
  27.     connectionTimeout: 30000
  28.     idleTimeout: 60000
  29.     maxLifetime: 1800000
  30.     maximumPoolSize: 65
  32. masterSlaveRule:
  33.   name: ds_ms
  34.   masterDataSourceName: ds_master
  35.   slaveDataSourceNames:
  36.     - ds_slave0
  37.     - ds_slave1

2. 配套 SQL