前言
一、MHA安装方式
1.1.MASTER端
1.1.1.安装MHA MASTER端
unzip mha.zip
yum install *.rpm -y
1.1.2.配置文件生成
cd mha4mysql-manager-0.58/
mkdir /etc/mha
cat samples/conf/app1.cnf > /etc/mha/app1.cnf
cat samples/conf/masterha_default.cnf >> /etc/mha/app1.cnf
1.1.3配置文件编写
[server default]
user=root
password=dockerps-A1
ssh_user=root
master_binlog_dir=/var/lib/mysql
remote_workdir=/etc/mha/data
repl_user=repl
repl_password=dockerps-A1
secondary_check_script= masterha_secondary_check -s 192.168.63.130 -s 192.168.63.153
ping_interval=3
master_ip_failover_script= /usr/local/bin/master_ip_failover