keepalived+LVS+Mycat+MySQL双主及主从高可用负载均衡集群

浅浅的花香味﹌ 2022-05-22 11:15 290阅读 0赞

系统集群架构图如下：

![70][]

一、部署90主机和77主机的MySQL主主配置和90主机和89主机的MySQL主从配置

详情请见（

MySQL主主同步：https://blog.csdn.net/baidu\_38432732/article/details/80773634

MySQL主从同步：https://blog.csdn.net/baidu\_38432732/article/details/80653873

）

二、部署mycat的读写分离控制，详情请见（https://blog.csdn.net/baidu\_38432732/article/details/80708847）

三、配置keepalived+LVS对mycat的高可用及负载均衡集群

1、在117主机和116主机上分别安装keepalived+LVS

\[root@mysql ~\]\# yum -y install keepalived ipvsadm  
安装完后修改配置文件：

117Master主机

\[root@localhost ~\]\# vim /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 127.0.0.1  
   smtp\_connect\_timeout 30  
   router\_id LVS\_DEVEL  
   vrrp\_skip\_check\_adv\_addr  
\#   vrrp\_strict  
   vrrp\_garp\_interval 0  
   vrrp\_gna\_interval 0  
\}

vrrp\_instance VI\_1 \{  
    state MASTER  \#（从的改成backup）  
    interface ens33  
    virtual\_router\_id 51   
    priority 100  \#（从主机的值低于100即可）  
    advert\_int 1  
    authentication \{  
        auth\_type PASS  
        auth\_pass 1111  
    \}  
    virtual\_ipaddress \{  
        192.168.1.120  
    \}  
\}

virtual\_server 192.168.1.120 8066 \{  
    delay\_loop 6  
    lb\_algo rr  
    lb\_kind DR  
    persistence\_timeout 0 \#注意改成0，否则会出现异常  
    protocol TCP

real\_server 192.168.1.130 8066 \{  
        weight 1  
        SSL\_GET \{  
            url \{  
              path /  
              digest ff20ad2481f97b1754ef3e12ecd3a9cc  
            \}  
            url \{  
              path /mrtg/  
              digest 9b3a0c85a887a256d6939da88aabd8cd  
            \}  
            connect\_timeout 3  
            nb\_get\_retry 3  
            delay\_before\_retry 3  
            connect\_port 8066  
        \}  
    \}  
    real\_server 192.168.1.76 8066 \{  
        weight 1  
        SSL\_GET \{  
            url \{  
              path /  
              digest ff20ad2481f97b1754ef3e12ecd3a9cc  
            \}  
            url \{  
              path /mrtg/  
              digest 9b3a0c85a887a256d6939da88aabd8cd  
            \}  
            connect\_timeout 3  
            nb\_get\_retry 3

delay\_before\_retry 3  
            connect\_port 8066  
        \}  
    \}  
\}

2、在130主机和76主机上分别执行以下脚本：

\[root@mysql ~\]\# vim realserver.sh

\#!/bin/bash  
\#description: Config realserver

VIP=192.168.1.120

/etc/rc.d/init.d/functions

case "$1" in  
start)  
       /sbin/ifconfig lo:0 $VIP netmask 255.255.255.255 broadcast $VIP  
       /sbin/route add -host $VIP dev lo:0  
       echo "1" >/proc/sys/net/ipv4/conf/lo/arp\_ignore  
       echo "2" >/proc/sys/net/ipv4/conf/lo/arp\_announce  
       echo "1" >/proc/sys/net/ipv4/conf/all/arp\_ignore  
       echo "2" >/proc/sys/net/ipv4/conf/all/arp\_announce  
       sysctl -p >/dev/null 2>&1  
       echo "RealServer Start OK"  
       ;;  
stop)  
       /sbin/ifconfig lo:0 down  
       /sbin/route del $VIP >/dev/null 2>&1  
       echo "0" >/proc/sys/net/ipv4/conf/lo/arp\_ignore  
       echo "0" >/proc/sys/net/ipv4/conf/lo/arp\_announce  
       echo "0" >/proc/sys/net/ipv4/conf/all/arp\_ignore  
       echo "0" >/proc/sys/net/ipv4/conf/all/arp\_announce  
       echo "RealServer Stoped"  
       ;;  
