MHA搭建

男娘i 2021-11-29 09:42 709阅读 0赞

https://metacpan.org 下载perl依赖包的网站

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#上传安装依赖包\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

mkdir /opt/soft\_file  
上传所有包

下面这些只需要在管理节点上安装

cd /opt/soft\_file/rpm  
rpm --import /etc/pki/rpm-gpg/RPM\*  
yum -y install glibc.i686  
yum -y install libstdc++.i686  
rpm -ivh perl-Log-Dispatch-2.22-7.3.noarch.rpm --force --nodeps  
rpm -ivh perl-Config-Tiny-2.12-1.el5.rf.noarch.rpm --force --nodeps  
rpm -ivh perl-Params-Validate-0.95-1.el5.rf.i386.rpm --force --nodeps  
rpm -ivh perl-MIME-Types-1.28-2.el6.noarch.rpm --force --nodeps  
rpm -ivh perl-Email-Date-Format-1.002-5.el6.noarch.rpm --force --nodeps  
rpm -ivh perl-Mail-Sender-0.8.16-3.el6.noarch.rpm --force --nodeps  
rpm -ivh perl-Mail-Sendmail-0.79-12.el6.noarch.rpm --force --nodeps  
rpm -ivh perl-TimeDate-1.16-11.1.el6.noarch.rpm --force --nodeps  
rpm -ivh perl-MailTools-2.04-4.el6.noarch.rpm --force --nodeps  
rpm -ivh perl-MIME-Lite-3.027-2.el6.noarch.rpm --force --nodeps  
rpm -ivh perl-Log-Dispatch-2.26-1.el5.rf.noarch.rpm --force --nodeps  
rpm -ivh perl-Time-HiRes-1.9724-1.el6.rfx.x86\_64.rpm --force --nodeps

cd /opt/soft\_file/

tar -zxvf Log-Dispatch-2.22.tar.gz  
cd Log-Dispatch-2.22  
perl Makefile.PL  
make && make install

tar -zxvf Parallel-ForkManager-1.11.tar.gz  
cd Parallel-ForkManager-1.11  
perl Makefile.PL  
make && make install

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#主从复制\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
主库  
use mysql  
grant replication slave on \*.\* to 'rep'@'192.168.159.129' identified by 'rep123';  
show master status\\G  
select user,host,password from user;

备库  
CHANGE MASTER TO  
MASTER\_HOST='192.168.159.128',  
MASTER\_PORT=3306,  
MASTER\_USER='rep',  
MASTER\_PASSWORD='rep123';

CHANGE MASTER TO  
MASTER\_HOST='192.168.76.131',  
MASTER\_PORT=3306,  
MASTER\_LOG\_FILE='binlog.000013',  
MASTER\_LOG\_POS=1030,  
MASTER\_USER='rep',  
MASTER\_PASSWORD='rep123';

start slave;  
show slave status\\G

主库  
delete from user where user='';  
delete from user where user='root' or '';  
grant all privileges on \*.\* to 'root'@'%' identified by 'root123' with grant option;  
grant all privileges on \*.\* to 'root'@'localhost' identified by 'root123' with grant option;  
grant all privileges on \*.\* to 'root'@'127.0.0.1' identified by 'root123' with grant option;

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#hosts配置\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
1.服务器  
192.168.76.131 host1 \#Master  
192.168.76.132 host2 \#Slave  
192.168.76.139 host3 \#MHA manager

2. 所有机器修改vim /etc/hosts  
192.168.159.128 host1  
192.168.159.129 host2  
192.168.159.130 host3

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#SSH公钥免密码\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
3.设置SSH公钥免密码登录  
\#root用户操作(/root),pwd

mkdir ~/.ssh  
chmod 700 ~/.ssh  
cd ~/.ssh  
ssh-keygen -t rsa \#一直回车  
ls -al  
cat ~/.ssh/id\_rsa.pub >> ~/.ssh/authorized\_keys  
ls -al  
chmod 600 ~/.ssh/authorized\_keys  
cd ..  
scp -r .ssh 192.168.76.132:/root/  
scp -r .ssh 192.168.76.139:/root/  
  
