MHA配置

1、现有集群架构

 

2、SSH互信连接

 

 

 

 

 

3、MHA noder安装

主服务器，从服务器，MHA manager都需要安装mha noder。

MHA Node 具有执行以下操作的脚本和依赖 perl 模块。

• save_binary_logs：保存和复制 dead master 的二进制日志
• apply_diff_relay_logs：识别差异中继日志事件并应用所有必要的日志事件
• purge_relay_logs：清除中继日志文件

 

yum install -y perl-DBD-MySQL

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

 

 

4、MHA manager安装

yum install -y perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager

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

 

5、MHA manager配置文件

5.1、全局配置文件

/etc/masterha_default.cnf

[server default]
user=root
password=rootpass
ssh_user=root
master_binlog_dir= /var/lib/mysql
remote_workdir=/data/log/masterha
secondary_check_script= masterha_secondary_check -s remote_host1 -s remote_host2
ping_interval=3
master_ip_failover_script=/script/masterha/master_ip_failover
shutdown_script= /script/masterha/power_manager
report_script= /script/masterha/send_master_failover_mail

 

 

5.2、第一套mysql的配置文件

/etc/app1.conf

[server default]
manager_workdir=/var/log/masterha/app1
manager_log=/var/log/masterha/app1/app1.log

[server1]
hostname=host1
candidate_master=1

[server2]
hostname=host2
candidate_master=1

[server3]
hostname=host3

[server4]
hostname=host4
no_master=1

 

 

 

 

5.3、第二套mysql的配置文件

/etc/app2.conf

 

[server default]
manager_workdir=/var/log/masterha/app2
manager_log=/var/log/masterha/app2/app2.log

[server1]
hostname=host11
candidate_master=1

[server2]
hostname=host12
candidate_master=1

[server3]
hostname=host13

[server4]
hostname=host14
no_master=1

 

5.4、二进制日志服务器

在 binlog 部分，您可以定义mysqlbinlog streaming servers。当 MHA 进行基于 GTID 的故障转移时，MHA 检查 binlog servers，如果 binlog servers 领先于其他 slave，MHA 在恢复之前将差异 binlog events 应用到新的 master。当 MHA 进行基于非 GTID 的（传统）故障转移时，MHA 会忽略 binlog 服务器。

 

[server default]
user=root
password=mysqlpass
manager_workdir=/var/log/masterha/app1
manager_log=/var/log/masterha/app1/app1.log
remote_workdir=/var/log/masterha/app1

[server1]
hostname=host1

[server2]
hostname=host2

[server3]
hostname=host3

[binlog1]
hostname=binlog_host1

[binlog2]
hostname=binlog_hos

 

5.5、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 = 'x.x.x.x';
my $ssh_start_vip = "systemctl start keepalived";
my $ssh_stop_vip = "systemctl  stop  keepalived";

GetOptions(
    'command=s'          => \$command,
    'ssh_user=s'         => \$ssh_user,
    'orig_master_host=s' => \$orig_master_host,
    'orig_master_ip=s'   => \$orig_master_ip,
    'orig_master_port=i' => \$orig_master_port,
    'new_master_host=s'  => \$new_master_host,
    'new_master_ip=s'    => \$new_master_ip,
    'new_master_port=i'  => \$new_master_port,
);

exit &main();

sub main {

    print "\n\nIN SCRIPT TEST====$ssh_stop_vip==$ssh_start_vip===\n\n";

    if ( $command eq "stop" || $command eq "stopssh" ) {

        my $exit_code = 1;
        eval {
            print "Disabling the VIP on old master: $orig_master_host \n";
            &stop_vip();
            $exit_code = 0;
        };
        if ($@) {
            warn "Got Error: $@\n";
            exit $exit_code;
        }
        exit $exit_code;
    }
    elsif ( $command eq "start" ) {

        my $exit_code = 10;
        eval {
            print "Enabling the VIP - $vip on the new master - $new_master_host \n";
            &start_vip();
            $exit_code = 0;
        };
        if ($@) {
            warn $@;
            exit $exit_code;
        }
        exit $exit_code;
    }
    elsif ( $command eq "status" ) {
        print "Checking the Status of the script.. OK \n";
        exit 0;
    }
    else {
        &usage();
        exit 1;
    }
}
sub start_vip() {
    `ssh $ssh_user\@$new_master_host \" $ssh_start_vip \"`;
}
#A simple system call that disable the VIP on the old_master
sub stop_vip() {
    `ssh $ssh_user\@$orig_master_host \" $ssh_stop_vip \"`;
}

sub usage {
    print
    "Usage: master_ip_failover --command=start|stop|stopssh|status --orig_master_host=host --orig_master_ip=ip --orig_master_port=port --new_master_host=host --new_master_ip=ip --new_master_port=port\n";
}

 

6、keepalived配置

6.1、keepalived安装

yum install -y keepalived

 

6.2、keepalived配置

/etc/keepalived/keepalived.conf

global_defs {
   router_id mysql_test
   vrrp_skip_check_adv_addr
   vrrp_garp_interval 0
   vrrp_gna_interval 0
}


vrrp_script chk_mysql {
   script "/etc/keepalived/mysqlchk.sh" #自定义mysql健康检查脚本
   interval 2
   weight 2

}

vrrp_instance VI_1 {
    state BACKUP
    interface eth0
    virtual_router_id 113
    priority 200
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
       x.x.x.x/24 #设置高可用虚拟VIP
    }
   track_script {
        chk_mysql
   }
}

 

 

6.3、mysqlchk.sh

#!/bin/bash
ss -tnl|grep 3306 >/dev/null 2>&1

if [ $? -eq 0 ]
then
    echo " mysql is alived "  
    exit 0
else
    echo " mysql is dead "
    systemctl stop keepalived
    exit 2
fi

 

 

6.4、启动 Keepalived 服务并设置开机自启：

 

systemctl start keepalived

systemctl enable keepalived