MHA的搭建

• 1.配置关键的程序软连接
• 2. 配置互信
• 3. 软件包的安装
• 4. 配置文件的准备
• 5. 状态检查(sjk3)
• 6. 开启MHA(sjk3)
• 7. 查看MHA状态

主机的配置

主从的配置参考博文点击-gtid复制的配置

大致的结构图

ln -s /opt/mysql/bin/mysqlbinlog    /usr/bin/mysqlbinlog
ln -s /opt/mysql/bin/mysql          /usr/bin/mysql

sjk1 sjk2 sjk3
rm -rf /root/.ssh 

sjk1:
ssh-keygen

cd /root/.ssh 

mv id_rsa.pub authorized_keys

scp  -r  /root/.ssh  192.168.80.91:/root 
scp  -r  /root/.ssh  192.168.80.92:/root 

验证，三个节点

ssh 192.168.80.90 date
ssh 192.168.80.91 date
ssh 192.168.80.92 date

上传软件包
https://pan.baidu.com/s/1NykMZVhRMe8o1K_jOiO9Kg
提取码：8h07

[root@sjk1 mha]# unzip MHA-2019-6.28.zip
Archive:  MHA-2019-6.28.zip
  inflating: Atlas-2.2.1.el6.x86_64.rpm
  inflating: email_2019-最新.zip
  inflating: master_ip_failover.txt
  inflating: mha4mysql-manager-0.56-0.el6.noarch.rpm
  inflating: mha4mysql-node-0.56-0.el6.noarch.rpm
[root@sjk1 mha]# ll
total 9936
-rw-r--r-- 1 root root 4963681 Jun 28  2019 Atlas-2.2.1.el6.x86_64.rpm
-rw-r--r-- 1 root root   20904 Jun 28  2019 email_2019-最新.zip
-rw-r--r-- 1 root root    2248 Jun 28  2019 master_ip_failover.txt
-rw-r--r-- 1 root root 5051108 Nov 12 20:39 MHA-2019-6.28.zip
-rw-r--r-- 1 root root   87119 Jun 28  2019 mha4mysql-manager-0.56-0.el6.noarch.rpm
-rw-r--r-- 1 root root   36326 Jun 28  2019 mha4mysql-node-0.56-0.el6.noarch.rpm

三台机器上都要

yum install perl-DBD-MySQL -y
rpm -ivh mha4mysql-node-0.56-0.el6.noarch.rpm

主库sjk1中创建mha用户

grant all privileges on *.* to mha@'192.168.80.%' identified by 'mha';

Manager软件安装（sjk3）

yum install -y perl-Config-Tiny epel-release perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes
rpm -ivh mha4mysql-manager-0.56-0.el6.noarch.rpm

sjk3

创建配置文件目录
mkdir -p /etc/mha
 
创建日志目录
mkdir -p /var/log/mha/app1

编辑mha配置文件

cat > /etc/mha/app1.cnf < 
5. 状态检查(sjk3) 
masterha_check_ssh  --conf=/etc/mha/app1.cnf 
masterha_check_repl  --conf=/etc/mha/app1.cnf 
 
6. 开启MHA(sjk3) 
nohup masterha_manager --conf=/etc/mha/app1.cnf --remove_dead_master_conf --ignore_last_failover  < /dev/null> /var/log/mha/app1/manager.log 2>&1 &
 
7. 查看MHA状态 
masterha_check_status --conf=/etc/mha/app1.cnf


[root@sjk3 mha]# masterha_check_status --conf=/etc/mha/app1.cnf
app1 (pid:16246) is running(0:PING_OK), master:192.168.80.90