MySQL 有关MHA搭建与切换的几个错误log

1：masterha_check_repl 副本集方面报错  replicates is not defined in the configuration file!

具体信息如下：

# /usr/local/bin/masterha_check_repl --conf=/etc/mha/app1.cnf


thu nov 21 15:33:15 2018 - [warning] global configuration file /etc/masterha_default.cnf not found. skipping.
thu nov 21 15:33:15 2018 - [info] reading application default configuration from /etc/mha/app1.cnf..
thu nov 21 15:33:15 2018 - [info] reading server configuration from /etc/mha/app1.cnf..
thu nov 21 15:33:15 2018 - [info] mha::mastermonitor version 0.56.
thu nov 21 15:33:16 2018- [error][/usr/local/share/perl5/mha/servermanager.pm, ln671] master 179.179.19.179:3306 from which slave 179.179.19.180(179.179.19.180:3306) replicates is not defined in the configuration file!
thu nov 21 15:33:16 2018 - [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 nov 21 15:33:16 2018 - [error][/usr/local/share/perl5/mha/mastermonitor.pm, ln523] error happened on monitoring servers.
thu nov 21 15:33:16 2018 - [info] got exit code 1 (not master dead).

mysql replication health is not ok!

分析：mha 漂移过后，我们知道配置信息中 主节点的信息就不在了，我们需要及时维护，否则/usr/local/bin/masterha_check_repl --conf=/etc/mha/xxx.cnf 检查副本集状态报错。

2. masterha_master_switch 在线切换方面 报错 we should not start online master switch when one of connections are running long updates on the current master

具体信息如下：

# /usr/local/bin/masterha_master_switch --master_state=alive --conf=/etc/mha/app1.cnf

it is better to execute flush no_write_to_binlog tables on the master before switching. is it ok to execute on 179.179.19.184(179.179.19.184:3306)? (yes/no): y

tue nov 19 17:19:09 2018 - [info] executing flush no_write_to_binlog tables. this may take long time..
tue nov 19 17:19:09 2018 - [info]  ok.
tue nov 19 17:19:09 2018 - [info] checking mha is not monitoring or doing failover..
tue nov 19 17:19:09 2018 - [info] checking replication health on 179.179.19.185..
tue nov 19 17:19:09 2018 - [info]  ok.
tue nov 19 17:19:09 2018 - [error][/usr/local/share/perl5/mha/masterrotate.pm, ln161] we should not start online master switch when one of connections are running long updates on the current master(179.179.19.184(179.179.19.184:3306)). currently 1 update thread(s) are running.
details:
{'time' => '12815','db' => undef,'id' => '1','user' => 'event_scheduler','state' => 'waiting on empty queue','command' => 'daemon','info' => undef,'host' => 'localhost'}
tue nov 19 17:19:09 2018 - [error][/usr/local/share/perl5/mha/managerutil.pm, ln177] got error:  at /usr/local/bin/masterha_master_switch line 53.

分析：set global event_scheduler=off; 主从都要关闭

3. masterha_master_switch 在线切换方面 报错 got error: dbi .....failed: access denied for user

# /usr/local/bin/masterha_master_switch --master_state=alive --conf=/etc/mha/app1.cnf

starting master switch from 179.179.19.185(179.179.19:3306) to 179.179.19.184(179.179.19.184:3306)? (yes/no): yes

tue nov 19 18:52:04 2018 - [info] checking whether 179.179.19.184(179.179.19.184:3306) is ok for the new master..
tue nov 19 18:52:04 2018 - [info]  ok.
tue nov 19 18:52:04 2018 - [info] ** phase 1: configuration check phase completed.
tue nov 19 18:52:04 2018 - [info] 
tue nov 19 18:52:04 2018 - [info] * phase 2: rejecting updates phase..
tue nov 19 18:52:04 2018 - [info] 
tue nov 19 18:52:04 2018 - [info] executing master ip online change script to disable write on the current master:
tue nov 19 18:52:04 2018 - [info]   /usr/local/bin/master_ip_online_change_appuanalysis --command=stop --orig_master_host=179.179.19.185 --orig_master_ip=179.179.19.185 --orig_master_port=3306--orig_master_user='weixinlx391p_xldbmha' --orig_master_password='weixinlx391p_xldbmha\)qlk' --new_master_host=179.179.19.184 --new_master_ip=179.179.19.184 --new_master_port=55988 --new_master_user='us_mha' --new_master_password='weixinlx391p_xldbmha\)qlk' --orig_master_ssh_user=root --new_master_ssh_user=root  
got error: dbi connect(';host=179.179.19.184;port=3306;mysql_connect_timeout=4','weixinlx391p_xldbmha',...) failed: access denied for user 'weixinlx391p_xldbmha'@'179.179.19.166' (using password: yes) at /usr/local/share/perl5/mha/dbhelper.pm line 205.
 at /usr/local/bin/master_ip_online_change_app1 line 119.

tue nov 19 18:52:04 2018 - [error][/usr/local/share/perl5/mha/managerutil.pm, ln177] got error:  at /usr/local/bin/masterha_master_switch line 53.

分析：账号密码有需要转移字符的。app1.cnf 文件中user账号相应的密码 password 不能有待转移的字符，例如本例中的')'，但是 账号 repl_user 相应的密码repl_password 没有此限制。