【Mysql】MHA配置虛擬ip

小亮520cl發表於2016-08-04
MySql

虛擬ip飄逸

  1. 說到Failover，通常有兩種方式：一種是虛擬IP地址，一種是全域性配置檔案。
  2. MHA並沒有限定使用哪一種方式，而是讓使用者自己選擇，虛擬IP地址的方式會牽扯到其它的軟體，這裡就不贅述了
  3. 上篇文章搭建mha+keepalive就是透過keepalive來控制虛擬ip，本片文章在介紹一種虛擬ip的方式

配置虛擬ip

  1. 採用ifconfig的方式
  2. /sbin/ifconfig eth0:1 192.168.6.66/24
刪除VIP:
  1. /sbin/ifconfig eth0:1 down
網上找了一個master_ip_failover指令碼就是用此方法更改VIP:
  1. [root@localhost app1]# more /usr/local/bin/master_ip_online_change_script
  2. #!/usr/bin/env perl
  3. use strict;
  4. use warnings FATAL => 'all';

  6. use Getopt::Long;

  8. my (
  9.     $command, $ssh_user, $orig_master_host, $orig_master_ip,
  10.     $orig_master_port, $new_master_host, $new_master_ip, $new_master_port
  11. );

  13. my $vip = '192.168.6.66/24'; # Virtual IP
  14. my $key = "1";
  15. my $ssh_start_vip = "/sbin/ifconfig eth0:$key $vip";
  16. my $ssh_stop_vip = "/sbin/ifconfig eth0:$key down";

  18. GetOptions(
  19.     'command=s' => \$command,
  20.     'ssh_user=s' => \$ssh_user,
  21.     'orig_master_host=s' => \$orig_master_host,
  22.     'orig_master_ip=s' => \$orig_master_ip,
  23.     'orig_master_port=i' => \$orig_master_port,
  24.     'new_master_host=s' => \$new_master_host,
  25.     'new_master_ip=s' => \$new_master_ip,
  26.     'new_master_port=i' => \$new_master_port,
  27. );

  29. exit &main();

  31. sub main {

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

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

  37.         # $orig_master_host, $orig_master_ip, $orig_master_port are passed.
  38.         # If you manage master ip address at global catalog database,
  39.         # invalidate orig_master_ip here.
  40.         my $exit_code = 1;
  41.         eval {
  42.             print "Disabling the VIP on old master: $orig_master_host \n";
  43.             &stop_vip();
  44.             $exit_code = 0;
  45.         };
  46.         if ($@) {
  47.             warn "Got Error: $@\n";
  48.             exit $exit_code;
  49.         }
  50.         exit $exit_code;
  51.     }
  52.     elsif ( $command eq "start" ) {

  54.         # all arguments are passed.
  55.         # If you manage master ip address at global catalog database,
  56.         # activate new_master_ip here.
  57.         # You can also grant write access (create user, set read_only=0, etc) here.
  58.         my $exit_code = 10;
  59.         eval {
  60.             print "Enabling the VIP - $vip on the new master - $new_master_host \n";
  61.             &start_vip();
  62.             $exit_code = 0;
  63.         };
  64.         if ($@) {
  65.             warn $@;
  66.             exit $exit_code;
  67.         }
  68.         exit $exit_code;
  69.     }
  70.     elsif ( $command eq "status" ) {
  71.         print "Checking the Status of the script.. OK \n";
  72.         `ssh $ssh_user\@cluster1 \" $ssh_start_vip \"`;
  73.         exit 0;
  74.     }
  75.     else {
  76.         &usage();
  77.         exit 1;
  78.     }
  79. }

  81. # A simple system call that enable the VIP on the new master
  82. sub start_vip() {
  83.     `ssh $ssh_user\@$new_master_host \" $ssh_start_vip \"`;
  84. }
  85. # A simple system call that disable the VIP on the old_master
  86. sub stop_vip() {
  87.     `ssh $ssh_user\@$orig_master_host \" $ssh_stop_vip \"`;
  88. }

  90. sub usage {
  91.     print
  92.     "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=po
  93. rt\n";
  94. }

將此指令碼複製兩次到/usr/local/bin, 分別命名為master_ip_failover 和master_ip_online_change_script

然後將/etc/app1.cnf 中下面兩行註釋去掉： 

master_ip_failover_script=/usr/local/bin/master_ip_failover
master_ip_online_change_script=/usr/local/bin/master_ip_online_change_script


實驗

  1. 1.主庫（115）新增一個vip

  1. [root@node2 .ssh]# /sbin/ifconfig eth0:1 192.168.6.66/24
    [root@node2 .ssh]# ip a
    1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue 
        link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
        inet 127.0.0.1/8 scope host lo
        inet6 ::1/128 scope host 
           valid_lft forever preferred_lft forever
    2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000
        link/ether 08:00:27:03:1b:a1 brd ff:ff:ff:ff:ff:ff
        inet 192.168.6.115/24 brd 192.168.6.255 scope global eth0
        inet 192.168.6.66/24 brd 192.168.6.255 scope global secondary eth0:1
        inet6 fe80::a00:27ff:fe03:1ba1/64 scope link 
           valid_lft forever preferred_lft forever

  1. 2.關閉主庫mysql

  1. [root@node2 .ssh]# /etc/init.d/mysqld stop
    Stopping mysqld:                                           [  OK  ]
    [root@node2 .ssh]# ip a
    1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue 
        link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
        inet 127.0.0.1/8 scope host lo
        inet6 ::1/128 scope host 
           valid_lft forever preferred_lft forever
    2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000
        link/ether 08:00:27:03:1b:a1 brd ff:ff:ff:ff:ff:ff
        inet 192.168.6.115/24 brd 192.168.6.255 scope global eth0           ---vip飄走了
        inet6 fe80::a00:27ff:fe03:1ba1/64 scope link 
           valid_lft forever preferred_lft forever

  1. 3 檢視newmaster（114）的ip                                                    ----vip已飄到new master上了

  1. [root@node1 ~]# ip a
    1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue 
        link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
        inet 127.0.0.1/8 scope host lo
        inet6 ::1/128 scope host 
           valid_lft forever preferred_lft forever
    2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000
        link/ether 08:00:27:7a:c6:9c brd ff:ff:ff:ff:ff:ff
        inet 192.168.6.114/24 brd 192.168.6.255 scope global eth0
        inet 192.168.6.66/24 brd 192.168.6.255 scope global secondary eth0:1
        inet6 fe80::a00:27ff:fe7a:c69c/64 scope link 
           valid_lft forever preferred_lft forever
  2. 4 重構mysql.重啟mha監控
  3. 5 關閉114mysql，vip飄回115上去了




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29096438/viewspace-2122973/，如需轉載，請註明出處，否則將追究法律責任。

相關文章