基於前述 MySQL 5.6 主從環境,本文詳細說明 MHA 0.52 版本的安裝、SSH 互信、Manager 配置、健康檢查全流程,打造生產級 MySQL 高可用集群。
yum -y install perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager
wget https://mysql-master-ha.googlecode.com/files/mha4mysql-node-0.52-0.noarch.rpm
wget https://mysql-master-ha.googlecode.com/files/mha4mysql-manager-0.52-0.noarch.rpm
rpm -ivh mha4mysql-node-0.52-0.noarch.rpm
rpm -ivh mha4mysql-manager-0.52-0.noarch.rpm
wget https://mysql-master-ha.googlecode.com/files/mha4mysql-manager-0.52.tar.gz
tar zxvf mha4mysql-manager-0.52.tar.gz
cd mha4mysql-manager-0.52
perl Makefile.PL && make && make install
Node 端兩台主機均需安裝 mha4mysql-node。
ssh-keygen -t rsa + ssh-copy-id(過程略)。# 10.1.1.231 (Master) 執行
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.1.1.234' IDENTIFIED BY 'rootpasswd';
FLUSH PRIVILEGES;
# 10.1.1.234 (Slave) 執行
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.1.1.231' IDENTIFIED BY 'rootpasswd';
FLUSH PRIVILEGES;
/etc/masterha/app1.cnf[server default]
manager_workdir=/masterha/app1/
manager_log=/masterha/app1/manager.log
user=root
password=d3n0v0
ssh_user=root
repl_user=jpsync
repl_password=jpsyncpass2014la
ping_interval=1
shutdown_script=""
master_ip_failover_script=""
master_ip_online_change_script=""
report_script=""
[server1]
hostname=10.1.1.231
port=63306
master_binlog_dir="/state/partition1/mysql/data"
candidate_master=1
[server2]
hostname=10.1.1.234
port=63306
master_binlog_dir="/state/partition1/mysql/data"
candidate_master=1
關鍵參數:candidate_master=1 標記該節點具備提升為 Master 資格;master_binlog_dir 需與實際 Binlog 目錄一致。
masterha_check_ssh --conf=/etc/masterha/app1.cnf
# 輸出 "All SSH connection tests passed successfully." 即通過
masterha_check_status --conf=/etc/masterha/app1.cnf
# app1 (pid:11444) is running(0:PING_OK), master:10.1.1.231
masterha_check_repl --conf=/etc/masterha/app1.cnf
輸出重點解讀:
Primary candidate for the new Masterrelay_log_purge=0(建議補上)master_ip_failover_script、shutdown_script(生產環境必須實作 VIP 漂移與關機腳本)MySQL Replication Health is OK,MHA 可正常接管故障切換。master_ip_failover_script 整合 Keepalived/VIP 或云廠商 API 實現 IP 漂移shutdown_script 確保故障主庫徹底下線(防止腦裂)report_script 對接告警系統(郵件/企業微信/釘釘)masterha_master_switch --master_state=alive 計劃性切換驗證流程