MySQL+keepalived高可用自动切换

不念不忘少年蓝@ 2022-05-30 11:47 178阅读 0赞

Keepalived安装配置：

\[root@localhost ~\]\# wget http://www.keepalived.org/software/keepalived-1.2.13.tar.gz

tar zxf keepalived-1.2.13.tar.gz

cd keepalived-1.2.13

yum install gcc gcc-c++

yum install kernel-devel  -y

\[root@localhost keepalived-1.2.13\]\# ./configure --with-kernel-dir=/usr/src/kernels/2.6.32-696.20.1.el6.x86\_64/

&&make && make install

\[root@localhost keepalived-1.2.13\]\# DIR=/usr/local/

\[root@localhost keepalived-1.2.13\]\#     cp /usr/local/etc/rc.d/init.d/keepalived /etc/rc.d/init.d/

\[root@localhost keepalived-1.2.13\]\# cp /usr/local/etc/sysconfig/keepalived /etc/sysconfig/ && mkdir -p /etc/keepalived

\[root@localhost keepalived-1.2.13\]\# cp /usr/local/sbin/keepalived /usr/sbin/

修改Master服务器上keepalived.conf配置如下，vi /etc/keepalived/keepalived.conf

! Configuration File for keepalived  
global\_defs \{  
  notification\_email \{  
  251469868@qq.com  
   \}  
  notification\_email\_from 251469868@qq.com  
  smtp\_server 127.0.0.1  
   smtp\_connect\_timeout 30  
   router\_id LVS\_DEVEL  
\}   
\#VIP1  
vrrp\_instance VI\_1 \{  
   state MASTER  
   interface eth0  
   lvs\_sync\_daemon\_inteface eth0  
   virtual\_router\_id 151  
   priority 100  
   advert\_int 5  
   \#nopreempt  
   authentication \{  
       auth\_type PASS  
       auth\_pass 2222  
    \}  
   virtual\_ipaddress \{  
        192.168.227.100  
    \}  
\}  
virtual\_server 192.168.227.100 3306 \{  
    delay\_loop 6  
    lb\_algo wrr  
    lb\_kind DR  
    persistence\_timeout 60  
    protocol TCP  
    real\_server 192.168.227.138 3306 \{  
        weight 100  
        notify\_down /data/sh/msyql.sh   
        TCP\_CHECK \{  
         connect\_timeout 10  
         nb\_get\_retry 3  
         delay\_before\_retry 3  
         connect\_port 3306  
         \}  
    \}  
\}

\[root@localhost keepalived\]\# /etc/init.d/keepalived restart  
停止 keepalived：                                          \[失败\]  
正在启动 keepalived：                                      \[确定\]  
\[root@localhost keepalived\]\# /etc/init.d/keepalived restart  
停止 keepalived：                                          \[确定\]  
正在启动 keepalived：                                      \[确定\]  
\[root@localhost keepalived\]\# ps -ef |grep keep  
root      46101  30792  0 07:57 pts/0    00:00:00 vi keepalived.conf  
root      46140      1  0 07:59 ?        00:00:00 keepalived -D  
root      46142  46140  0 07:59 ?        00:00:00 keepalived -D  
root      46143  46140  0 07:59 ?        00:00:00 keepalived -D

root      46148  30792  0 07:59 pts/0    00:00:00 grep keep

\[root@localhost keepalived\]\# tail -fn100 /var/log/messages

\[root@localhost keepalived\]\# cd   
\[root@localhost ~\]\# modprobe ip\_vs  
\[root@localhost ~\]\# lsmod |grep ip\_vs  
ip\_vs                 125694  1   
libcrc32c               1246  1 ip\_vs  
ipv6                  334932  294 ip\_vs,ip6t\_REJECT,nf\_conntrack\_ipv6,nf\_defrag\_ipv6  
\[root@localhost ~\]\# /etc/init.d/keepalived restart   
停止 keepalived：                                          \[确定\]  
正在启动 keepalived：                                      \[确定\]  
\[root@localhost ~\]\# tail -fn 10 /var/log/messages

Mysql 从服务器配置keepalived.conf跟master 一样，只需要把Realserver IP修改成

real\_server 192.168227.139;优先级从100改为90即可

在master、slave数据库上创建/data/sh/mysql.sh脚本，内容为：

pkill keepalived

然后分别重启两台数据库上keepalive服务即可，最后测试停止master mysql 服务，是否会自动切换

到backup上