mycat管理mysql读写分离搭建步骤

搭建环境参考博文
https://www.jianshu.com/p/628ca0f194ec

http://www.mycat.io/document/mycat-definitive-guide.pdf    mycat指南pdf版

mycat的配置参数了解：
https://www.cnblogs.com/756623607-zhang/p/6850933.html?utm_source=itdadao&utm_medium=referral

 

注意事项：准备两台mysql主从之后一定要注意两个数据库中都要创建db_store,db_user库以及对应的表，方可准备mycat的管理配置，之前自以为能通不过去，结果启动报错初始化失败，mycat提示并不是很友好……

个别参考：
https://www.cnblogs.com/happy4java/p/11206030.html

https://blog.csdn.net/bigtree_3721/article/details/78998765

https://blog.csdn.net/qq_33200967/article/details/80948708#%E4%B8%80%E4%B8%BB%E4%B8%80%E4%BB%8E%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB 双主双从

https://www.jianshu.com/p/628ca0f194ec    mysql8.0主从复制和mycat实现分表分库，读写分离

https://www.jianshu.com/p/af1690d8d045   mysql8.0主从复制

https://www.2cto.com/database/201703/616472.html   Mycat快速入门

https://blog.csdn.net/xiaochen1999/article/details/87438656  mcat配置文件与作用