centos7 安装mysql5.7 MHA

安装三台虚拟机01，02，03

01 主

02 从

03 从  mha4mysql-manager

 ----------------------------------------------------------------------------------------------------------------------- 

centos 配置环境：

更换yum源

wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo

sed -i -e '/mirrors.cloud.aliyuncs.com/d' -e '/mirrors.aliyuncs.com/d' /etc/yum.repos.d/CentOS-Base.repo
mkdir /mysql
cd /mysql
   
同步时间
rpm -ivh http://mirrors.wlnmp.com/centos/wlnmp-release-centos.noarch.rpm
vim /etc/chrony.conf

server 210.72.145.44 iburst
server ntp.aliyun.com iburst

systemctl restart chronyd.service
chronyc sources -v
timedatectl set-timezone Asia/Shanghai

关闭selinux
   vim /etc/sysconfig/selinux
   SELinux=disabled
   reboot 重启
  防火墙开3306端口
  

firewall-cmd --zone=public --add-port=3306/tcp --permanent
systemctl restart firewalld
安装mysql 依赖包
    yum install libncurses*
--  yum install libtinfo*## 

 ----------------------------------------------------------------------------------------------------------------------- 

mkdir /mysql

所有Node节点安装mha-node软件包及依赖包

wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -ivh epel-release-latest-7.noarch.rpm 

yum -y install perl-DBD-MySQL ncftp perl-DBI.x86
rpm -ivh mha4mysql-node-0.58-0.el7.centos.noarch.rpm 

在03安装mha-manager软件及依赖包

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

安装完成后移除mariadb-libs，和mysql5.7安装包冲突，但他又是mha-node的依赖

   rpm -e mariadb-libs-1:5.5.68-1.el7.x86_64 --nodeps
   
 -----------------------------------------------------------------------------------------------------------------------

离线安装：

所有节点安装mha-node软件包及依赖包

rpm -ivh perl-Data-Dumper-2.145-3.el7.x86_64.rpm

rpm -ivh perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm

rpm -ivh perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm

rpm -ivh perl-IO-Compress-2.061-2.el7.noarch.rpm

rpm -ivh perl-Net-Daemon-0.48-5.el7.noarch.rpm

rpm -ivh perl-PlRPC-0.2020-14.el7.noarch.rpm

rpm -ivh perl-DBI-1.627-4.el7.x86_64.rpm

rpm -ivh perl-DBD-MySQL-4.023-6.el7.x86_64.rpm

rpm -ivh mha4mysql-node-0.58-0.el7.centos.noarch.rpm

在03安装mha-manager软件及依赖包

rpm -ivh perl-Config-Tiny-2.14-7.el7.noarch.rpm

rpm -ivh perl-Parallel-ForkManager-1.18-2.el7.noarch.rpm

rpm -ivh epel-release-latest-7.noarch.rpm

rpm -ivh perl-Email-Date-Format-1.002-15.el7.noarch.rpm

rpm -ivh perl-Mail-Sendmail-0.79-21.el7.noarch.rpm

rpm -ivh perl-Net-SSLeay-1.55-6.el7.x86_64.rpm

rpm -ivh perl-IO-Socket-IP-0.21-5.el7.noarch.rpm

rpm -ivh perl-Mozilla-CA-20130114-5.el7.noarch.rpm

rpm -ivh perl-Net-LibIDN-0.