MySQL主主+Keepalived+LVS高可用（三）：单点写入、读负载均衡

最新推荐文章于 2024-08-12 00:41:54 发布
最新推荐文章于 2024-08-12 00:41:54 发布
阅读量99 收藏
点赞数
文章标签： 网络 数据库

方案简介

本方案采用 keepalived 中的sorry_server 来实现写入数据库为单点的需求，读负载均衡通过 lvs 实现，读能自由的实现负载均衡和故障切换。本方案实现的功能是当网络有问题、 mysql 有问题、服务器宕机、 keepalived 服务停止后,服务器能自动跳转到备用机，当主服务器服务
启动起来后会自动切换回来。

1)    KeepAlived配置

Master A

~]# cat /etc/keepalived/keepalived.conf

! Configuration File for keepalived

 

! Configuration File for keepalived

 

global_defs {

   notification_email {

     jixiang.yu@trekiz.com

   }

   notification_email_from Alexandre.Cassen@firewall.loc

   smtp_server 127.0.0.1

   smtp_connect_timeout 30

   router_id MySQL_HA

}

 

vrrp_instance MySQL-HA{

    state MASTER

    interface eth1

    virtual_router_id 51

    priority 100

    advert_int 1

    authentication {

        auth_type PASS

        auth_pass 1111

    }

    virtual_ipaddress {

        192.168.56.111

                192.168.56.112

    }

}

virtual_server 192.168.56.111 3306{

    delay_loop 3

    lb_algo rr

    lb_kind DR

    persistence_timeout 20

    protocol TCP

    sorry_server 192.168.56.102 3306

    real_server 192.168.56.101 3306{

        weight 3

        TCP_CHECK {

            connect_timeout 10

            nb_get_retry 3

            delay_before_retry 3

            connect_port 3306

        }

    }

}

virtual_server 192.168.56.112 3306{

    delay_loop 3

    lb_algo rr

lb_kind DR

persistence_timeout 20

    protocol TCP

    real_server 192.168.56.101 3306{

        weight 3

        TCP_CHECK {

            connect_timeout 10

            nb_get_retry 3

            delay_before_retry 3

            connect_port 3306

        }

    }

 

    real_server 192.168.56.102 3306{

        weight 3

        TCP_CHECK {

            connect_timeout 10

            nb_get_retry 3

            delay_before_retry 3

            connect_port 3306

        }

    }

}

Master B

~]# cat /etc/keepalived/keepalived.conf

global_defs {

   notification_email {

     jixiang.yu@trekiz.com

   }

   notification_email_from Alexandre.Cassen@firewall.loc

   smtp_server 127.0.0.1

   smtp_connect_timeout 30

   router_id MySQL_HA

}

 

vrrp_instance MySQL-HA{

    state BACKUP

    interface eth1

    virtual_router_id 51

    priority 90

    advert_int 1

    authentication {

        auth_type PASS

        auth_pass 1111

    }

    virtual_ipaddress {

        192.168.56.111

    }

}

 

virtual_server 192.168.56.111 3306{

    delay_loop 3

    lb_algo rr

    lb_kind DR

    persistence_timeout 20

    protocol TCP

    sorry_server 192.168.56.102 3306

    real_server 192.168.56.101 3306{

        weight 3

        TCP_CHECK {

            connect_timeout 10

            nb_get_retry 3

            delay_before_retry 3

            connect_port 3306

        }

    }

}

 

virtual_server 192.168.56.112 3306{

    delay_loop 3

    lb_algo rr

lb_kind DR

persistence_timeout 20

    protocol TCP

    real_server 192.168.56.101 3306{

        weight 3

        TCP_CHECK {

            connect_timeout 10

            nb_get_retry 3

            delay_before_retry 3

            connect_port 3306

        }

    }

 

    real_server 192.168.56.102 3306{

        weight 3

        TCP_CHECK {

            connect_timeout 10

            nb_get_retry 3

            delay_before_retry 3

            connect_port 3306

        }

    }

2)    realserver配置

#A和B一样

~]# cat /etc/init.d/realserver

#!/bin/bash

VIP=192.168.56.111

VIP2=192.168.56.112

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

case "$1" in

