新建一个centos系统
docker run -it centos一键安装
sh install.sh调试运行
mycat console准备两台服务器
- 127.0.0.1:3001 主
- 127.0.0.1:3002 从
搭建 mysql主从
配置
/usr/local/mycat/conf/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>
<writeHost host="m1" url="127.0.0.1:3301" user="root" password="root">
<readHost host="s1" url="192.168.10.206:3302" user="root" password="root">
</readHost>
</writeHost>
</dataHost>