ssh host1 date  
ssh host2 date  
ssh host3 date  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#MHA部署\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
4.下载mha4mysql-manager和mha4mysql-node  
https://github.com/yoshinorim/mha4mysql-manager  
https://github.com/yoshinorim/mha4mysql-node

5.在三个节点（node 和 manager）安装perl-DBD-MySQL，用光盘作yum源，\#包括了3个包：Perl-DBD-MySQL,mysql-libs,perl-DBI  
yum install -y perl-DBD-MySQL  
yum install -y perl-DBI  
yum install -y mysql-libs

6.在三个节点安装node（包括管理节点）  
cd /opt/soft\_file  
tar -xzvf mha4mysql-node-0.56.tar.gz  
cd mha4mysql-node-0.56  
perl Makefile.PL  
make && make install

7.在管理节点安装manager  
cd /opt/soft\_file  
tar -xzvf mha4mysql-manager-0.56.tar.gz  
cd mha4mysql-manager-0.56  
perl Makefile.PL  
make && make install

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#配置文件\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
mkdir -p /u01/mha/etc  
mkdir -p /u01/mha/log  
mkdir -p /u01/mha/etc/app

vim /u01/mha/etc/app.cnf

\[server default\]  
user = root  
password = root123  
ssh\_user = root  
repl\_user = rep  
repl\_password = rep123  
ping\_interval = 1  
ping\_type = SELECT

manager\_workdir=/u01/mha/etc/app  
manager\_log=/u01/mha/log/manager.log  
remote\_workdir=/u01/mha/etc/app  
master\_binlog\_dir="/u01/svr/log/my3306/binlog"

master\_ip\_failover\_script="/u01/mha/etc/master\_ip\_failover"  
master\_ip\_online\_change\_script="/u01/mha/etc/master\_ip\_failover"

shutdown\_script=""

report\_script=""

\#check\_repl\_delay=0

\[server1\]  
hostname=host1  
port=3306  
master\_binlog\_dir="/u01/svr/log/my3306/binlog"  
candidate\_master=1  
ignore\_fail=1

\[server2\]  
hostname=host2  
port=3307  
master\_binlog\_dir="/u01/svr/log/my3307/binlog"  
candidate\_master=1  
ignore\_fail=1

MHA测试  
/usr/local/bin/masterha\_check\_ssh --conf=/u01/mha/etc/app.cnf

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#切换脚本\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

vim /u01/mha/etc/master\_ip\_failover  
chmod 777 master\_ip\_failover

\#!/usr/bin/env perl  
use strict;  
use warnings FATAL => 'all';  
  
use Getopt::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 = '192.168.76.140/24'; \# Virtual IP  
my $key = "1";  
my $int = "eth0";  
my $ssh\_start\_vip = "/sbin/ifconfig $int:$key $vip";  
my $ssh\_stop\_vip = "/sbin/ifconfig $int:$key down";  
my $arp\_effect = "/sbin/arping -Uq -s192.168.76.140 -I $int 192.168.76.1 -c 3"; \# Virtual IP and gateway  
\#my $test = "echo successfull >/tmp/test.txt";  
$ssh\_user = "root";  
GetOptions(  
'command=s' => \\$command,  
'ssh\_user=s' => \\$ssh\_user,  
'orig\_master\_host=s' => \\$orig\_master\_host,  
'orig\_master\_ip=s' => \\$orig\_master\_ip,  
'orig\_master\_port=i' => \\$orig\_master\_port,  
'new\_master\_host=s' => \\$new\_master\_host,  
'new\_master\_ip=s' => \\$new\_master\_ip,  
'new\_master\_port=i' => \\$new\_master\_port,  
);  
  
exit &main();  
  
