MHA设置mysql的主从及遇到的坑

$ cp -ra /root/mha4mysql-manager-0.57/samples/scripts /usr/local/bin

[server default]
 #manager日志
manager_log=/etc/masterha/manager.log
#manager工作目录
manager_workdir=/etc/masterha
#master保存binlog的位置
master_binlog_dir=/usr/local/mysql/data
#设置自动failover时候的切换脚本 后边来改
master_ip_failover_script=/usr/local/bin/master_ip_failover
#设置mysql中root用户的密码
ssh_user=root
#从库访问主库的账号
repl_user=slave
#从库访问主库的密码
repl_password=123456
#mha_manager访问主库的账号
user=mha
#mha_manager访问主库的密码
password=123456
# 主节点
[server1]
hostname=192.168.100.151
port=3306
candidate_master=1
#从节点1
[server2]
candidate_master=1
hostname=192.168.100.152
port=3306
#从节点2
[server3]
hostname=192.168.100.158
port=3306

$ 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.100.190';  
my $ssh_start_vip ="sudo systemctl start keepalived";
my $ssh_stop_vip ="sudo 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 SCRIPTTEST====$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 VIPon 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";
}

$ chmod +x /usr/local/bin/master_ip_failover

$  masterha_check_ssh -conf=/etc/masterha/app1.cnf
#返回 All SSH connection tests passed successfully.表示正常

$  masterha_check_repl -conf=/etc/masterha/app1.cnf
#返回 MySQL Replication Health is OK. 表示正常

$ nohup masterha_manager --conf=/etc/masterha/app1.cnf --remove_dead_master_conf --ignore_last_failover < /dev/null > /var/log/masterha/app1/manager.log 2>&1 &

$ masterha_check_status --conf=/etc/mha_master/app1.cnf

$ masterha_check_status --conf=/etc/masterha/app1.cnf