Shulou(Shulou.com)05/31 Report--

Mysql MHA deployment of how to install MHA software, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Mysql MHA deployment-MHA software installation

Architecture description:

Reference: http://www.zhaibibei.cn/mysql/mha/

1 MHA Node installation (rac1,rac2,rac3,rac4)

We need to install Node software (including management nodes) on all machines

We need to install the dependent packages related to perl before installing

Download the installation package:

Yum installation is used here. For those not connected to the network, please use the software package in the operating system ISO to configure the local yum source.

Install package network disk link: https://pan.baidu.com/s/18H12bTIYHi2H0dXs2DI7NA extraction code: mwkq

[root@rac1 mha] # pwd

/ package/mysql/MHA/mha

[root@rac1 mha] # ll-rth

Total 700K

-rw-r--r-- 1 root root 400 Mar 14 13:42 download.txt

-rw-r--r-- 1 root root 84K Mar 14 13:42 mha4mysql-manager-0.56-0.el5.noarch.rpm

-rw-r--r-- 1 root root 86K Mar 14 13:42 mha4mysql-manager-0.56-0.el6.noarch.rpm

-rw-r--r-- 1 root root 112K Mar 14 13:42 mha4mysql-manager-0.56.tar.gz

-rw-r--r-- 1 root root 80K Mar 14 13:42 mha4mysql-manager-0.57-0.el7.noarch.rpm

-rw-r--r-- 1 root root 116K Mar 14 13:42 mha4mysql-manager-0.57.tar.gz

-rw-r--r-- 1 root root 36K Mar 14 13:42 mha4mysql-node-0.56-0.el5.noarch.rpm

-rw-r--r-- 1 root root 36K Mar 14 13:42 mha4mysql-node-0.56-0.el6.noarch.rpm

-rw-r--r-- 1 root root 49K Mar 14 13:42 mha4mysql-node-0.56.tar.gz

-rw-r--r-- 1 root root 35K Mar 14 13:42 mha4mysql-node-0.57-0.el7.noarch.rpm

-rw-r--r-- 1 root root 54K Mar 14 13:42 mha4mysql-node-0.57.tar.gz

Start the installation:

[root@rac1 mha] # yum install perl-DBD-MySQL

Loaded plugins: fastestmirror, langpacks

Loading mirror speeds from cached hostfile

File:///mnt/repodata/repomd.xml: [Errno 14] curl#37-"Couldn't open file / mnt/repodata/repomd.xml"

Trying other mirror.

Package perl-DBD-MySQL-4.023-6.el7.x86_64 already installed and latest version

Nothing to do

[root@rac1 mha] # rpm-ivh mha4mysql-node-0.56-0.el6.noarch.rpm

Preparing... # # [100%]

Updating / installing...

1:mha4mysql-node-0.56-0.el6 # # [100%]

2 MHA Manager installation

We need to install Manager software on manager

Some dependency packages are also required to install Manager

Yum installation is used here. For those not connected to the network, please use the software package in the operating system ISO to configure the local yum source.

Some rpm packages are included in the network disk above.

Since there is a lot of dependence, you can follow my steps below. Note that some commands end up with an asterisk.

Root user

Rpm-ivh perl-Config-Tiny-2.12-1.el6.rfx.noarch.rpm

Rpm-ivh perl-Time-HiRes-1.9724-1.el6.rfx.x86_64.rpm

Yum install perl-Params-Validate

Rpm-ivh perl-Log-Dispatch-2.26-1.el6.rf.noarch.rpm

Yum install perl-Parallel-ForkManager*

Rpm-ivh mha4mysql-manager-0.56-0.el6.noarch.rpm

Perl-Parallel-ForkManager download address:

Https://centos.pkgs.org/7/epel-aarch74/perl-Parallel-ForkManager-1.18-2.el7.noarch.rpm.html

Binary Package https://download-ib01.fedoraproject.org/pub/epel/7/aarch74/Packages/p/perl-Parallel-ForkManager-1.18-2.el7.noarch.rpm

Source Package https://download-ib01.fedoraproject.org/pub/epel/7/SRPMS/Packages/p/perl-Parallel-ForkManager-1.18-2.el7.src.rpm

Or install them all manually

Rpm-ivh perl-Config-Tiny-2.12-7.1.el6.noarch.rpm

Rpm-ivh mha4mysql-node-0.56-0.el6.noarch.rpm

Rpm-ivh perl-DBD-MySQL-4.013-3.el6.i686.rpm

Rpm-ivh compat-db43-4.3.29-15.el6.x86_64.rpm