sub main \{  
  
print "\\n\\nIN SCRIPT TEST====$ssh\_stop\_vip==$ssh\_start\_vip===\\n\\n";  
  
if ( $command eq "stop" || $command eq "stopssh" ) \{  
  
\# $orig\_master\_host, $orig\_master\_ip, $orig\_master\_port are passed.  
\# If you manage master ip address at global catalog database,  
\# invalidate orig\_master\_ip here.  
my $exit\_code = 1;  
eval \{  
print "Disabling the VIP on old master: $orig\_master\_host \\n";  
&stop\_vip();  
$exit\_code = 0;  
\};  
if ($@) \{  
warn "Got Error: $@\\n";  
exit $exit\_code;  
\}  
exit $exit\_code;  
\}  
elsif ( $command eq "start" ) \{  
  
\# all arguments are passed.  
\# If you manage master ip address at global catalog database,  
\# activate new\_master\_ip here.  
\# You can also grant write access (create user, set read\_only=0, etc) here.  
my $exit\_code = 10;  
eval \{  
print "Enabling the VIP - $vip on the new master - $new\_master\_host \\n";  
&start\_vip();  
$exit\_code = 0;  
\};  
if ($@) \{  
warn $@;  
exit $exit\_code;  
\}  
exit $exit\_code;  
\}  
elsif ( $command eq "status" ) \{  
print "Checking the Status of the script.. OK \\n";  
\`ssh $ssh\_user\\@host1 \\" $ssh\_start\_vip \\"\`;  
&status();  
exit 0;  
\}  
else \{  
&usage();  
exit 1;  
\}  
\}  
  
\# A simple system call that enable the VIP on the new master  
sub start\_vip() \{  
\`ssh $ssh\_user\\@$new\_master\_host \\" $ssh\_start\_vip \\"\`;  
\`ssh $ssh\_user\\@$new\_master\_host \\" $arp\_effect \\"\`;  
\# \`ssh $ssh\_user\\@$new\_master\_host \\" $test \\"\`;  
\}  
\# A simple system call that disable the VIP on the old\_master  
sub stop\_vip() \{  
\`ssh $ssh\_user\\@$orig\_master\_host \\" $ssh\_stop\_vip \\"\`;  
\}

sub status() \{  
print \`ssh $ssh\_user\\@$orig\_master\_host \\" ip add show $int \\"\`;  
\}  
  
sub usage \{  
print  
"Usage: master\_ip\_failover --command=start|stop|stopssh|status --orig\_master\_host=host --orig\_maste  
r\_ip=ip --orig\_master\_port=port --new\_master\_host=host --new\_master\_ip=ip --new\_master\_port=port\\n";  
\}

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#常用命令\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
检测SSH  
/usr/local/bin/masterha\_check\_ssh --conf=/u01/mha/etc/app.cnf  
查看复制是否建立好  
a、读取配置文件  
b、检测配置文件中列出的mysql服务器(识别主从)  
c、检测从库配置信息  
read\_only参数  
relay\_log\_purge参数  
复制过滤规则  
d、ssh等效性验证  
e、检测主库保存binlog脚本(save\_binary\_logs) ，主要是用于在master死掉后从binlog读取日志  
f、检测各从库能否apply差量binlog(apply\_diff\_relay\_logs)  
g、检测IP切换，如果有部署脚本  
/usr/local/bin/masterha\_check\_repl --conf=/u01/mha/etc/app.cnf  
检查启动的状态  
/u01/mha/etc/masterha\_check\_status --conf=/u01/mha/etc/app.cnf  
启动mha  
/usr/local/bin/masterha\_manager --conf=/u01/mha/etc/app.cnf &  
停止mha  
/usr/local/bin/masterha\_stop --conf=/u01/mha/etc/app.cnf

7.启动管理节点  
/usr/local/bin/masterha\_manager --conf=/u01/mha/etc/app.cnf &  
/usr/local/bin/masterha\_manager --conf=/u01/mha/etc/app.cnf --remove\_dead\_master\_conf --ignore\_last\_failover &

masterha\_check\_repl --conf=/u01/mha/etc/app.cnf  
检测是否正常  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#切换\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
一、failover故障切换

1.模拟主库宕机  
\[root@mydb3~\]\# ssh mydb1 "killall -r mysqld"

2.查看管理节点日志，可以看到VIP已经漂移  
\[root@mydb3 ~\]\# cat /u01/mha/log/manager.log |grep -i vip

3. 验证VIP是否位于节点mydb2  
\[root@mydb3 ~\]\# ssh mydb2 "ifconfig |grep 56.201 -B1"

4. 查看管理节点MHA切换日志  
\[root@mydb3 ~\]\# tail /u01/mha/log/manager.log

5. new master(old slave)  
show master status\\G

6. new slave(old:master)  
(1)打开MySQL  
mysqld\_safe --defaults-file=/u01/my3306/my.cnf &

(2)检查数据库  
show master status\\G  
show slave status\\G

(3)在管理节点日志中查主库的日志文件和位置  
cat /u01/mha/log/manager.log |grep -i change

(4)在slave连接master  
CHANGE MASTER TO  
MASTER\_HOST='192.168.76.132',  
MASTER\_PORT=3307,  
MASTER\_LOG\_FILE='binlog.000006',  
MASTER\_LOG\_POS=7073229,  
MASTER\_USER='rep',  
MASTER\_PASSWORD='rep123';

7.启动管理节点  
/usr/local/bin/masterha\_manager --conf=/u01/mha/etc/app.cnf &  
/usr/local/bin/masterha\_manager --conf=/u01/mha/etc/app.cnf --ignore\_last\_failover &

二、switchover线上切换

1.master：关闭event\_scheduler（即192.168.56.21 host1）  
set global event\_scheduler=off;

2.manager：关闭管理进程 （即192.168.56.23 manager node）  
/usr/local/bin/masterha\_stop --conf=/u01/mha/etc/app.cnf

3.manager：检查配置文件  
/u01/mha/etc/app.cnf 有没有被修改破坏。如果破坏需要重新编辑正确配置文件：/u01/mha/etc/app.cnf  
cp /u01/mha/etc/app.cnf.bak /u01/mha/etc/app.cnf

4.开始切换：  
/u01/mha/etc/masterha\_master\_switch --master\_state=alive --conf=/u01/mha/etc/app.cnf

5.new master(old slave)  
mysql> show master status\\G  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
File: binlog.000021  
Position: 299  
Binlog\_Do\_DB:  
Binlog\_Ignore\_DB:  
Executed\_Gtid\_Set:  
1 row in set (0.00 sec)

6.new slave(old master)  
CHANGE MASTER TO  
MASTER\_HOST='192.168.56.22',  
MASTER\_PORT=3306,  
MASTER\_LOG\_FILE='binlog.000021',  
MASTER\_LOG\_POS=299,  
MASTER\_USER='rep',  
MASTER\_PASSWORD='rep123';

mysql> start slave;  
Query OK, 0 rows affected (0.01 sec)

mysql> show slave status\\G  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Slave\_IO\_State: Waiting for master to send event  
Master\_Host: 192.168.56.12  
Master\_User: repl  
Master\_Port: 3306  
Connect\_Retry: 60  
Master\_Log\_File: binlog.000017  
Read\_Master\_Log\_Pos: 299  
Relay\_Log\_File: relaylog.000002  
Relay\_Log\_Pos: 280  
Relay\_Master\_Log\_File: binlog.000017  
Slave\_IO\_Running: Yes  
Slave\_SQL\_Running: Yes

7.启动管理节点  
/u01/mha/etc/masterha\_manager --conf=/u01/mha/etc/app.cnf &  
/u01/mha/etc/masterha\_manager --conf=/u01/mha/etc/app.cnf --remove\_dead\_master\_conf --ignore\_last\_failover &  
  
启动参数介绍：  
\--remove\_dead\_master\_conf 该参数代表当发生主从切换后，老的主库的ip将会从配置文件中移除。  
\--manger\_log 日志存放位置  
\--ignore\_last\_failover 在缺省情况下，如果MHA检测到连续发生宕机，且两次宕机间隔不足8小时的话，则不会进行Failover，之所以这样限制是为了避免ping-pong效应。该参数代表忽略上次MHA触发切换产生的文件，默认情况下，MHA发生切换后会在日志目录，也就是上面我设置的/data产生app1.failover.complete文件，下次再次切换的时候如果发现该目录下存在该文件将不允许触发切换，除非在第一次切换后收到删除该文件，为了方便，这里设置为--ignore\_last\_failover。

============================================================================  
masterha\_check\_repl报错汇总  
\[root@DBMysql ~\]\#masterha\_check\_repl --conf=/etc/masterha/app1.cnf

导致如下报错的原因主要有两类：

1.mysql的安装时用源码安装，导致mysql的目录与MHA默认的目录不一致。解决办法用ln -s做相关软连接。注：我的mysql数据库是用mysql用户安装的，MHA是用root用户安装的，如果在同一个用户下安装不知是否可以避免此类问题

2.candidate\_master对应的用户权限不足导致。

以下内容摘自网络

报错记录1：

\[root@data01 ~\]\# masterha\_check\_repl--conf=/etc/masterha/app1.cnf  
Tue Apr 7 22:31:06 2015 - \[warning\] Global configuration file/etc/masterha\_default.cnf not found. Skipping.  
Tue Apr 7 22:31:07 2015 - \[info\] Reading application default configuration from/etc/masterha/app1.cnf..  
Tue Apr 7 22:31:07 2015 - \[info\] Reading server configuration from/etc/masterha/app1.cnf..  
Tue Apr 7 22:31:07 2015 - \[info\] MHA::MasterMonitor version 0.56.  
Tue Apr 7 22:31:07 2015 - \[error\]\[/usr/local/share/perl5/MHA/Server.pm,ln303\] Getting relay log directory orcurrent relay logfile from replication table failed on192.168.52.130(192.168.52.130:3306)!  
Tue Apr 7 22:31:07 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln424\] Error happened on checking configurations. at /usr/local/share/perl5/MHA/ServerManager.pmline 315  
Tue Apr 7 22:31:07 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln523\] Error happened on monitoring servers.  
Tue Apr 7 22:31:07 2015 - \[info\] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

\[root@data01 ~\]\#

解决办法：在192.168.52.130上面，vim /etc/my.cnf，在里面添加

relay-log=/home/data/mysql/binlog/mysql-relay-bin  
然后重启mysql，再去重新设置slave连接。  
STOP SLAVE;  
RESET SLAVE;  
CHANGE MASTER TOMASTER\_HOST='192.168.52.129',MASTER\_USER='repl',MASTER\_PASSWORD='repl\_1234',MASTER\_LOG\_FILE='mysql-bin.000178',MASTER\_LOG\_POS=459;  
START SLAVE;  
Ok，搞定了。

报错记录2：  
\[root@data01 perl\]\# masterha\_check\_repl--conf=/etc/masterha/app1.cnf  
Thu Apr 9 00:54:32 2015 - \[warning\] Global configuration file/etc/masterha\_default.cnf not found. Skipping.  
Thu Apr 9 00:54:32 2015 - \[info\] Reading application default configuration from/etc/masterha/app1.cnf..  
Thu Apr 9 00:54:32 2015 - \[info\] Reading server configuration from/etc/masterha/app1.cnf..  
Thu Apr 9 00:54:32 2015 - \[info\] MHA::MasterMonitor version 0.56.  
Thu Apr 9 00:54:32 2015 - \[error\]\[/usr/local/share/perl5/MHA/Server.pm,ln306\] Getting relay log directory orcurrent relay logfile from replication table failed on 192.168.52.130(192.168.52.130:3306)!  
Thu Apr 9 00:54:32 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln424\] Error happened on checking configurations. at/usr/local/share/perl5/MHA/ServerManager.pm line 315  
Thu Apr 9 00:54:32 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln523\] Error happened on monitoring servers.  
Thu Apr 9 00:54:32 2015 - \[info\] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

\[root@data01 perl\]\#

解决方法：

/etc/masterha/app1.cnf文件里面的参数配置，user和repl\_user都是mysql账号，需要创建好，这里是只创建了repl\_user而没有创建好user账号：  
user=manager  
password=manager\_1234  
repl\_user=repl  
repl\_password=repl\_1234

在mysql节点上，建立允许manager 访问数据库的“ manager manager ”账户，主要用于SHOW SLAVESTATUS,RESET SLAVE; 所以需要执行如下命令：  
GRANT SUPER,RELOAD,REPLICATIONCLIENT,SELECT ON \*.\* TO manager@'192.168.52.%' IDENTIFIED BY 'manager\_1234';

错误记录3：  
\[root@oraclem1 ~\]\# masterha\_check\_repl--conf=/etc/masterha/app1.cnf  
Thu Apr 9 23:09:05 2015 - \[warning\] Global configuration file/etc/masterha\_default.cnf not found. Skipping.  
Thu Apr 9 23:09:05 2015 - \[info\] Reading application default configuration from/etc/masterha/app1.cnf..  
Thu Apr 9 23:09:05 2015 - \[info\] Reading server configuration from/etc/masterha/app1.cnf..  
Thu Apr 9 23:09:05 2015 - \[info\] MHA::MasterMonitor version 0.56.  
Thu Apr 9 23:09:05 2015 - \[error\]\[/usr/local/share/perl5/MHA/ServerManager.pm,ln781\] Multi-master configuration is detected, but two or more masters areeither writable (read-only is not set) or dead! Check configurations fordetails. Master configurations are as below:  
Master 192.168.52.130(192.168.52.130:3306),replicating from 192.168.52.129(192.168.52.129:3306)  
Master 192.168.52.129(192.168.52.129:3306),replicating from 192.168.52.130(192.168.52.130:3306)  
Thu Apr 9 23:09:05 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln424\] Error happened on checking configurations. at/usr/local/share/perl5/MHA/MasterMonitor.pm line 326  
Thu Apr 9 23:09:05 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln523\] Error happened on monitoring servers.  
Thu Apr 9 23:09:05 2015 - \[info\] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

\[root@oraclem1 ~\]\#

解决办法：

mysql> set global read\_only=1;  
Query OK, 0 rows affected (0.00 sec)  
mysql>

报错记录4：  
Thu Apr 9 23:54:32 2015 - \[info\] Checking SSH publickey authentication andchecking recovery script configurations on all alive slave servers..  
Thu Apr 9 23:54:32 2015 - \[info\] Executing command : apply\_diff\_relay\_logs --command=test--slave\_user='manager' --slave\_host=192.168.52.130 --slave\_ip=192.168.52.130--slave\_port=3306 --workdir=/var/tmp --target\_version=5.6.12-log--manager\_version=0.56 --relay\_dir=/home/data/mysql/data--current\_relay\_log=mysqld-relay-bin.000011 --slave\_pass=xxx  
Thu Apr 9 23:54:32 2015 - \[info\] Connecting to root@192.168.52.130(192.168.52.130:22)..  
Can't exec "mysqlbinlog": No suchfile or directory at /usr/local/share/perl5/MHA/BinlogManager.pm line 106.  
mysqlbinlog version command failed with rc1:0, please verify PATH, LD\_LIBRARY\_PATH, and client options  
at/usr/local/bin/apply\_diff\_relay\_logs line 493  
Thu Apr 9 23:54:32 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln205\] Slaves settings check failed!  
Thu Apr 9 23:54:32 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln413\] Slave configuration failed.  
Thu Apr 9 23:54:32 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln424\] Error happened on checking configurations. at /usr/local/bin/masterha\_check\_repl line 48  
Thu Apr 9 23:54:32 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln523\] Error happened on monitoring servers.  
Thu Apr 9 23:54:32 2015 - \[info\] Got exit code 1 (Not master dead).  
MySQL Replication Health is NOT OK!

\[root@oraclem1 ~\]\#

解决办法（所有节点都执行一遍）：  
\[root@data02 ~\]\# type mysqlbinlog  
mysqlbinlog is/usr/local/mysql/bin/mysqlbinlog  
\[root@data02 ~\]\#

\[root@data02 ~\]\# ln -s/usr/local/mysql/bin/mysqlbinlog /usr/bin/mysqlbinlog

报错记录5：  
Thu Apr 9 23:57:24 2015 - \[info\] Connecting to root@192.168.52.130(192.168.52.130:22)..  
Checking slave recovery environment settings..  
Relay log found at /home/data/mysql/data, up to mysqld-relay-bin.000013  
Temporary relay log file is /home/data/mysql/data/mysqld-relay-bin.000013  
Testing mysql connection and privileges..sh: mysql: command not found  
mysql command failed with rc 127:0!  
at/usr/local/bin/apply\_diff\_relay\_logs line 375  
main::check()called at /usr/local/bin/apply\_diff\_relay\_logs line 497  
eval\{...\} called at /usr/local/bin/apply\_diff\_relay\_logs line 475  
main::main()called at /usr/local/bin/apply\_diff\_relay\_logs line 120  
Thu Apr 9 23:57:24 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln205\] Slaves settings check failed!  
Thu Apr 9 23:57:24 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln413\] Slave configuration failed.  
Thu Apr 9 23:57:24 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln424\] Error happened on checking configurations. at /usr/local/bin/masterha\_check\_repl line 48  
Thu Apr 9 23:57:24 2015 - \[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm,ln523\] Error happened on monitoring servers.  
Thu Apr 9 23:57:24 2015 - \[info\] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

解决办法（所有节点都执行一遍）：  
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql

报错记录6（所切换机器用户权限不匹配）：  
Fri Apr 10 00:58:36 2015 - \[info\] Executing command : apply\_diff\_relay\_logs--command=test --slave\_user='manager' --slave\_host=192.168.52.130--slave\_ip=192.168.52.130 --slave\_port=3306 --workdir=/var/tmp--target\_version=5.6.12-log --manager\_version=0.56--relay\_dir=/home/data/mysql/data--current\_relay\_log=mysqld-relay-bin.000011 --slave\_pass=xxx  
Fri Apr 10 00:58:36 2015 - \[info\] Connecting to root@192.168.52.130(192.168.52.130:22)..  
Checking slave recovery environment settings..  
Relay log found at /home/data/mysql/data, up to mysqld-relay-bin.000013  
Temporary relay log file is/home/data/mysql/data/mysqld-relay-bin.000013  
Testing mysql connection and privileges..Warning: Using a password onthe command line interface can be insecure.  
ERROR 1142 (42000) at line 1: CREATEcommand denied to user 'manager'@'192.168.52.130' for table'apply\_diff\_relay\_logs\_test'  
mysql command failed with rc 1:0!  
at/usr/local/bin/apply\_diff\_relay\_logs line 375  
main::check()called at /usr/local/bin/apply\_diff\_relay\_logs line 497  
eval\{...\} called at /usr/local/bin/apply\_diff\_relay\_logs line 475  
main::main()called at /usr/local/bin/apply\_diff\_relay\_logs line 120  
Fri Apr 10 00:58:37 2015 -\[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm, ln205\] Slaves settingscheck failed!  
Fri Apr 10 00:58:37 2015 -\[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm, ln413\] Slave configurationfailed.  
Fri Apr 10 00:58:37 2015 -\[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm, ln424\] Error happened onchecking configurations. at/usr/local/bin/masterha\_check\_repl line 48  
Fri Apr 10 00:58:37 2015 -\[error\]\[/usr/local/share/perl5/MHA/MasterMonitor.pm, ln523\] Error happened onmonitoring servers.  
Fri Apr 10 00:58:37 2015 - \[info\] Got exitcode 1 (Not master dead).

MySQL Replication Health is NOT OK!

解决办法：

执行如下授权语句sql：  
GRANT CREATE,INSERT,UPDATE,DELETE,DROP ON\*.\* TO manager@'192.168.52.%';

转载于:https://www.cnblogs.com/dbalightyear/p/11210600.html