\*)  
       echo "Usage: $0 \{start|stop\}"  
       exit 1  
esac

exit 0

两台服务器上执行一样的，然后执行以下，命令验证是否执行成功，当两台主机都出现以下则成功

![70 1][]

3、回到117和116主机启动keepalived

\[root@localhost ~\]\# service keepalived start  
Redirecting to /bin/systemctl start keepalived.service  
此时验证后虚拟IP在Master主机上，具体那个获取IP要看先启动那个

![70 2][]

![70 3][]

至此已经部署完毕

四、终极验证

1、部署环境将所有的数据库建表并插入数据

![70 4][]

2、为了方便验证现在统一用navicat登陆数据库

VIP访问后得到所有的数据

![70 5][]

情景一：停掉90Master主机，验证数据是否正常显示

![70 6][]

![70 7][]

数据可以正常访问

![70 8][]

情景二：启动90主机，停掉77的Master主机

![70 9][]

![70 10][]

![70 11][]

![70 12][]

此时我们用120IP访问：还可以获取数据

![70 13][]

情景一、二：证明两个数数据库可以达到高可用

情景三：关闭一个130mycat服务

![70 14][]

![70 15][]![70 16][]

第一遍访问报错

![70 17][]

第二遍访问：

![70 18][]

重复多少点几次发现是一边正常一遍不正常说明起到负载作用而且是权重比相等的负载均衡

情景三：我们停止任何一个keepalived都可以访问数据库数据

情景四：验证读写分离

构造环境，在从服务器上插入数据，以便数据读取来区分

刚开始是如下数据

![70 19][]

现插入数据如下：

![70 20][]此时查看从服务器数据如下：

![70 21][]

则此时直接访问主数据库无法看到刚插入的数据，但用120IP访问后就可以看到刚插入的数据

![70 22][]

![70 23][]

[70]: /images/20220522/9e62ede699974775b5f3158fe8ed2f8a.png
[70 1]: /images/20220522/26081504df504f35be240af32e9d1496.png
[70 2]: /images/20220522/58cfb771deab4eb1af63396b3a3a9573.png
[70 3]: /images/20220522/16bbfeefd3f4431d800b53d57a9d03ef.png
[70 4]: /images/20220522/39dc3e24e3f3493b866e6e7e8b5ee8f7.png
[70 5]: /images/20220522/d91ee3eea06940b39548c7d2ff5691d8.png
[70 6]: /images/20220522/71a678a8027548a3a6231b79e0e0bbe9.png
[70 7]: /images/20220522/b63606941aff451294b7ce6aa854c62e.png
[70 8]: /images/20220522/8bd45330788b4980a3d55e4154cc8e9e.png
[70 9]: /images/20220522/921c09e8d8cd4502995877a4146c16a9.png
[70 10]: /images/20220522/ab99e1bb77a44738b13c463f34a99f2e.png
[70 11]: /images/20220522/b21134dbc09c466ab815af0d461eb00e.png
[70 12]: /images/20220522/9c83b4a32e8d4c72b00d14ddfccbd068.png
[70 13]: /images/20220522/3f862fbee3004296bab5310b6525aca6.png
[70 14]: /images/20220522/d4a6c94ca4e84aacb63e80a3c26d6f92.png
[70 15]: https://img-blog.csdn.net/20180622200616956?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 16]: /images/20220522/bf35788bf36746549d9e8cfda941d05f.png
[70 17]: /images/20220522/2f49c3aec94e47a69f8334852b73acc1.png
[70 18]: /images/20220522/89afd181cb0a432e89b579861ddf1dd5.png
[70 19]: /images/20220522/30cfd0561aaa402098c6cbc4bfb718cf.png
[70 20]: /images/20220522/b370732f848f4a01a9d30d0bed46aa1f.png
[70 21]: /images/20220522/3024bb95bfed42f58d3bb5371b8df4c6.png
[70 22]: /images/20220522/86c8dc6c75e14eb29f2f333b4a9a1ace.png
[70 23]: /images/20220522/8fa649f45a654815841964daa8b32079.png