MySQL之MHA高可用配置及故障切换实现详细部署步骤_Mysql_

 MHA manager 节点服务器：CentOS7.4(64 位) manager/192.168.126.10 ，安装MHA node 和 manager 组件 Master 节点服务器：CentOS7.4(64 位) mysql1/192.168.126.20 ，安装mysql5.7、MHA node 组件 Slave1 节点服务器：CentOS7.4(64 位) mysql2/192.168.126.30，安装mysql5.7、MHA node 组件 Slave2 节点服务器：CentOS7.4(64 位) mysql3/192.168.126.40，安装mysql5.7、MHA node 组件 

 systemctl stop firewalld systemctl disable firewalld setenforce 0 

 hostnamectl set-hostname Mysql1 hostnamectl set-hostname Mysql2 hostnamectl set-hostname Mysql3 

 vim /etc/my.cnf [mysqld] server-id = 1 log_bin = master-bin log-slave-updates = true systemctl restart mysqld 

 vim /etc/my.cnf server-id = 2 #三台服务器的 server-id 不能一样 log_bin = master-bin relay-log = relay-log-bin relay-log-index = slave-relay-bin.index systemctl restart mysqld 

 ln -s /usr/local/mysql/bin/mysql /usr/sbin/ ln -s /usr/local/mysql/bin/mysqlbinlog /usr/sbin/ 

 mysql -uroot -p grant replication slave on *.* to 'myslave'@'192.168.126.%' identified by '123'; #从数据库同步使用 grant all privileges on *.* to 'mha'@'192.168.126.%' identified by 'manager'; #manager 使用 grant all privileges on *.* to 'mha'@'Mysql1' identified by 'manager'; #防止从库通过主机名连接不上主库 grant all privileges on *.* to 'mha'@'Mysql2' identified by 'manager'; grant all privileges on *.* to 'mha'@'Mysql3' identified by 'manager'; flush privileges; 

 change master to master_host='192.168.126.20',master_user='myslave',master_password='123',master_log_file='master-bin.000001',master_log_pos=1747; start slave; 

 show slave status\G //确保 IO 和 SQL 线程都是 Yes，代表同步正常。 Slave_IO_Running: Yes Slave_SQL_Running: Yes 

 set global read_only=1;

 yum install epel-release --nogpgcheck -y

 yum install -y perl-DBD-MySQL \ perl-Config-Tiny \ perl-Log-Dispatch \ perl-Parallel-ForkManager \ perl-ExtUtils-CBuilder \ perl-ExtUtils-MakeMaker \ perl-CPAN 

 cd /opt tar zxvf mha4mysql-node-0.57.tar.gz cd mha4mysql-node-0.57 perl Makefile.PL make && make install 

 cd /opt tar zxvf mha4mysql-manager-0.57.tar.gz cd mha4mysql-manager-0.57 perl Makefile.PL make && make install 

 ssh-keygen -t rsa #一路按回车键 ssh-copy-id 192.168.126.20 ssh-copy-id 192.168.126.30 ssh-copy-id 192.168.126.40

 ssh-keygen -t rsa ssh-copy-id 192.168.126.30 ssh-copy-id 192.168.126.40

 ssh-keygen -t rsa ssh-copy-id 192.168.126.20 ssh-copy-id 192.168.126.40 

 ssh-keygen -t rsa ssh-copy-id 192.168.126.20 ssh-copy-id 192.168.126.30 

 cp -rp /opt/mha4mysql-manager-0.57/samples/scripts /usr/local/bin //拷贝后会有四个执行文件 ll /usr/local/bin/scripts/ master_ip_failover #自动切换时 VIP 管理的脚本 master_ip_online_change #在线切换时 vip 的管理 power_manager #故障发生后关闭主机的脚本 send_report #因故障切换后发送报警的脚本 

 cp /usr/local/bin/scripts/master_ip_failover /usr/local/bin

 vim /usr/local/bin/master_ip_failover #!/usr/bin/env perl use strict; use warnings FATAL => 'all'; use Getopt::Long; my ( $command, $ssh_user, $orig_master_host, $orig_master_ip, $orig_master_port, $new_master_host, $new_master_ip, $new_master_port ); #############################添加内容部分######################################### my $vip = '192.168.126.200'; #指定vip的地址 my $brdc = '192.168.126.255'; #指定vip的广播地址 my $ifdev = 'ens33'; #指定vip绑定的网卡 my $key = '1'; #指定vip绑定的虚拟网卡序列号 my $ssh_start_vip = "/sbin/ifconfig ens33:$key $vip"; #代表此变量值为ifconfig ens33:1 192.168.126.200 my $ssh_stop_vip = "/sbin/ifconfig ens33:$key down"; #代表此变量值为ifconfig ens33:1 192.168.126.200 down my $exit_code = 0; #指定退出状态码为0 #my $ssh_start_vip = "/usr/sbin/ip 
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：MySQL8.0.23版本的root密码重置最优解法_Mysql_
                                                                
下一篇：mysql-joins具体用法说明_Mysql_