start)

    /sbin/ifconfig lo:0 $VIP netmask 255.255.255.255 broadcast $VIP

    /sbin/ifconfig lo:1 $VIP2 netmask 255.255.255.255 broadcast $VIP2

    /sbin/route add -host $VIP dev lo:0

    /sbin/route add -host $VIP2 dev lo:1

    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   

    /sbin/sysctl -p >/dev/null 2>&1

    echo "LVS-DR real server starts successfully."                   

    ;;   

stop)   

    /sbin/ifconfig lo:0 down   

    /sbin/ifconfig lo:1 down   

    /sbin/route del $VIP >/dev/null 2>&1   

    /sbin/route del $VIP2 >/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 "LVS-DR real server stopped."

    ;;

status)

    isLoOn=`/sbin/ifconfig lo:0 | grep "$VIP"`

    isRoOn=`/bin/netstat -rn | grep "$VIP"`

    if [ "$isLoOn" == "" -a "$isRoOn" == "" ]; then

       echo "LVS-DR real server has to run yet."

    else

       echo "LVS-DR real server is running."

    fi

    exit 3

    ;;

*)   

    echo "Usage: $0 {start|stop|status}"

    exit 1   

esac                    

exit 0

3)    启动realserver和KeepAlived服务

#A和B都分别启动

~]# /etc/init.d/realserver start

LVS-DR real server starts successfully.

~]# /etc/init.d/keepalived start

Starting keepalived:

Master A~]# ipvsadm -ln

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn

TCP  192.168.56.111:3306 rr persistent 20

  -> 192.168.56.101:3306          Local   3      1          0        

TCP  192.168.56.112:3306 rr persistent 20

  -> 192.168.56.101:3306          Local   3      0          0        

  -> 192.168.56.102:3306          Route   3      0          0       

Master B~]# ipvsadm -ln

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn

TCP  192.168.56.111:3306 rr persistent 20

  -> 192.168.56.101:3306          Route   3      3          0        

TCP  192.168.56.112:3306 rr persistent 20

  -> 192.168.56.101:3306          Route   3      0          0        

  -> 192.168.56.102:3306          Local   3      0          0  

并将 keepalived 和 realserver 的启动脚本加入到 rc.local 自启动中：
echo “/etc/rc.d/init.d/realserver start” >> /etc/rc.local

echo “/etc/rc.d/init.d/keepalived start” >> /etc/rc.local

4)    读LoadBlance测试

~]# cat test.sh

#! /bin/sh 

> /tmp/q

for((i=1;i<=100;i++));do  

        mysql -utrekiz -h 192.168.56.112 -ptrekiz -e "show variables like 'server_id'" >> /tmp/q; 

        sleep 3

done 

~]# ./test.sh


由上可知实现了负载均衡，读可以通过VIP 192.168.56.112来实现LB

5)    Failover测试

a)         停止Master(A)上的MySQL,写IP切换到sorry_server(B)上，并且读IP只剩B

Master A~]# /etc/init.d/mysql stop

Shutting down MySQL....                                    [  OK  ]

~]# ipvsadm -Ln

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn

TCP  192.168.56.111:3306 rr persistent 20

  -> 192.168.56.102:3306          Route   1      0          0        

TCP  192.168.56.112:3306 rr persistent 20

  -> 192.168.56.102:3306          Route   3      0          0       

b)         停止Master（A）上的keepalived，VIP切换到soory_server（B）主机上

Master B~]# ip a|grep eth1

3: eth1: mtu 1500 qdisc pfifo_fast state UP qlen 1000

    inet 192.168.56.102/24 brd 192.168.56.255 scope global eth1

    inet 192.168.56.111/32 scope global eth1

inet 192.168.56.112/32 scope global eth1

c)         启动Master上的mysql，看写IP又切回real_server(101)上

Master B ~]# ipvsadm -Ln

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn

TCP  192.168.56.111:3306 rr persistent 20

  -> 192.168.56.101:3306          Route   3      0          0        

TCP  192.168.56.112:3306 rr persistent 20

  -> 192.168.56.101:3306          Route   3      0          0        

  -> 192.168.56.102:3306          Local   3      0          0  

d)         启动Master上的keepalived,读写VIP切回Master A

Master A~]# ipvsadm -Ln

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn

TCP  192.168.56.111:3306 rr persistent 20

  -> 192.168.56.101:3306          Local   3      0          0        

TCP  192.168.56.112:3306 rr persistent 20

  -> 192.168.56.101:3306          Local   3      0          0        

  -> 192.168.56.102:3306          Route   3      0          0        

