Keepalived+Mysql双主

2341

一、安装keepalived
#安装keepalived源码安装的依赖包

1 2	yum -y install openssl openssl-devel yum -y install popt-devel

#源码编译安装keepalived

1 2 3 4

tar xf keepalived-1.2.7.tar.gz cd keepalived-1.2.7 ./configure --prefix=/usr/local/keepalived make && make install

#拷贝keepavlied的一些文件到相关目录中

1 2 3 4 5

mkdir /etc/keepalived cp /usr/local/keepalived/sbin/keepalived     /usr/sbin/ cp /usr/local/keepalived/etc/sysconfig/keepalived     /etc/sysconfig/ cp /usr/local/keepalived/etc/rc.d/init.d/keepalived   /etc/init.d/ cp/usr/local/keepalived/etc/keepalived/keepalived.conf    /etc/keepalived/

二、修改Keepalived配置文件：

(1) Server1:

1	vi /etc/keepalived/keepalived.conf

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

! Configuration File for keepalived global_defs { router_id mysqlmha1 } vrrp_script check_run { script "/etc/keepalived/check_mysql.sh"  # Mysql监测脚本路径 interval 5 } vrrp_instance VI_1 {     state MASTER     interface eth0     virtual_router_id 51     priority 100     advert_int 1     authentication {         auth_type PASS         auth_pass 1111     }    track_script { check_run    }    virtual_ipaddress {         192.168.235.16 dev eth0     } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

virtual_server 192.168.235.16 3306 {     delay_loop 6   #每个6秒检查一次real_server状态     lb_algo rr   #LVS算法，用不到，我们就关闭了    lb_kind DR  #LVS模式，如果不关闭，备用服务器不能通过VIP连接主MySQL     persistence_timeout 20 #同一IP的连接60秒内被分配到同一台真实服务器     protocol TCP     real_server 192.168.235.149 3306 {     weight 3     TCP_CHECK { connect_timeout 3  #连接超时   nb_get_retry 3   #重试次数 delay_before_retry 3  #间隔时间 connect_port 3306        } }

(2)Server 2:

1	vi /etc/keepalived/keepalived.conf

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

! Configuration File for keepalived global_defs { router_id mysqlmha1 } vrrp_script check_run { script "/etc/keepalived/check_mysql.sh" interval 10 } vrrp_instance VI_1 {     state BACKUP     interface eth0     virtual_router_id 51     priority 90     advert_int 1     authentication {         auth_type PASS         auth_pass 1111     }    track_script { check_run }     virtual_ipaddress {

        192.168.235.16 dev eth0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57

} } virtual_server 192.168.235.16 3306 {     delay_loop 6     #lb_algo rr     #lb_kind DR     persistence_timeout 20     protocol TCP     real_server 192.168.235.134 3306 {         weight 3   TCP_CHECK {   connect_timeout 3    nb_get_retry 3   delay_before_retry 3   connect_port 3306         }     } (3)创建mysql监测脚本   vi /etc/keepalived/check_mysql.sh #!/bin/bash source /etc/profile MYSQL=/usr/local/mysql/bin/mysql MYSQL_HOST=127.0.0.1 MYSQL_USER=root #用户名 MYSQL_PASSWORD=redhat #密码 CHECK_TIME=3 #mysql is working MYSQL_OK is 1 , mysql down MYSQL_OK is 0 MYSQL_OK=1 function check_mysql_helth (){     $MYSQL -h $MYSQL_HOST -u $MYSQL_USER -p${MYSQL_PASSWORD} -e "show status;" >/dev/null 2>&1     if [ $? = 0 ] ;then     MYSQL_OK=1     else     MYSQL_OK=0     fi     return $MYSQL_OK } while [ $CHECK_TIME -ne 0 ] do     let "CHECK_TIME -= 1"     check_mysql_helth if [ $MYSQL_OK = 1 ] ; then     CHECK_TIME=0     exit 0 fi if [ $MYSQL_OK -eq 0 ] &&  [ $CHECK_TIME -eq 0 ] then     /etc/init.d/keepalived stop     exit 1 fi sleep 1 done

1 2	chmod 755 /etc/keepalived/killkeepalived.sh            #加执行权限 chkconfig keepalived on                        #设置开机自动启动

三、测试
Server1:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

[iyunv@test ~]# ip addr show 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN     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 state UP qlen 1000     link/ether 00:0c:29:72:21:e8 brd ff:ff:ff:ff:ff:ff     inet 192.168.235.149/24 brd 192.168.235.255 scope global eth0     inet 192.168.235.16/32 scope global eth0     inet6 fe80::20c:29ff:fe72:21e8/64 scope link        valid_lft forever preferred_lft forever            关闭server1的mysql，在server2上查看ip是否漂移       server1: service mysql stop   server2: ip addr show