本文来自我的github pages博客http://galengao.github.io/ 即www.gaohuirong.cn
摘要:
本篇是自己搭建的一篇mysql MHA文章
前面的安装步骤基本不变&＃xff0c;后面的比如keepalived的配置文件有几种方法
其实想完成keepalived&＃43;lvs&＃43;atlas(mycat)&＃43;mha&＃43;mysql主从复制 这样的架构&＃xff0c;只是MYCAT单独文章了
每个节点都关闭防火墙&＃xff0c;SELINUX。
1、安装epel yum源
wget http://mirrors.hustunique.com/epel/6/x86_64/epel-release-6-8.noarch.rpm
wget http://mirrors.hustunique.com/epel/RPM-GPG-KEY-EPEL-6
rpm --import RPM-GPG-KEY-EPEL-6rpm-ivh epel-release-6-8.noarch.rpm
2、所有节点安装MHA node所需的perl模块(DBD:mysql)
yum -y install perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes perl-devel
3、建立主从复制
在node1 master上(node2上也要执行)
grant replication slave on *.* to &＃39;backup&＃39;&＃64;&＃39;192.168.10.%&＃39;identified by&＃39;backup&＃39;;
grant all privileges on*.* to &＃39;root&＃39;&＃64;&＃39;192.168.10.%&＃39;identified by&＃39;123456&＃39;;
show master status;
在node2 node3 slave上
change master to master_host&＃61;&＃39;192.168.10.120&＃39;, master_user&＃61;&＃39;backup&＃39;, master_password&＃61;&＃39;backup&＃39;,master_port&＃61;3306, master_log_file&＃61;&＃39;mysql-bin.000001&＃39;,master_log_pos&＃61;120,master_connect_retry&＃61;1;
start slave;
show slave status \G;
其中Slave_IO_Running 与 Slave_SQL_Running 的值都必须为YES&＃xff0c;才表明状态正常。
4、ssh-keygen实现三台机器之间相互免密钥登录 在每个节点上都执行下面语句
ssh-keygen -t rsassh-copy-id -i /root/.ssh/id_rsa.pub root&＃64;192.168.10.120
ssh-copy-id -i /root/.ssh/id_rsa.pub root&＃64;192.168.10.121
ssh-copy-id -i /root/.ssh/id_rsa.pub root&＃64;192.168.10.122
5、三节点安装mha4mysql-node-0.56,node3上安装mha4mysql-manager-0.56
在node1 node2 node3安装mha4mysql-node
wget https://googledrive.com/host/0B1lu97m8-haWeHdGWXp0YVVUSlk/mha4mysql-node-0.56.tar.gz
tar xf mha4mysql-node-0.56.tar.gz
cd mha4mysql-node-0.56
perlMakefile.PLmake && make install
注&＃xff1a;若运行 perl Makefile.PL时报Can’t locate CPAN.pm in &＃64;INC这个错时&＃xff0c;表示没有安装CPAN模块&＃xff1a;
wget http://www.cpan.org/authors/id/A/AN/ANDK/CPAN-2.10.tar.gz
tar -zxvf CPAN-2.10.tar.gz
cd CPAN-2.10
perl Makefile.PL
make
make install
在node3上安装mha4mysql-manager
# 首先安装依赖包yum install perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Config-IniFiles perl-Time-HiReswget https://googledrive.com/host/0B1lu97m8-haWeHdGWXp0YVVUSlk/mha4mysql-manager-0.56.tar.gz
tar xf mha4mysql-manager-0.56.tar.gz
cd mha4mysql-manager-0.56
perlMakefile.PLmake && make install
在node3上管理MHA配置文件
mkdir -p /etc/mha/{app1,scripts}cp -r mha4mysql-manager-0.56/samples/conf/*/etc/mha/
cp -r mha4mysql-manager-0.56/samples/scripts/* /etc/mha/scripts/
mv /etc/mha/app1.cnf /etc/mha/app1/
mv /etc/mha/masterha_default.cnf /etc/masterha_default.cnf
6、在manager上设置全局配置&＃xff1a;
vim /etc/masterha_default.cnf
[server default]
user&＃61;root
password&＃61;123456ssh_user&＃61;root
repl_user&＃61;backup
repl_password&＃61;backup
ping_interval&＃61;1#shutdown_script&＃61;""secondary_check_script&＃61;masterha_secondary_check-s node1 -s node2 -s node3 --user&＃61;root --master_host&＃61;node1 --master_ip&＃61;192.168.10.120 --master_port&＃61;3306#master_ip_failover_script&＃61;"/etc/mha/scripts/master_ip_failover"#master_ip_online_change_script&＃61;"/etc/mha/scripts/master_ip_online_change"# shutdown_script&＃61; /script/masterha/power_manager
#report_script&＃61;""
# 创建日志目录
mkdir -p /var/log/mha/app1
vim /etc/mha/app1/app1.cnf
# master_binlog_dir 要是mysql的binlog目录&＃xff0c;否则验证会报错
[server default]
manager_workdir&＃61;/var/log/mha/app1
manager_log&＃61;/var/log/mha/app1/manager.log
[server1]hostname&＃61;node1
master_binlog_dir&＃61;"/usr/local/mysql/logs"candidate_master&＃61;1[server2]hostname&＃61;node2
master_binlog_dir&＃61;"/usr/local/mysql/logs"candidate_master&＃61;1[server3]hostname&＃61;node3
master_binlog_dir&＃61;"/usr/local/mysql/logs"no_master&＃61;1
注释&＃xff1a;
candidate_master&＃61;1 表示该主机优先可被选为new master&＃xff0c;当多个[serverX]等设置此参数时&＃xff0c;优先级由[serverX]配置的顺序决定;
secondary_check_script mha强烈建议有两个或多个网络线路检查MySQL主服务器的可用性。默认情况下,只有单一的路线 MHA Manager检查:从Manager to Master,但这是不可取的。MHA实际上可以有两个或两个以上的检查路线通过调用外部脚本定义二次检查脚本参数;
master_ip_failover_script 在MySQL从服务器提升为新的主服务器时&＃xff0c;调用此脚本&＃xff0c;因此可以将vip信息写到此配置文件;
master_ip_online_change_script 使用masterha_master_switch命令手动切换MySQL主服务器时后会调用此脚本&＃xff0c;参数和master_ip_failover_script 类似&＃xff0c;脚本可以互用 shutdown_script 此脚本(默认samples内的脚本)利用服务器的远程控制IDRAC等&＃xff0c;使用ipmitool强制去关机&＃xff0c;以避免fence设备重启主服务器&＃xff0c;造成脑列现象;
report_script 当新主服务器切换完成以后通过此脚本发送邮件报告&＃xff0c;可参考使用http://caspian.dotconf.net/menu/Software/SendEmail/sendEmail-v1.56.tar.gz
以上涉及到的脚本可以从mha4mysql-manager-0.56/samples/scripts/*拷贝进行修改使用
其他manager详细配置参数https://code.google.com/p/mysql-master-ha/wiki/Parameters
7、masterha_check_ssh验证ssh信任登录是否成功,masterha_check_repl验证mysql复制是否成功
验证ssh信任&＃xff1a;
masterha_check_ssh --conf&＃61;/etc/mha/app1/app1.cnf
验证主从复制&＃xff1a;
masterha_check_repl --conf&＃61;/etc/mha/app1/app1.cnf
8、启动MHA manager&＃xff0c;并监控日志文件
在node1上killall mysqld的同时在node3上启动manager服务
masterha_manager --conf&＃61;/etc/mha/app1/app1.cnf
之后观察node3上/var/log/mha/app1/manager.log日志会发现node1 dead状态&＃xff0c;主自动切换到node2上&＃xff0c;而node3上的主从配置指向了node2&＃xff0c; 并且发生一次切换后会生成/var/log/mha/app1/app1.failover.complete文件&＃xff1b;
手动恢复node1操作&＃xff1a;
rm -rf /var/log/mha/app1/app1.failover.complete
在node1上启动mysql:
service mysql start
登录进去show master status;
重新配置node2 node3 主从指向node1(change master to)
stop slave;
change master to master_host&＃61;&＃39;192.168.10.120&＃39;, master_user&＃61;&＃39;backup&＃39;, master_password&＃61;&＃39;backup&＃39;,master_port&＃61;3306, master_log_file&＃61;&＃39;mysql-bin.000002&＃39;,master_log_pos&＃61;120,master_connect_retry&＃61;1;
start slave;
show slave status\G;
MHA Manager后台执行&＃xff1a;
(1)查看Manager的状态
masterha_check_status --conf&＃61;/etc/mha/app1/app1.cnf
(2)后台启动
nohup masterha_manager --conf&＃61;/etc/mha/app1/app1.cnf --remove_dead_master_conf --ignore_last_failover /var/log/masterha/app1/manager.log 2>&1 &
启动参数介绍&＃xff1a;
- –remove_dead_master_conf 该参数代表当发生主从切换后&＃xff0c;老的主库的ip将会从配置文件中移除。
- –manger_log 日志存放位置
- –ignore_last_failover 在缺省情况下&＃xff0c;如果MHA检测到连续发生宕机&＃xff0c;且两次宕机间隔不足8小时的话&＃xff0c;则不会进行 Failover&＃xff0c;之所以这样限制是为了避免ping-pong效应。该参数代表忽略上次MHA触发切换产生的文件&＃xff0c;默认情况下&＃xff0c;MHA发生切换后会在日志目录&＃xff0c;也就是上面我设置的/data产生app1.failover.complete文件&＃xff0c;下次再次切换的时候如果发现该目录下存在该文件将不允许触发切换&＃xff0c;除非在第一次切换后收到删除该文件&＃xff0c;为了方便&＃xff0c;这里设置为–ignore_last_failover
关闭MHA Manage监控
masterha_stop --conf&＃61;/etc/mha/app1/app1.cnf
守护进程方式参考&＃xff1a;
9、配置VIP
vip配置可以采用两种方式&＃xff0c;一种通过keepalived的方式管理虚拟ip的漂移&＃xff1b;另外一种通过脚本方式启动虚拟ip的方式(即不需要keepalived或者heartbeat类似的软件)。这里采用的是keepalived的方式管理vip的漂移。
keepalived方式管理虚拟ip&＃xff0c;keepalived配置方法如下&＃xff1a;
安装keepalived
# 下载软件进行并进行安装(两台master&＃xff0c;准确的说一台是master&＃xff0c;另外一台是备选master&＃xff0c;在没有切换以前是slave)&＃xff1a;
# 首先安装内核包yum install kernel-headers kernel-devel
# 然后安装依赖包yum install popt-static kernel-devel make gcc openssl-devel lftp libnl* popt*# 最后软连接ln -s /usr/src/kernels/2.6.32-279.el6.i686//usr/src/linux/
# 安装keepalivedwget http://www.keepalived.org/software/keepalived-1.2.4.tar.gz
tar zxvf keepalived-1.2.4.tar.gz
cd keepalived-1.2.4./configure --prefix&＃61;/usr/local/keepalivedmake
make install# 将keepalived做成启动服务&＃xff0c;方便管理cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/
cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
mkdir /etc/keepalived/
cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/
cp /usr/local/keepalived/sbin/keepalived /usr/sbin/# 启动keepalived服务
service keepalived start
配置keepalived配置文件
在keepalived中2种模式&＃xff0c;分别是master->backup模式和backup->backup模式。这两种模式有很大区别。在master->backup模式下&＃xff0c;一旦主库宕机&＃xff0c;虚拟ip会自动漂移到从库&＃xff0c;当主库修复后&＃xff0c;keepalived启动后&＃xff0c;还会把虚拟ip抢占过来&＃xff0c;即使设置了非抢占模式(nopreempt)抢占ip的动作也会发生。在backup->backup模式下&＃xff0c;当主库宕机后虚拟ip会自动漂移到从库上&＃xff0c;当原主库恢复和keepalived服务启动后&＃xff0c;并不会抢占新主的虚拟ip&＃xff0c;即使是优先级高于从库的优先级别&＃xff0c;也不会发生抢占。为了减少ip漂移次数&＃xff0c;通常是把修复好的主库当做新的备库。下面依次是两种配置方式&＃xff1a;
a、master->backup模式
# 配置keepalived的配置文件&＃xff0c;在master上配置
[root&＃64;192.168.3.110~]# cat /etc/keepalived/keepalived.conf! ConfigurationFile forkeepalived
global_defs {
notification_email {343838596&＃64;qq.com
}
notification_email_from343838596&＃64;qq.com
smtp_server127.0.0.1smtp_connect_timeout30router_id LVS_DEVEL
}
#这里加一个检查mysql服务是否停掉的脚本&＃xff0c;如果停掉就关闭keepalived服务器&＃xff0c;让其自动跳到另外一台虚拟ip
varrp_script check_mysql{
script"/etc/keepalived/check_mysql.sh"}
vrrp_instance VI_1 {
state BACKUP
interface eth0
virtual_router_id51priority80advert_int1nopreempt
authentication {
auth_type PASS
auth_pass1111}
virtual_ipaddress {192.168.10.219}
}
其中router_id MySQL HA表示设定keepalived组的名称&＃xff0c;将192.168.3.250这个虚拟ip绑定到该主机的eth0网卡上&＃xff0c;并且设置了状态为backup模式&＃xff0c;将keepalived的模式设置为非抢占模式(nopreempt)&＃xff0c;priority 80表示设置的优先级为80。下面的配置略有不同&＃xff0c;但是都是一个意思。
# 在候选master上配置keepalived的配置文件cat /etc/keepalived/keepalived.conf! ConfigurationFile forkeepalived
global_defs {
notification_email {343838596&＃64;qq.com
}
notification_email_from343838596&＃64;qq.com
smtp_server127.0.0.1smtp_connect_timeout30router_id LVS_DEVEL
}
#这里加一个检查mysql服务是否停掉的脚本&＃xff0c;如果停掉就关闭keepalived服务器&＃xff0c;让其自动跳到另外一台虚拟ip
varrp_script check_mysql{
script"/etc/keepalived/check_mysql.sh"}
vrrp_instance VI_1 {
state BACKUP
interface eth0
virtual_router_id51priority60advert_int1nopreempt
authentication {
auth_type PASS
auth_pass1111}
virtual_ipaddress {192.168.10.219}
}
b、backup->backup模式
# 配置keepalived的配置文件&＃xff0c;在master上配置(node1)
vim/etc/keepalived/keepalived.conf! ConfigurationFile forkeepalived
global_defs{
router_id MHA
notification_email{
root&＃64;localhost #接收邮件&＃xff0c;可以有多个&＃xff0c;一行一个
}
#当主、备份设备发生改变时&＃xff0c;通过邮件通知
notification_email_from m&＃64;localhost
#发送邮箱服务器
smtp_server127.0.0.1#发送邮箱超时时间
smtp_connect_timeout30}
varrp_script check_mysql{
script"/etc/keepalived/check_mysql.sh"}
vrrp_sync_group VG1{
group{
VI_1
}
notify_master"/etc/keepalived/master.sh"}
vrrp_instance VI_1{
state master
interface eth0
virtual_router_id110priority100advert_int1nopreempt #不抢占资源&＃xff0c;意思就是它活了之后也不会再把主抢回来
authentication{
# 认证方式&＃xff0c;可以是PASS或AH两种认证方式
auth_type PASS
# 认证密码
auth_pass111111}
track_script{
check_mysql
}
virtual_ipaddress{192.168.10.219}
}
# 在slave上配置(node2)
vim/etc/keepalived/keepalived.conf! ConfigurationFile forkeepalived
global_defs{
router_id MHA
notification_email{
root&＃64;localhost #接收邮件&＃xff0c;可以有多个&＃xff0c;一行一个
}
#当主、备份设备发生改变时&＃xff0c;通过邮件通知
notification_email_from m&＃64;localhost
#发送邮箱服务器
smtp_server127.0.0.1#发送邮箱超时时间
smtp_connect_timeout30}
varrp_script check_mysql{
script"/etc/keepalived/check_mysql.sh"}
vrrp_sync_group VG1{
group{
VI_1
}
notify_master"/etc/keepalived/master.sh"}
vrrp_instance VI_1{
state backup
interface eth0
virtual_router_id110priority99advert_int1authentication{
# 认证方式&＃xff0c;可以是PASS或AH两种认证方式
auth_type PASS
# 认证密码
auth_pass111111}
track_script{
check_mysql
}
virtual_ipaddress{192.168.10.219}
}
check_mysql.sh 脚本
vi /etc/keepalived/check_mysql.sh#!/bin/bash
MYSQL&＃61;/usr/local/mysql/bin/mysql
MYSQL_HOST&＃61;127.0.0.1MYSQL_USER&＃61;root
MYSQL_PASSWORD&＃61;123456CHECK_TIME&＃61;3#mysql is working MYSQL_OK is1 , mysql down MYSQL_OK is 0MYSQL_OK&＃61;1
functioncheck_mysql_helth(){
$MYSQL-h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD -e "show status;" >/dev/null 2>&1
if[ $? &＃61; 0 ];thenMYSQL_OK&＃61;1
elseMYSQL_OK&＃61;0
fireturn $MYSQL_OK
}while [ $CHECK_TIME -ne 0]dolet"CHECK_TIME -&＃61; 1"check_mysql_helthif [ $MYSQL_OK &＃61; 1 ];thenCHECK_TIME&＃61;0exit0fi
if[ $MYSQL_OK -eq 0 ] && [ $CHECK_TIME -eq 0]thenpkill keepalived
exit1
fi
sleep 1
done
master.sh 脚本
vi /etc/keepalived/master.sh#!/bin/bash
VIP&＃61;192.168.10.219GATEWAY&＃61;1.1
/sbin/arping -I eth0 -c 5 -s $VIP $GATEWAY &>/dev/null
chmod &＃43;x /etc/keepalived/check_mysql.sh
chmod &＃43;x /etc/keepalived/master.sh
启动keepalived服务&＃xff0c;在master上启动并查看日志
[root&＃64;]# /etc/init.d/keepalived start
Starting keepalived:[ OK ]
[root&＃64;]#tail -f /var/log/messages
查看绑定情况
[root&＃64;]# ip addr | grepeth02: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000inet192.168.3.110/24 brd 192.168.3.255scope global eth0
inet192.168.3.250/32scope global eth0
[root&＃64;]#
MHA引入keepalived
要想把keepalived服务引入MHA&＃xff0c;我们只需要修改切换是触发的脚本文件master_ip_failover即可&＃xff0c;在该脚本中添加在master发生宕机时对keepalived的处理。其实可以不用master_ip_failover&＃xff0c;因为上面配置文件里嵌套了check_mysql脚本&＃xff0c;若没有&＃xff0c;就要用该脚本。
编辑脚本/usr/local/bin/master_ip_failover&＃xff0c;修改后如下&＃xff0c;这里完整贴出该脚本(192.168.3.123)。
在MHA Manager修改脚本修改后的内容如下&＃xff1a;
#!/usr/bin/env perluse strict;
use warnings FATAL&＃61;>&＃39;all&＃39;;
useGetopt::Long;
my(
$command, $ssh_user, $orig_master_host, $orig_master_ip,
$orig_master_port, $new_master_host, $new_master_ip, $new_master_port
);
my $vip&＃61;&＃39;192.168.3.219&＃39;;
my $ssh_start_vip&＃61;"/etc/init.d/keepalived start";
my $ssh_stop_vip&＃61;"/etc/init.d/keepalived stop";
GetOptions(&＃39;command&＃61;s&＃39;&＃61;>\$command,&＃39;ssh_user&＃61;s&＃39;&＃61;>\$ssh_user,&＃39;orig_master_host&＃61;s&＃39;&＃61;>\$orig_master_host,&＃39;orig_master_ip&＃61;s&＃39;&＃61;>\$orig_master_ip,&＃39;orig_master_port&＃61;i&＃39;&＃61;>\$orig_master_port,&＃39;new_master_host&＃61;s&＃39;&＃61;>\$new_master_host,&＃39;new_master_ip&＃61;s&＃39;&＃61;>\$new_master_ip,&＃39;new_master_port&＃61;i&＃39;&＃61;>\$new_master_port,
);
exit&main();
sub main {
print"\n\nIN SCRIPT TEST&＃61;&＃61;&＃61;&＃61;$ssh_stop_vip&＃61;&＃61;$ssh_start_vip&＃61;&＃61;&＃61;\n\n";if( $command eq "stop"|| $command eq "stopssh"){
my $exit_code&＃61;1;
eval{
print"Disabling the VIP on old master: $orig_master_host \n";&stop_vip();
$exit_code&＃61;0;
};if($&＃64;){
warn"Got Error: $&＃64;\n";
exit $exit_code;
}
exit $exit_code;
}
elsif( $command eq"start"){
my $exit_code&＃61;10;
eval{
print"Enabling the VIP - $vip on the new master - $new_master_host \n";&start_vip();
$exit_code&＃61;0;
};if($&＃64;){
warn $&＃64;;
exit $exit_code;
}
exit $exit_code;
}
elsif( $command eq"status"){
print"Checking the Status of the script.. OK \n";
#&＃96;ssh $ssh_user\&＃64;cluster1 \"$ssh_start_vip \"&＃96;;
exit0;
}else{&usage();
exit1;
}
}
# A simple system call that enable the VIP on the new mastersub start_vip() {
&＃96;ssh $ssh_user\&＃64;$new_master_host \"$ssh_start_vip \"&＃96;;
}
# A simple system call that disable the VIP on the old_master
sub stop_vip(){
return0unless($ssh_user);
&＃96;ssh $ssh_user\&＃64;$orig_master_host \"$ssh_stop_vip \"&＃96;;
}
sub usage {
print"Usage: master_ip_failover --command&＃61;start|stop|stopssh|status --orig_master_host&＃61;host --orig_master_ip&＃61;ip --orig_master_port&＃61;port --new_master_host&＃61;host --new_master_ip&＃61;ip --new_master_port&＃61;port\n";
}
现在已经修改这个脚本了&＃xff0c;我们现在打开在上面提到过的参数&＃xff0c;再检查集群状态&＃xff0c;看是否会报错。
# node3上把注释取消
[root&＃64;192.168.3.123~]# grep &＃39;master_ip_failover_script&＃39; /etc/masterha/app1.cnf
master_ip_failover_script&＃61;/usr/local/bin/master_ip_failover
[root&＃64;192.168.3.123~]#
#在node3上验证主从复制
masterha_check_repl--conf&＃61;/etc/masterha/app1.cnf
10、MHA常用命令
# 查看manager状态
masterha_check_status--conf&＃61;/etc/mha/app1/app1.cnf
# 查看免密钥是否正常
masterha_check_ssh--conf&＃61;/etc/mha/app1/app1.cnf
# 查看主从复制是否正常
masterha_check_repl--conf&＃61;/etc/mha/app1/app1.cnf
# 添加新节点server4到配置文件
masterha_conf_host--command&＃61;add —conf&＃61;/etc/mha/app1/app1.cnf —hostname&＃61;geekwolf —block&＃61;server4 —params&＃61;“no_master&＃61;1;ignore_fail&＃61;1”
# 删除server4节点
masterha_conf_host--command&＃61;delete —conf&＃61;/etc/mha/app1/app1.cnf —block&＃61;server4
# 注&＃xff1a;block:为节点区名&＃xff0c;默认值 为[server_$hostname],如果设置成block&＃61;100&＃xff0c;则为[server100] params:参数&＃xff0c;分号隔开(参考https://code.google.com/p/mysql-master-ha/wiki/Parameters)
# 关闭manager服务
masterha_stop —conf&＃61;/etc/mha/app1/app1.cnf
# 主手动切换(前提不要启动masterha_manager服务)&＃xff0c;在主node1存活情况下进行切换
# 交互模式&＃xff1a;
masterha_master_switch —master_state&＃61;alive —conf&＃61;/etc/mha/app1/app1.cnf —new_master_host&＃61;node2
# 非交互模式&＃xff1a;
masterha_master_switch —master_state&＃61;alive —conf&＃61;/etc/mha/app1/app1.cnf —new_master_host&＃61;node2 —interactive&＃61;0# 在主node1宕掉情况下进行切换
masterha_master_switch —master_state&＃61;dead —conf&＃61;/etc/mha/app1/app1.cnf —dead_master_host&＃61;node1 —dead_master_ip&＃61;192.168.10.216 —dead_master_port&＃61;3306 —new_master_host&＃61;192.168.10.217
11、注意事项
A. 以上两种vip切换方式&＃xff0c;建议采用第一种方法&＃xff1b;
B. 发生主备切换后&＃xff0c;manager服务会自动停掉&＃xff0c;且在/var/log/mha/app1下面生成 app1.failover.complete&＃xff0c;若再次发生切换需要删除app1.failover.complete文件&＃xff1b;
C. 测试过程发现一主两从的架构(两从都设置可以担任主角色candidate_master&＃61;1)&＃xff0c;当旧主故障迁移到备主后&＃xff0c;删除app1.failover.complete&＃xff0c;再次启动manager&＃xff0c;停掉新主后&＃xff0c;发现无法正常切换(解决方式&＃xff1a;删除/etc/mha/app1/app1.cnf里面的旧主node1的信息后&＃xff0c;重新切换正常)&＃xff1b;
D. arp缓存导致切换VIP后&＃xff0c;无法使用问题&＃xff1b;
E. 使用Semi-Sync能够最大程度保证数据安全&＃xff1b;
F. Purge_relay_logs脚本删除中继日志不会阻塞SQL线程&＃xff0c;在每台从节点上设置计划任务定期清除中继日志
0 5 * * * root /usr/bin/purge_relay_logs —user&＃61;root —password&＃61;geekwolf —disable_relay_log_purge >> /var/log/mha/purge_relay_logs.log 2>&1
12、部署过程遇到的问题
问题1&＃xff1a;
[root&＃64;node1 mha4mysql-node-0.56]# perl Makefile.PL
Can’t locate ExtUtils/MakeMaker.pm in &＃64;INC (&＃64;INC contains: inc /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at inc/Module/Install/Makefile.pm line 4.
BEGIN failed—compilation aborted at inc/Module/Install/Makefile.pm line 4. Compilation failed in require at inc/Module/Install.pm line 283.
Can’t locate ExtUtils/MakeMaker.pm in &＃64;INC (&＃64;INC contains: inc /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/
vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at inc/Module/Install/Can.pm line 6.
BEGIN failed—compilation aborted at inc/Module/Install/Can.pm line 6.
Compilation failed in require at inc/Module/Install.pm line 283.
Can’t locate ExtUtils/MM_Unix.pm in &＃64;INC (&＃64;INC contains: inc /usr/local/lib64/
perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有