Master A~]# ip a|grep eth1

3: eth1: mtu 1500 qdisc pfifo_fast state UP qlen 1000

    inet 192.168.56.101/24 brd 192.168.56.255 scope global eth1

    inet 192.168.56.111/32 scope global eth1

inet 192.168.56.112/32 scope global eth1

e)         重启Master的系统，切换过程如下：

Dec 10 16:50:34 MySQL2 Keepalived_healthcheckers[2530]: TCP connection to [192.168.56.101]:3306 failed !!!

Dec 10 16:50:34 MySQL2 Keepalived_healthcheckers[2530]: Removing service [192.168.56.101]:3306 from VS [192.168.56.112]:3306

Dec 10 16:50:34 MySQL2 Keepalived_healthcheckers[2530]: Remote SMTP server [127.0.0.1]:25 connected.

Dec 10 16:50:34 MySQL2 Keepalived_healthcheckers[2530]: SMTP alert successfully sent.

Dec 10 16:50:35 MySQL2 Keepalived_healthcheckers[2530]: TCP connection to [192.168.56.101]:3306 failed !!!

Dec 10 16:50:35 MySQL2 Keepalived_healthcheckers[2530]: Removing service [192.168.56.101]:3306 from VS [192.168.56.111]:3306

Dec 10 16:50:35 MySQL2 Keepalived_healthcheckers[2530]: Lost quorum 1-0=1 > 0 for VS [192.168.56.111]:3306

Dec 10 16:50:35 MySQL2 Keepalived_healthcheckers[2530]: Adding sorry server [192.168.56.102]:3306 to VS [192.168.56.111]:3306

Dec 10 16:50:35 MySQL2 Keepalived_healthcheckers[2530]: Removing alive servers from the pool for VS [192.168.56.111]:3306

Dec 10 16:50:35 MySQL2 Keepalived_healthcheckers[2530]: Remote SMTP server [127.0.0.1]:25 connected.

Dec 10 16:50:35 MySQL2 Keepalived_healthcheckers[2530]: SMTP alert successfully sent.

Dec 10 16:50:41 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Transition to MASTER STATE

Dec 10 16:50:42 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Entering MASTER STATE

Dec 10 16:50:42 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) setting protocol VIPs.

Dec 10 16:50:42 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Sending gratuitous ARPs on eth1 for 192.168.56.111

Dec 10 16:50:42 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Sending gratuitous ARPs on eth1 for 192.168.56.112

Dec 10 16:50:42 MySQL2 avahi-daemon[1509]: Registering new address record for 192.168.56.111 on eth1.IPv4.

Dec 10 16:50:42 MySQL2 avahi-daemon[1509]: Registering new address record for 192.168.56.112 on eth1.IPv4.

Dec 10 16:50:42 MySQL2 Keepalived_healthcheckers[2530]: Netlink reflector reports IP 192.168.56.111 added

Dec 10 16:50:42 MySQL2 Keepalived_healthcheckers[2530]: Netlink reflector reports IP 192.168.56.112 added

Dec 10 16:50:47 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Sending gratuitous ARPs on eth1 for 192.168.56.111

Dec 10 16:50:47 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Sending gratuitous ARPs on eth1 for 192.168.56.112

Dec 10 16:51:17 MySQL2 Keepalived_healthcheckers[2530]: TCP connection to [192.168.56.101]:3306 success.

Dec 10 16:51:17 MySQL2 Keepalived_healthcheckers[2530]: Adding service [192.168.56.101]:3306 to VS [192.168.56.111]:3306

Dec 10 16:51:17 MySQL2 Keepalived_healthcheckers[2530]: Gained quorum 1+0=1 <= 3 for VS [192.168.56.111]:3306

Dec 10 16:51:17 MySQL2 Keepalived_healthcheckers[2530]: Removing sorry server [192.168.56.102]:3306 from VS [192.168.56.111]:3306

Dec 10 16:51:17 MySQL2 Keepalived_healthcheckers[2530]: Adding alive servers to the pool for VS [192.168.56.111]:3306

Dec 10 16:51:17 MySQL2 Keepalived_healthcheckers[2530]: Remote SMTP server [127.0.0.1]:25 connected.

Dec 10 16:51:17 MySQL2 Keepalived_healthcheckers[2530]: SMTP alert successfully sent.

