lvs mysql健康检查_LVS+keepalived做Mysql集群的负载均衡

比眉伴天荒 2022-10-27 01:58 138阅读 0赞

LVS+keepalived做Mysql集群的负载均衡：

注：

1、LVS本身不对node做健康检查的，所以要借助keepalived

2、根据配置当某node down掉会有几秒判断时间，这点请注意。

负载均衡端：

yum install ipvsadm keepalived ipset-devel

注：

keepalived的log在/var/log/message里

vi /etc/keepalived/keepalived.conf

! Configuration File for keepalived

global\_defs \{

notification\_email \[email protected\]br/>\[email protected\]

notification\_email\_from \[email protected\]

smtp\_server 10.0.0.10

smtp\_connect\_timeout 30

router\_id LVS\_DEVEL

vrrp\_skip\_check\_adv\_addr

vrrp\_strict (这行一定要注掉，不注掉vip可能会ping不通)

vrrp\_garp\_interval 0

vrrp\_gna\_interval 0

vrrp\_instance VI\_1 \{

state MASTER

interface eno1 (这里网卡名要写对)

Virtual\_router\_id 51

priority 100

advert\_int 3

authentication \{

auth\_type PASS

auth\_pass 1111

Virtual\_ipaddress \{

10.0.1.10

Virtual\_server 10.0.1.10 3306 \{

delay\_loop 6

lb\_algo rr

lb\_kind DR (此处需改为DR)

persistence\_atimeout 10

protocol TCP

real\_server 10.0.1.2 3306 \{

weight 1

TCP\_CHECK \{

connect\_timeout 3

nb\_get\_retry 3

delay\_before\_retry 3

connect\_port 3306

real\_server 10.0.1.3 3306 \{

weight 1

TCP\_CHECK \{

connect\_timeout 3

retry 3

delay\_before\_retry 1

connect\_port 3306

real\_server 10.0.1.4 3306 \{

weight 1

TCP\_CHECK \{

connect\_timeout 3

retry 3

delay\_before\_retry 1

connect\_port 3306

:wq

systemctl restart keepalived

systemctl enable keepalived

systemctl status keepalived

ip a (检查eno1是不是多了个10.0.1.10的vip，这个ip在ifconfig是看不到的，要确保可以ping通)

ipvsadm -L --stats (查看各node分配情况)

Mysql node端(所有node都做)：

ifconfig lo:0 10.0.1.10 netmask 255.255.255.255 broadcast 10.0.1.10

route add -host 10.0.1.10 dev lo:0

vi /etc/sysctl.conf

net.ipv4.conf.lo.arp\_ignore = 1

net.ipv4.conf.lo.arp\_announce = 2

net.ipv4.conf.all.arp\_ignore = 1

net.ipv4.conf.all.arp\_announce = 2

:wq

sysctl -p

ifconfig lo:0

route -n

验证(可以看到访问的为不同node)：

mysql -u aa -p'xxxx' -h 10.0.1.10 -e "select @@hostname;"

lvs mysql健康检查_LVS+keepalived做Mysql集群的负载均衡

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 LVS负载均衡群集

相关【集群】LVS负载均衡群集

相关 mysql负载均衡集群

相关 lvs mysql健康检查_LVS+keepalived做Mysql集群的负载均衡

相关 MySQL CLUSTER 集群方案+LVS+keepalived负载均衡

相关 LVS均衡负载（三） LVS后端服务健康状态检查

相关负载均衡集群LVS

相关 LVS集群负载均衡简介

相关 LVS负载均衡群集

相关 LVS负载均衡群集详解