MHA配備虛擬ip

2024-09-07 22:12:36

字體：大中小

來源：轉載

供稿：網友

虛擬ip飄逸
說到Failover，通常有兩種方式：一種是虛擬IP地址，一種是全局配置文件。
MHA并沒有限定使用哪一種方式，而是讓用戶自己選擇，虛擬IP地址的方式會牽扯到其它的軟件，這里就不贅述了
上篇文章搭建mha+keepalive就是通過keepalive來控制虛擬ip，本片文章在介紹一種虛擬ip的方式

配置虛擬ip
采用ifconfig的方式
/sbin/ifconfig eth0:1 192.168.6.66/24
刪除VIP:
/sbin/ifconfig eth0:1 down
網上找了一個master_ip_failover腳本就是用此方法更改VIP:
[root@localhost app1]# more /usr/local/bin/master_ip_online_change_script
#!/usr/bin/env perl
use strict;
use warnings FATAL => 'all';

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

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,

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=po
rt/n";
}

將此腳本復制兩次到/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.主庫（115）添加一個vip
[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

2.關閉主庫mysql
[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

3 查看newmaster（114）的ip                                                    ----vip已飄到new master上了
[root@node1 ~]# ip a

4 重構mysql.重啟mha監控
5 關閉114mysql，vip飄回115上去了

（編輯：武林網）

上一篇：lower_case_table_names參數設定處理Error Code

下一篇：MyCat分庫分表--實踐07--按日期天