Dec 10 16:51:18 MySQL2 Keepalived_healthcheckers[2530]: TCP connection to [192.168.56.101]:3306 success.

Dec 10 16:51:18 MySQL2 Keepalived_healthcheckers[2530]: Adding service [192.168.56.101]:3306 to VS [192.168.56.112]:3306

Dec 10 16:51:18 MySQL2 Keepalived_healthcheckers[2530]: Remote SMTP server [127.0.0.1]:25 connected.

Dec 10 16:51:18 MySQL2 Keepalived_healthcheckers[2530]: SMTP alert successfully sent.

Dec 10 16:53:35 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Received higher prio advert

Dec 10 16:53:35 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) Entering BACKUP STATE

Dec 10 16:53:35 MySQL2 Keepalived_vrrp[2531]: VRRP_Instance(MySQL-HA{) removing protocol VIPs.

Dec 10 16:53:35 MySQL2 avahi-daemon[1509]: Withdrawing address record for 192.168.56.111 on eth1.

Dec 10 16:53:35 MySQL2 avahi-daemon[1509]: Withdrawing address record for 192.168.56.112 on eth1.

Dec 10 16:53:35 MySQL2 Keepalived_healthcheckers[2530]: Netlink reflector reports IP 192.168.56.111 removed

Dec 10 16:53:35 MySQL2 Keepalived_healthchecker s[2530]: Netlink reflector reports IP 192.168.56.112 removed


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27000195/viewspace-1364792/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27000195/viewspace-1364792/

cuizeen198835
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
lvs+keepalived 负载均衡realserver.sh脚本
淹死的鱼
12-27 1652
1、命令进入：cd/etc/init.d 2、赋权限：chmod 777 realserver.sh 3、添加开机自启：chkconfig --add realserver.sh 注意：如果报错：service realserver.sh does not support chkconfig,则需要在 realserver.sh脚本中添加下面两句到 #!/bin/bash 之后
Mysql双主热备+LVS+Keepalived高可用操作记录（个人精华版）
08-31
本篇文章详细记录了Mysql双主热备+LVS+Keepalived高可用操作过程,可作为线上长期的实操手册.特此分享,希望能帮助到有用到的朋友.
Keepalived+LVS实现高可用负载均衡双主模式
weixin_30950607的博客
04-19 257
LVS是一种集群(Cluster)技术：采用IP负载均衡技术和基于内容请求分发技术。调度器具有很好的吞吐率，将请求均衡地转移到不同的服务器上执行，且调度器自动屏蔽掉服务器的故障，从而将一组服务器构成一个高性能的、高可用的虚拟服务器。整个服务器集群的结构对客户是透明的，而且无需修改客户端和服务器端的程序。工作在四层，在内核空间工作，基于ipvs模块，不占用流量。 双机高可用方法目前分为两种： 1...
keepalived 各配置项和术语说明
热门推荐
stay hungry,stay foolish !
03-03 2万+
一、配置项 global_defs {     notification_email {  #指定keepalived在发生切换时需要发送email到的对象，一行一个     sysadmin@fire.loc     } notification_email_from Alexandre.Cassen@firewall.loc #指定发件人    smtp_server localh
《Linux keepalived与lvs的深入分析》三之负载调度算法
wdt3385的专栏
05-27 1080
转自：http://www.lupaworld.com/home-space-uid-56821-do-blog-id-241652.html 七)负载调度算法 1)轮叫调度（Round Robin）(简称rr) 调度器通过"轮叫"调度算法将外部请求按顺序轮流分配到集群中的真实服务器上,它均等地对待每一台服务器,而不管服务器上实际的连接数和系统负载. 下
mysql keepalived lvs_MySQL主主+Keepalived+LVS高可用（二）：单点写入
weixin_33464488的博客
01-18 128
方案简介本方案采用keepalived中的sorry_server来实现写入数据库为单点的需求。本方案实现的功能是当网络有问题、mysql 有问题、 服务器宕机、 keepalived 服务停止后,服务器能自动跳转到备用机，当主服务器服务启动起来后会自动切换回来。1)安装LVS~]#rpm-ivh libnl-devel-1.1-14.el6.x86_64.rpm~]#rpm-ivh popt-d...
LVS+Keepalived+MySQL半同步主主复制高可用方案.docx
07-15
【LVS+Keepalived+MySQL半同步主主复制高可用方案】 1. 方案概述 LVS（Linux Virtual Server）结合Keepalived构建的高可用解决方案，通常用于实现负载均衡和故障转移，以提高系统的整体可用性。在这个方案中，MySQL...
LVS+KEEPALIVED+MYSQL 单点写入读负载均衡主主同步高可用方案安装教程
12-10
首先，我们需要明确方案的总体目标，即构建一个既能实现单点写入又能实现读负载均衡的MYSQL数据库高可用环境。这里的“单点写入”意味着所有的写操作都指向同一个数据库服务器，而“读负载均衡”则表示读操作可以被...
mysql主从复制+lvs与keepalived实现负载高可用
03-18
Keepalived是与LVS一起使用的高可用性工具，它监控服务器的状态并确保在主服务器故障时能够快速切换到备用服务器。在正常状态下，W-VIP和R-VIP指向主机A。如果主机A出现故障，Keepalived会检测到这一变化，并将W-VIP...
负载均衡之三
weixin_34179762的博客
09-28 76
6.3 cdn缓存服务器的负载均衡（lvs+keepalived）       作者：田逸（sery@163.com） 在cdn的某个区域，需要部署多个缓存服务器，以集群方式来应对大量用户的访问请求，提高系统的高可用性。在机器数量较少的时候，我曾用dns轮训的方式把访问负载分担给服务器，效果不佳，因为DNS不会做健康检查。后来增加机器，做成lvs集群，就很安心了。 6.3.1 cdn缓存...
/etc/rc.d/与/etc/rc.d/init.d的关系
weixin_33788244的博客
01-21 88
/etc/init.d指向/etc/rc.d/init.d目录 . 除了直接调用脚本外(如/etc/rc.d/init.d/xinetd),还可以用service命令来控制init.d目录下的服务如 service jws restart(systemctl restart jws), 在这里先解释一下init.d里面放的都是什么东西。这个目录存放的是一些脚本，一般是linux以rpm包安装时...
LVS 配置之DR模式
JFYH_dream的专栏
06-27 842
LVS 负载均衡 之 DR模式场景 拓扑图 配置步骤 在L机器上安装相应的软件 在L机器上配置keepalived 启动keepalived 配置S端机器 验证 GAME OVER场景: LVS机器L1 (IP:192.168.1.1) LVS机器L2 (IP:192.168.1.2) 服务机器S1 (IP:192.168.1.3) 服务机器S2 (IP:192.168.1.4
LVS-Realserver配置脚本
weixin_34128534的博客
06-27 112
这个是redhat上的LVS realserver的脚本 #!/bin/sh VIP=10.192.168.1.230 . /etc/rc.d/init.d/functions case "$1" in start) ifconfig lo:0 $VIP netmask 255.255.255.255 broadcast $VIP ...
SSH 和 Telnet 之间的区别
ITmoster的博客
08-08 396
SSH 和 Telnet是帮助用户与远程系统建立连接的两种通信协议，这些通信协议决定了数据如何在网络上的不同设备之间传输，这些设备通常需要通过各种物理和数字环境进行传输，网络协议的主要目标是通信、网络管理和安全。
深度解密CRLF注入与重定向漏洞：从原理到实践
2301_80064376的博客
08-08 917
重定向漏洞（Open Redirect）是一种安全漏洞，攻击者可以利用它将用户从受信任的网站重定向到恶意网站。这种漏洞通常出现在网站处理 URL 参数时，没有对用户输入进行适当验证。
HAProxy基本配置及参数实操
最新发布
Webston的博客
08-12 900
静态#动态#以下静态和动态取决于hash_type 是否consistentfirst #使用较少static-rr #做了session 共享的web集群leastconn #数据库source#基于客户端公网IP 的会话保持Uri--------------->http #缓存服务器，CDN服务商，蓝汛、百度、阿里云、腾讯url_param--------->http #可以实现session 保持hdr #基于客户端请求报文头部做下一步处理高。
Lvs+Keepalived+Mysql高可用实战：主主同步与读写分离配置教程
2. **LVS+Keepalived+Mysql单点写入读负载均衡主主同步高可用方案** - **方案特点**：增加了读负载均衡，读请求被分发到多个备份库，进一步提高系统性能和可用性。 - **适用场景**：适用于更复杂的环境，需要同时...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值