Mysql如何使用Maxscale中间件

背景：

[root@node4 ~]# mysql -umax -pESBecs00 -h292.168.6.121 -P4008 -e "show tables" chenliang;
+---------------------+
| Tables_in_chenliang |
+---------------------+
| test115 |
| tt |
| tt2 |
+---------------------+
[root@node4 ~]# mysql -umax -pESBecs00 -h292.168.6.121 -P4008 -e "show tables" chenliang;
+---------------------+
| Tables_in_chenliang |
+---------------------+
| test115 |
| tt |
| tt2 |
+---------------------+
[root@node4 ~]# mysql -umax -pESBecs00 -h292.168.6.121 -P4008 -e "show tables" chenliang;
+---------------------+
| Tables_in_chenliang |
+---------------------+
| test115 |
| tt |
| tt2 |
+---------------------+

恢复119 在测试：负载均衡正常了


优酷土豆资深工程师：MySQL高可用之MaxScale与MHAhttp://dbaplus.cn/news-11-558-1.html


MaxScale：实现MySQL读写分离与负载均衡的中间件利器

http://mp.weixin.qq.com/s?__biz=MzI4NTA1MDEwNg==&mid=2650756387&idx=1&sn=c0dce4a24c85307cd4c64c8183bffa36&scene=0#wechat_redirect