MHA +maxscale 实现读写分离高可用架构实战

MHA 相关原理 http://mp.blog.csdn.net/postedit/79183726

 MHA  http://mp.blog.csdn.net/postedit/79183743 最佳实战

MySQL读写分离原理相关知识体系  http://blog.csdn.net/wjl7813/article/details/79184468

本文以第2种方式实现（基于中间代理层实现）

创建监控复制状态账号
grant replication slave, replication client on *.* to scalemon@'192.168.137.%' identified by 'monitor18';


创建业务账号
 grant all privileges on mycat.* to user_maxscale@'192.168.137.%' identified by 'H2kXvhaJxRSl';
 grant select on *.* to user_maxscale@'192.168.137.%';








mkdir -p /data1/maxscale4007/log/
mkdir -p /data1/maxscale4007/data/
mkdir -p /data1/maxscale4007/cache/
mkdir -p /data1/maxscale4007/pid/
chown -R maxscale:maxscale /data1/maxscale4007
2.1.6.maxsacle创建秘钥


[root@mha-manager opt]# maxpasswd /data1/maxscale4007/data/.secrets monitor18
Failed to encode the password
[root@mha-manager opt]# maxkeys /data1/maxscale4007/data/
[root@mha-manager opt]# maxpasswd /data1/maxscale4007/data/.secrets monitor18
E2D5388FEC655E04F977AFFE91F08240
[root@mha-manager opt]# maxpasswd /data1/maxscale4007/data/.secrets H2kXvhaJxRSl
DAA9A9DD308D222752B398EBC03474EF


vim /etc/maxscale4007.cnf 
[maxscale]
threads=auto   
maxlog=1       
log_to_shm=0   
log_warning=1  
log_error=1    
log_notice=1   
log_info=0     
log_debug=0    
#log_augmentation=1
LimitNOFILE=65536
logdir=/data1/maxscale4007/log/  
datadir=/data1/maxscale4007/data/  
cachedir=/data1/maxscale4007/cache/  
piddir=/data1/maxscale4007/pid/  
libdir=/usr/lib64/maxscale/  
execdir=/usr/bin/  


[server1]
type=server
address=192.168.13