1200字范文 > LVS+keepalived构建PXC高可用集群

LVS+keepalived构建PXC高可用集群

时间：2020-02-19 17:30:47

独角兽企业重金招聘Python工程师标准>>>

1 高可用安装

1.1 集群信息

1.2 安装准备

上传安装所需的压缩包到/opt目录

keepalived-1.2.4.tar.gz

(/software/keepalived-1.2.4.tar.gz)

安装组件所需依赖包

yum install openssl-devel popt-devel libnl* -y

1.3 安装LVS+keepalived

在两台Director Server上分别安装LVS+Keepalived，BACKUP服务器与MASTER服务器一致，先安装lvs再安装keepalived。

1.3.3 安装LVS

Ipvs(IP Virtual Server)是整个负载均衡的基础，没有这个基础，故障隔离与失败切换就毫无意义了。

yum install ipvsadm –y

1.3.4 安装keepalived

解压包：

tar zxvf keepalived-1.2.4.tar.gz

初始化：

cd keepalived-1.2.4./configure --prefix=/usr/local/keepalived

Keepalived configuration------------------------Keepalived version : 1.2.4Compiler : gccCompiler flags : -g -O2Extra Lib: -lpopt -lssl -lcrypto -lnlUse IPVS Framework : YesIPVS sync daemon support : YesIPVS use libnl : YesUse VRRP Framework : YesUse VRRP VMAC : YesUse Debug flags: No

编译并安装：

make&&make install

Make completemake -C keepalived installmake[1]: Entering directory `/root/Desktop/keepalived-1.2.1/keepalived'install -d /usr/local/keepalived/sbininstall -m 700 ../bin/keepalived /usr/local/keepalived/sbin/install -d /usr/local/keepalived/etc/rc.d/init.dinstall -m 755 etc/init.d/keepalived.init /usr/local/keepalived/etc/rc.d/init.d/keepalivedinstall -d /usr/local/keepalived/etc/sysconfiginstall -m 755 etc/init.d/keepalived.sysconfig /usr/local/keepalived/etc/sysconfig/keepalivedinstall -d /usr/local/keepalived/etc/keepalived/samplesinstall -m 644 etc/keepalived/keepalived.conf /usr/local/keepalived/etc/keepalived/install -m 644 ../doc/samples/* /usr/local/keepalived/etc/keepalived/samples/install -d /usr/local/keepalived/share/man/man5install -d /usr/local/keepalived/share/man/man8install -m 644 ../doc/man/man5/keepalived.conf.5 /usr/local/keepalived/share/man/man5install -m 644 ../doc/man/man8/keepalived.8 /usr/local/keepalived/share/man/man8make[1]: Leaving directory `/root/Desktop/keepalived-1.2.1/keepalived'make -C genhash installmake[1]: Entering directory `/root/Desktop/keepalived-1.2.1/genhash'install -d /usr/local/keepalived/bininstall -m 755 ../bin/genhash /usr/local/keepalived/bin/install -d /usr/local/keepalived/share/man/man1install -m 644 ../doc/man/man1/genhash.1 /usr/local/keepalived/share/man/man1make[1]: Leaving directory `/root/Desktop/keepalived-1.2.1/genhash'

1.4 配置路由转发

1>更改配置文件

vi /etc/sysctl.conf

net.ipv4.ip_forward = 1

2>刷新系统配置

sysctl -p

1.5 配置f

keepalived的配置分为三类：全局配置（global configuration），VRRPD配置，LVS配置。

全局配置就是对整个keepalived起效的配置，不管是否使用LVS。VRRPD是keepalived的核心，LVS配置只在要使用keepalived来配置的管理LVS时需要使用，如果仅仅使用keepalived来做HA，LVS的配置是不需要的。如果在只有一个负载均衡器的场合，就不须 VRRP 实例定义块。

mkdir /etc/keepalivedvi /etc/keepalived/keepalived.conf

! Configuration File for keepalivedglobal_defs {router_id LVS_MASTER #BACKUP LVS_BACKUP}vrrp_instance VI_1 {state MASTER #BACKUP BACKUPinterface eno16777736virtual_router_id 51priority 100 #BACKUP 80advert_int 1nopreemptauthentication {auth_type PASSauth_pass 1111}virtual_ipaddress {192.168.252.199}}virtual_server 192.168.252.199 3306 {delay_loop 6lb_algo rrlb_kind NAT# persistence_timeout 5protocol TCPreal_server 192.168.252.159 3306 {weight 3TCP_CHECK {connect_timeout 3nb_get_retry 3delay_before_retry 3connect_port 3306}}real_server 192.168.252.160 3306 {weight 3TCP_CHECK {connect_timeout 3nb_get_retry 3delay_before_retry 3connect_port 3306}}real_server 192.168.252.161 3306 {weight 3TCP_CHECK {connect_timeout 3nb_get_retry 3delay_before_retry 3connect_port 3306}}}

注：配置backup的/etc/keepalived/keepalived.conf，只需将批注部分改一下即可。

2 keepalived集群启动

2.1 master节点启动

/usr/local/keepalived/sbin/keepalived start

检查虚拟IP启动情况

方法1：

tail -30 /var/log/message

Jun 15 16:24:25 localhost Keepalived_vrrp[54297]: Interface queue is emptyJun 15 16:24:25 localhost Keepalived_vrrp[54297]: No such interface, virbr0Jun 15 16:24:25 localhost Keepalived_vrrp[54297]: No such interface, virbr0-nicJun 15 16:24:25 localhost Keepalived_vrrp[54297]: Registering Kernel netlink reflectorJun 15 16:24:25 localhost Keepalived_vrrp[54297]: Registering Kernel netlink command channelJun 15 16:24:25 localhost Keepalived_vrrp[54297]: Registering gratuitous ARP shared channelJun 15 16:24:25 localhost Keepalived_vrrp[54297]: Opening file '/etc/keepalived/keepalived.conf'.Jun 15 16:24:25 localhost Keepalived_vrrp[54297]: Configuration is using : 61916 BytesJun 15 16:24:25 localhost Keepalived_vrrp[54297]: Using LinkWatch kernel netlink reflector...Jun 15 16:24:25 localhost Keepalived_healthcheckers[54296]: Activating healthchecker for service [192.168.252.199]:3306Jun 15 16:24:25 localhost Keepalived_healthcheckers[54296]: Activating healthchecker for service [192.168.252.199]:3306Jun 15 16:24:25 localhost Keepalived_healthcheckers[54296]: Activating healthchecker for service [192.168.252.199]:3306Jun 15 16:24:25 localhost Keepalived_vrrp[54297]: VRRP_Instance(VI_1) Transition to MASTER STATEJun 15 16:24:26 localhost Keepalived_vrrp[54297]: VRRP_Instance(VI_1) Entering MASTER STATEJun 15 16:24:26 localhost avahi-daemon[768]: Registering new address record for 192.168.252.199 on eno16777736.IPv4.

方法2：

[root@localhost Desktop]#ip addr

2.2 backup节点启动

/usr/local/keepalived/sbin/keepalived start

2.3 查看路由分发情况

查看ipvsadm

[root@localhost Desktop]#ipvsadm

也能够通过mysqladmin查看本地mysql服务连接状况

/opt/percona/bin/mysqladmin -uroot -p123456 status