父母帮DB故障切换

mysql-proxy(主)

ip:59.151.119.187
vip1(w):192.168.0.191
vip2(r):192.168.0.192

haproxy:
监控URL：http://59.151.119.187:8888/dbs 用户名密码：admin/lt1qazxsw2
配置文件：/etc/haproxy.cfg(切换/etc/haproxy_s.cfg)
日志：/var/log/haproxy.log
启动：haproxy -f /etc/haproxy.cfg(切换haproxy -f /etc/haproxy_s.cfg)
停止：killall haproxy

keepalived:
配置文件：/etc/keepalived/keepalived.conf
启动：service keepalived start
停止：service keepalived stop

mysql-proxy(备)

ip:59.151.119.185
vip1(w):192.168.0.191
vip2(r):192.168.0.192

haproxy:
监控URL：http://59.151.119.185:8888/dbs 用户名密码：admin/lt1qazxsw2
配置文件：/etc/haproxy.cfg(切换/etc/haproxy_s.cfg)
日志：/var/log/haproxy.log
启动：haproxy -f /etc/haproxy.cfg(切换haproxy -f /etc/haproxy_s.cfg)
停止：killall haproxy

keepalived:
配置文件：/etc/keepalived/keepalived.conf
启动：service keepalived start
停止：service keepalived stop

故障切换

mysql(主1-写 故障)
119.187：
killall haproxy
haproxy -f /etc/haproxy_s.cfg

mysql-proxy(主 故障)
119.187：
自动切换到备用(59.151.119.185)

命令行快速连接

/usr/local/mysql/bin/mysql -h192.168.0.191 -P23306 -ufmb -pXXXXX fmb_new
/usr/local/mysql/bin/mysql -h192.168.0.192 -P23307 -ufmb_r -pXXXXX fmb_new

备注

目前线上各程序运行环境参数都是通过db.fmb本地host进行配置的，因此可以直接修改服务器上针对db.fmb的host设置即可
按照之前的用户登陆账号信息，可以直接进行连接处理
通过3306默认端口连接的话，只是用到了keepalived的虚拟IP功能进行的直接连接
如果通过23306的端口进行连接的话，则会用到了haproxy的代理连接功能，方便后续的扩展

此行以下废弃，但各种软件配置文件仍保留于服务器

===mysql(主1-写)===

ip1:59.151.119.189,ip2:192.168.0.189,vip:192.168.0.191

haproxy：
监控URL：http://59.151.119.189:8888/dbs 用户名密码：admin/lt1qazxsw2
配置文件：/etc/haproxy.cfg
启动：haproxy -f /etc/haproxy.cfg
停止：killall haproxy

keepalived:
配置文件：/etc/keepalived/keepalived.conf
启动：service keepalived start
停止：service keepalived stop

===mysql(主2-读)===

ip1:59.151.119.190,ip2:192.168.0.190,vip:192.168.0.192，(切换vip:192.168.0.191)

haproxy：
监控URL：http://59.151.119.190:8888/dbs 用户名密码：admin/lt1qazxsw2
配置文件：/etc/haproxy.cfg
启动：haproxy -f /etc/haproxy.cfg
停止：killall haproxy

keepalived:
配置文件：/etc/keepalived/keepalived.conf(切换/etc/keepalived/keepalived191.conf)
启动：service keepalived start(切换service keepalived191 start)
停止：service keepalived stop(切换service keepalived191 start)

===mysql(从1-备)===

ip1:59.151.119.179,ip2:192.168.0.179,(切换vip:192.168.0.192)

haproxy：
监控URL：http://59.151.119.179:8888/dbs 用户名密码：admin/lt1qazxsw2
配置文件：/etc/haproxy.cfg
启动：haproxy -f /etc/haproxy.cfg
停止：killall haproxy

keepalived:
配置文件：/etc/keepalived/keepalived.conf
启动：service keepalived start
停止：service keepalived stop


===切换步骤(主1-写 故障)===

停主keepalived:
119.189:service keepalived stop
119.190:service keepalived stop

启备keepalived:
119.190:service keepalived191 start
119.179:service keepalived start

注意：必需先停后启，启动备用时保证原vip已经释放，ip a 命令查看vip启用情况。