Keepalived 在CentOS 7安装并配置监听MySQL双主

淡淡的烟草味﹌ 2024-03-22 22:09 77阅读 0赞

### keepalived安装 ###

MySQL双主配置请看这里：[https://tongyao.blog.csdn.net/article/details/132016200?spm=1001.2014.3001.5502][https_tongyao.blog.csdn.net_article_details_132016200_spm_1001.2014.3001.5502]

128、129两台服务器安装步骤相同，配置文件不同，下面有介绍。

1.安装相关依赖包，并下载keepalived安装包，解压，配置，编译

[root@128 ~]# cd /opt
    [root@128 opt]# yum -y install gcc openssl-devel popt-devel psmisc
    [root@128 opt]# wget https://www.keepalived.org/software/keepalived-2.2.7.tar.gz
    [root@128 opt]# tar -zxvf keepalived-2.2.7.tar.gz
    [root@128 opt]# cd keepalived-2.2.7
    [root@128 keepalived-2.2.7]# ./configure --prefix=/opt/keepalived-2.2.7
    [root@128 keepalived-2.2.7]# make && make install

2.将文件复制到对应目录下

[root@128 keepalived-2.2.7]# mkdir /etc/keepalived
    [root@128 keepalived-2.2.7]# cp keepalived/etc/keepalived/keepalived.conf.sample /etc/keepalived/keepalived.conf
    [root@128 keepalived-2.2.7]# cp keepalived/etc/init.d/keepalived /etc/init.d/
    [root@128 keepalived-2.2.7]# cp keepalived/etc/sysconfig/keepalived /etc/sysconfig/
    [root@128 keepalived-2.2.7]# cp bin/keepalived /usr/sbin/

3.新建/etc/keepalived/shutdown.sh文件，内容为：

#!/bin/bash
    #该脚本是在mysql服务出现异常时，将keepalived应用停止，从而使虚拟vip主机自动连接到另一台mysql上
    killall keepalived

执行授权，否则在MySQL出现异常时不会关闭keepalived：

chmod 777 /etc/keepalived/shutdown.sh

4.使用ifconfig命令查看下网卡名称，本机网卡名称为ens33  
![在这里插入图片描述][1abfe4eb22f44a679c82ba2080f305d0.png]  
5.修改128服务器/etc/keepalived/keepalived.conf配置文件，内容如下：

! Configuration File for keepalived
     
    global_defs {
       notification_email {
         acassen@firewall.loc
         failover@firewall.loc
         sysadmin@firewall.loc
       }
       notification_email_from Alexandre.Cassen@firewall.loc
       smtp_server 192.168.200.1
       smtp_connect_timeout 30
       router_id LVS_MASTER
       vrrp_skip_check_adv_addr
       vrrp_strict
       vrrp_garp_interval 0
       vrrp_gna_interval 0
    }
     
    vrrp_instance VI_1 {
        state MASTER
        #interface为刚才查到的本机网卡名称
        interface ens33
        #同一网段中同一组virtual_router_id值相同。不同组virtual_router_id值唯一。
        #如server-1、server-2为一组，virtual_router_id=51
        #server-3、server-4为一组，则virtual_router_id不能为51
        virtual_router_id 51
        #字数越大，优先级越高，master必须大于backup
        priority 100
        advert_int 1
        authentication {
            auth_type PASS
            auth_pass 1111
        }
        virtual_ipaddress {
           #该ip为虚拟出来的vip地址
           192.168.222.130
        }
    }
     
    #配置virtual_server  ip为上面配置的虚拟vip地址  端口为mysql的端口
    virtual_server 192.168.222.130 3306 {
        delay_loop 6
        lb_algo rr
        lb_kind NAT
        persistence_timeout 50
        protocol TCP
        #real_server 该配置为实际物理机ip地址 以及实际物理机mysql端口
        real_server 192.168.222.128 3306 {
            #当该ip 端口连接异常时，执行该脚本
            notify_down /etc/keepalived/shutdown.sh
            TCP_CHECK {
                #实际物理机ip地址
                connect_ip 192.168.222.128
                #实际物理机port端口
                connect_port 3306
                connect_timeout 3
                nb_get_retry 3
                delay_before_retry 3
            }
        }
    }

6.修改129服务器/etc/keepalived/keepalived.conf配置文件，与128的配置不同地方为real\_server、connect\_ip 两个配置，需要配置对应的实际主机ip，详细内容如下：

! Configuration File for keepalived
     
    global_defs {
       notification_email {
         acassen@firewall.loc
         failover@firewall.loc
         sysadmin@firewall.loc
       }
       notification_email_from Alexandre.Cassen@firewall.loc
       smtp_server 192.168.200.1
       smtp_connect_timeout 30
       router_id LVS_MASTER
       vrrp_skip_check_adv_addr
       vrrp_strict
       vrrp_garp_interval 0
       vrrp_gna_interval 0
    }
     
    vrrp_instance VI_1 {
        state BACKUP
        #interface为刚才查到的本机网卡名称
        interface ens33
        #同一网段中同一组virtual_router_id值相同。不同组virtual_router_id值唯一。
        #如server-1、server-2为一组，virtual_router_id=51
        #server-3、server-4为一组，则virtual_router_id不能为51
        virtual_router_id 51
        #字数越大，优先级越高，master必须大于backup
        priority 90
        advert_int 1
        authentication {
            auth_type PASS
            auth_pass 1111
        }
        virtual_ipaddress {
           #该ip为虚拟出来的vip地址
           192.168.222.130
        }
    }
     
    #配置virtual_server  ip为上面配置的虚拟vip地址  端口为mysql的端口
    virtual_server 192.168.222.130 3306 {
        delay_loop 6
        lb_algo rr
        lb_kind NAT
        persistence_timeout 50
        protocol TCP
        #real_server 该配置为实际物理机ip地址 以及实际物理机mysql端口
        real_server 192.168.222.129 3306 {
            #当该ip 端口连接异常时，执行该脚本
            notify_down /etc/keepalived/shutdown.sh
            TCP_CHECK {
                #实际物理机ip地址
                connect_ip 192.168.222.129
                #实际物理机port端口
                connect_port 3306
                connect_timeout 3
                nb_get_retry 3
                delay_before_retry 3
            }
        }
    }

详细配置参考[《Keepalived 安装和配置详解》][Keepalived]

7.将128、129服务器keepalived加入开机自启，并启动服务

[root@128 keepalived-2.2.7]# systemctl enable keepalived
    [root@128 keepalived-2.2.7]# systemctl start keepalived

8.启动后keepalived状态为：active(running)则正常

![在这里插入图片描述][d32e7590f56646cbb4dcf87dca7c48cd.png]  
9.启动后相当于虚拟出一个vip 192.168.222.130，可使用远程连接工具，连接该服务器，连接进去后使用ifconfig查看该虚拟vip实际上使用的实体服务器是129服务器。

![在这里插入图片描述][06a626b3188d4115b6fc6f6d0b7f41c0.png]  
10.将129服务器的keepalived应用停止，再次查看130服务ifconfig，可以看到，130服务器自动将实体机ip漂移到了128服务器上  
![在这里插入图片描述][cccc189ee9824884a0645972f058f11f.png]  
![在这里插入图片描述][ad946b90bbd4413baf53276c63de2aaa.png]  
至此，keepalived部署完成。

### mysql双主双活+keepalived高可用整体测试 ###

1.首先将128、129两台服务器mysql、keepalived应用全部启动，然后用mysql连接工具连接keepalived虚拟出来的192.168.222.130服务器

![在这里插入图片描述][26c9b22bd227407ebafa55ba4f0d46c7.png]  
2.再130数据库test\_db库t\_test表插入id=3，name=‘wangwu’

![在这里插入图片描述][1b767f3e3be242ef914a22000533f47d.png]  
3.此时可以查看128、129数据库，数据已同步

![在这里插入图片描述][45df83fc34604a5f83dffcc074991383.png]  
4.查看130服务器ifconfig实际使用的物理机为128，所以128服务器mysql为主数据库。

![在这里插入图片描述][063fc721cd9d48ab9def81fa0247359d.png]  
5.此时手动将128服务器mysql停止，keepalived检测到128服务3306端口连接失败，会执行/etc/keepalived/shutdown.sh脚本，将128服务器keepalived应用结束。

![在这里插入图片描述][a2190518e83247c58bc91a0fdef6fbf3.png]  
6.此时再连接130服务下，ifconfig查看，发现已经实际将物理机由128转移到129服务器上

![在这里插入图片描述][e0d5adb51a6f4cb395cbfd7ad0fa7be6.png]  
7.再使用mysql连接工具连接130的mysql，插入一条数据id=4，name=‘zhaoliu’，测试是否将数据存入129服务器mysql中

![在这里插入图片描述][4becef1d05394e008e2fa696cacb9857.png]  
8.查看129服务器mysql数据，数据已同步，说明keepalived搭建高可用成功，当128服务器mysql出现问题后keepalived自动漂移IP到实体机129服务器上，从而使129服务器mysql作为主数据库。

![在这里插入图片描述][9b90f8c5865a4cff82c5f61dac0b58a5.png]  
9.此时再启动128服务器mysql、keepalived应用

![在这里插入图片描述][d5ab6c863a10407eb9bc61db13605efb.png]  
10.查看128数据库t\_test表数据，数据已同步成功。

![在这里插入图片描述][ad26278608734043b5de01c712ce3374.png]  
11.如果漂移失败，可能是virtual\_router\_id在同网段内重复导致。可执行命令查看是否有其他ip使用

[root@128 keepalived-2.2.7]# tcpdump -i 网卡名 vrrp -n |grep virtual_router_id值
    #例如：
    [root@128 keepalived-2.2.7]# tcpdump -i eno16777736 vrrp -n |grep 51

至此，mysql双主双活+keepalived高可用部署并测试完成。

文章参考：[https://blog.csdn.net/a360284634/article/details/89892028][https_blog.csdn.net_a360284634_article_details_89892028]，并稍做修改。

其他一些配置详情：[https://www.cnblogs.com/cyleon/p/10338822.html][https_www.cnblogs.com_cyleon_p_10338822.html]

[https_tongyao.blog.csdn.net_article_details_132016200_spm_1001.2014.3001.5502]: https://tongyao.blog.csdn.net/article/details/132016200?spm=1001.2014.3001.5502
[1abfe4eb22f44a679c82ba2080f305d0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/cc21b88e64d34332a8a57fb927fb5cc4.png
[Keepalived]: https://blog.csdn.net/D1179869625/article/details/126198495
[d32e7590f56646cbb4dcf87dca7c48cd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c6ff353af5374028ac21cd4a34dd186c.png
[06a626b3188d4115b6fc6f6d0b7f41c0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/f72b3a83f75e4fb8af8c1b5290556bb9.png
[cccc189ee9824884a0645972f058f11f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/593b4381adab490e88f50063b2aa6b60.png
[ad946b90bbd4413baf53276c63de2aaa.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/38c510aa236b466398a4aaa672434d94.png
[26c9b22bd227407ebafa55ba4f0d46c7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/1ebdf0cc1d4e4b78a0745649721374fb.png
[1b767f3e3be242ef914a22000533f47d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c3a6adb7e0aa4019b651ed57f8ffcaaf.png
[45df83fc34604a5f83dffcc074991383.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/50b3846f0e874da0bd9097ebf7e222a5.png
[063fc721cd9d48ab9def81fa0247359d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/76a80420abf94f88bb4eef922858b35a.png
[a2190518e83247c58bc91a0fdef6fbf3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/a991b658576941ad9e6ba4a8041f2f9d.png
[e0d5adb51a6f4cb395cbfd7ad0fa7be6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/26dc9619282f4183b1bce6317ca19a36.png
[4becef1d05394e008e2fa696cacb9857.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/10ec634f084340aabe4f724a2b71a390.png
[9b90f8c5865a4cff82c5f61dac0b58a5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/b22b104fcb6541db95c991d4e815b679.png
[d5ab6c863a10407eb9bc61db13605efb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/6d281094c33f46c385fc88119720eca2.png
[ad26278608734043b5de01c712ce3374.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/1e87953df9ad4172baf30b6854b8243c.png
[https_blog.csdn.net_a360284634_article_details_89892028]: https://blog.csdn.net/a360284634/article/details/89892028
[https_www.cnblogs.com_cyleon_p_10338822.html]: https://www.cnblogs.com/cyleon/p/10338822.html