基于mysql主从同步:https://blog.csdn.net/qq_35119422/article/details/79816705
首先writeHost和readHost需实现主从同步
mycat读写分离核心配置:
在schema.xml中配置:
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>show slave status</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM1" url="47.100.153.11:3306" user="root"
password="123456">
<!-- can have multi read hosts -->
<readHost host="hostS2" url="localhost:3306" user="root" password="123456" />
</writeHost>
</dataHost>
至此即可开始测试。。。