Rpm-ivh perl-Mail-Sender-0.8.16-3.el6.noarch.rpm

Rpm-ivh perl-Parallel-ForkManager-0.7.9-1.el6.noarch.rpm

Rpm-ivh perl-TimeDate-1.16-11.1.el6.noarch.rpm

Rpm-ivh perl-MIME-Types-1.28-2.el6.noarch.rpm

Rpm-ivh perl-MailTools-2.04-4.el6.noarch.rpm

Rpm-ivh perl-Email-Date-Format-1.002-5.el6.noarch.rpm

Rpm-ivh perl-Params-Validate-0.92-3.el6.

Rpm-ivh perl-Params-Validate-0.92-3.el6.x86_64.rpm

Rpm-ivh perl-MIME-Lite-3.027-2.el6.noarch.rpm

Rpm-ivh perl-Mail-Sendmail-0.79-12.el6.noarch.rpm

Rpm-ivg perl-Log-Dispatch-2.27-1.el6.noarch.rpm

Rpm-ivh mha4mysql-manager-0.56-0.el6.noarch.rpm

3. Verify installation

Now that we have finished the installation, let's verify it.

[root@rac4 mha] # rpm-ql mha4mysql-manager

/ usr/bin/masterha_check_repl

/ usr/bin/masterha_check_ssh

/ usr/bin/masterha_check_status

/ usr/bin/masterha_conf_host

/ usr/bin/masterha_manager

/ usr/bin/masterha_master_monitor

/ usr/bin/masterha_master_switch

/ usr/bin/masterha_secondary_check

/ usr/bin/masterha_stop

/ usr/share/man/man1/masterha_check_repl.1.gz

/ usr/share/man/man1/masterha_check_ssh.1.gz

/ usr/share/man/man1/masterha_check_status.1.gz

/ usr/share/man/man1/masterha_conf_host.1.gz

/ usr/share/man/man1/masterha_manager.1.gz

/ usr/share/man/man1/masterha_master_monitor.1.gz

/ usr/share/man/man1/masterha_master_switch.1.gz

/ usr/share/man/man1/masterha_secondary_check.1.gz

/ usr/share/man/man1/masterha_stop.1.gz

/ usr/share/perl5/vendor_perl/MHA/Config.pm

/ usr/share/perl5/vendor_perl/MHA/DBHelper.pm

/ usr/share/perl5/vendor_perl/MHA/FileStatus.pm

/ usr/share/perl5/vendor_perl/MHA/HealthCheck.pm

/ usr/share/perl5/vendor_perl/MHA/ManagerAdmin.pm

/ usr/share/perl5/vendor_perl/MHA/ManagerAdminWrapper.pm

/ usr/share/perl5/vendor_perl/MHA/ManagerConst.pm

/ usr/share/perl5/vendor_perl/MHA/ManagerUtil.pm

/ usr/share/perl5/vendor_perl/MHA/MasterFailover.pm

/ usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm

/ usr/share/perl5/vendor_perl/MHA/MasterRotate.pm

/ usr/share/perl5/vendor_perl/MHA/SSHCheck.pm

/ usr/share/perl5/vendor_perl/MHA/Server.pm

/ usr/share/perl5/vendor_perl/MHA/ServerManager.pm

[root@rac4 mha] # rpm-ql mha4mysql-node

/ usr/bin/apply_diff_relay_logs

/ usr/bin/filter_mysqlbinlog

/ usr/bin/purge_relay_logs

/ usr/bin/save_binary_logs

/ usr/share/man/man1/apply_diff_relay_logs.1.gz

/ usr/share/man/man1/filter_mysqlbinlog.1.gz

/ usr/share/man/man1/purge_relay_logs.1.gz

/ usr/share/man/man1/save_binary_logs.1.gz

/ usr/share/perl5/vendor_perl/MHA/BinlogHeaderParser.pm

/ usr/share/perl5/vendor_perl/MHA/BinlogManager.pm

/ usr/share/perl5/vendor_perl/MHA/BinlogPosFindManager.pm

/ usr/share/perl5/vendor_perl/MHA/BinlogPosFinder.pm

/ usr/share/perl5/vendor_perl/MHA/BinlogPosFinderElp.pm

/ usr/share/perl5/vendor_perl/MHA/BinlogPosFinderXid.pm

/ usr/share/perl5/vendor_perl/MHA/NodeConst.pm

/ usr/share/perl5/vendor_perl/MHA/NodeUtil.pm

/ usr/share/perl5/vendor_perl/MHA/SlaveUtil.pm

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.