先看下引起問(wèn)題的密碼啥樣, 包含兩個(gè)特殊字符[和~.
$ egrep -w 'user|password' /etc/masterha/app1.cnf
password=P[AI3M~5z
user=mha_mgr
用戶mha_mgr的作用, 如下文檔中的說(shuō)明, 可見(jiàn)其對(duì)數(shù)據(jù)庫(kù)實(shí)例起到管理的作用.
MySQL administrative database username to the target MySQL server. This should be root because it runs all necessary administrative commands such as STOP SLAVE, CHANGE MASTER, RESET SLAVE.
看看兩種場(chǎng)景下切換失敗的現(xiàn)象.
1. 手動(dòng)在線切換, 據(jù)日志可看到, MHA將密碼中的特殊字符轉(zhuǎn)義了, 致使用戶mha_mgr連接數(shù)據(jù)庫(kù)失敗.
檢查原有的主從復(fù)制狀態(tài), 發(fā)現(xiàn)無(wú)變化, 即切換失敗, 并沒(méi)造成影響.
$ masterha_master_switch --conf=/etc/masterha/app1.cnf --master_state=alive --orig_master_is_new_slave
...
Thu Jan 11 10:28:39 2018 - [info] * Phase 2: Rejecting updates Phase..
Thu Jan 11 10:28:39 2018 - [info]
Thu Jan 11 10:28:39 2018 - [info] Executing master ip online change script to disable write on the current master:
Thu Jan 11 10:28:39 2018 - [info] /usr/local/bin/master_ip_online_change --command=stop --orig_master_host=192.168.4.42 --orig_master_ip=192.168.4.42 --orig_master_port=3306 --orig_master_user='mha_mgr' --orig_master_password='P\[AI3M\~5z' --new_master_host=192.168.4.43 --new_master_ip=192.168.4.43 --new_master_port=3306 --new_master_user='mha_mgr' --new_master_password='P\[AI3M\~5z' --orig_master_ssh_user=mysql --new_master_ssh_user=mysql --orig_master_is_new_slave
ARGS: $VAR1 = [
'--command=stop',
'--orig_master_host=192.168.4.42',
'--orig_master_ip=192.168.4.42',
'--orig_master_port=3306',
'--orig_master_user=mha_mgr',
'--orig_master_password=P\\[AI3M\\~5z',
'--new_master_host=192.168.4.43',
'--new_master_ip=192.168.4.43',
'--new_master_port=3306',
'--new_master_user=mha_mgr',
'--new_master_password=P\\[AI3M\\~5z',
'--orig_master_ssh_user=mysql',
'--new_master_ssh_user=mysql',
'--orig_master_is_new_slave'
];
Unknown option: orig_master_ssh_user
Unknown option: new_master_ssh_user
Unknown option: orig_master_is_new_slave
Got Error: DBI connect(';host=192.168.4.43;port=3306;mysql_connect_timeout=4','mha_mgr',...) failed: Access denied for user 'mha_mgr'@'192.168.4.45' (using password: YES) at /usr/local/share/perl5/MHA/DBHelper.pm line 205.
at /usr/local/bin/master_ip_online_change line 132.
Thu Jan 11 10:28:39 2018 - [error][/usr/local/share/perl5/MHA/ManagerUtil.pm, ln177] Got ERROR: at /usr/local/bin/masterha_master_switch line 53.
2. 自動(dòng)故障切換(手動(dòng)關(guān)閉主庫(kù), 模擬故障), 日志最后出現(xiàn)了"completed successfully"的字樣, 貌似沒(méi)問(wèn)題, 但詳細(xì)查看日志, 發(fā)現(xiàn)一處和上面類似的報(bào)錯(cuò), 見(jiàn)標(biāo)黃處.
檢查原有的復(fù)制狀態(tài), 發(fā)現(xiàn)復(fù)制關(guān)系切換正常, 但是寫(xiě)虛擬IP不見(jiàn)了, 即不可寫(xiě)了.
$ tail -f /var/log/masterha/manager.log
...
Fri Jan 12 10:33:55 2018 - [info] Executing master IP activate script:
Fri Jan 12 10:33:55 2018 - [info] /usr/local/bin/master_ip_failover --command=start --ssh_user=mysql --orig_master_host=192.168.4.42 --orig_master_ip=192.168.4.42 --orig_master_port=3306 --new_master_host=192.168.4.43 --new_master_ip=192.168.4.43 --new_master_port=3306 --new_master_user='mha_mgr' --new_master_password='P\[AI3M\~5z'
DBI connect(';host=192.168.4.43;port=3306;mysql_connect_timeout=4','mha_mgr',...) failed: Access denied for user 'mha_mgr'@'192.168.4.45' (using password: YES) at /usr/local/share/perl5/MHA/DBHelper.pm line 205.
at /usr/local/bin/master_ip_failover line 81.
Fri Jan 12 10:33:55 2018 - [error][/usr/local/share/perl5/MHA/MasterFailover.pm, ln1588] Failed to activate master IP address for 192.168.4.43(192.168.4.43:3306) with return code 10:0
Fri Jan 12 10:33:55 2018 - [warning] Proceeding.
Fri Jan 12 10:33:55 2018 - [info] Setting read_only=0 on 192.168.4.43(192.168.4.43:3306)..
Fri Jan 12 10:33:55 2018 - [info] ok.
...
Master failover to 192.168.4.43(192.168.4.43:3306) completed successfully.
Fri Jan 12 10:33:57 2018 - [info] Sending mail..
解決方法, 換個(gè)比較正常的密碼就行了. 至于修復(fù)這個(gè)小缺陷, 還要仔細(xì)查下代碼.
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。
重慶分公司
重慶分公司
