2022年LVS+keepalived高可用數(shù)據(jù)主從集群技術(shù)方案

1、LVS+keepaI i ved高可用數(shù)據(jù)主從集群技術(shù)方案準(zhǔn)備工作:主機名操作系統(tǒng)IP地址擔(dān)任角色masterlCentOS7192. 168. 1. 1MySQL-主master2192. 168. 1.2MySQL-主keepl192. 168.1.3Keepalived-主，LVSkeep2192. 168. 1.4Keepalived-備，LVS一、部署MySQL雙主復(fù)制注憊：未安裝MySQL數(shù)據(jù)庫的可以先安裝：安裝教程 11 配置時間同步masterl上操作rootmasterl # yum -y install ntprootgmasterl # sed -i /Aserver/s

2、/A/#/g /etc/ntp.confrootmasterl # cat /etc/ntp.confserver 127.127.1.0fudge 127.127.1.0 stratum 8ENDrootmasterl # systemctl restart ntpd#配置開機自啟rootmasterl # systemctl enable ntpd#查看狀態(tài)rootmasterl # netstat -anpu | grep ntpc安軟：ntpx86_64 0:4.2.6p529.e!7.centos完知(rootBaasterl * sed -i /A5erver/s/*/f/g, Z

3、etc/ntp.confroot0Basterl *Jf cat END /etc/ntp.confserver 127.127.1.0fudge 127.127.1.0 stratus 8ENDrootdnasterl *f systeactl restart ntpd(roottaasterl f dystenet1 enable ntpdCreated synlink from /etc/systend/system/nulti-uder.target.wants/ntpdservlce to /ur/lib/systomd/systen/ntpdservice roottaasterl

4、 *anpu I grep ntpdudp udp00 192.168.1.1:1230.0.0.0:*1548/ntpd00127.0.0.1:1230.0.0.0:1548/ntpdudp000.0.0.0:1230.0.0.0:*1548/ntpdudp00fe80:s20c:29ff:fedb:123:1548/ntpdudp600:1:1231548/ntpdudp600：1231548/ntpd(rooteasterl *f |eaa 忸n皿uh?nwo5 ms mlmmaster 2上操作rootmaster2 # yum -y install ntpdate rootmaste

5、r2 # /usr/sbin/ntpdate 192.168.1.1 1 2己安裝：ntpdatex86_64 0:4.2.6p5-29.el7.centos完畢！rootemaster2 *# /usr/sbin/ntpdate 192.168.1.12 Jan 23:27:29 ntpdate17351: step time server 192.168.1.1 offset 28799.162679 sec (rootemaster2 |VBSR 192.168.12SSH2 xterm 8Sx30 30.19 S 仝8CAP NUM2 配置雙主復(fù)制1 ) masterl上操作rootm

6、asterl # cat /etc/f log-bin=mysql-masterl server-id=l log_slave_updaauto_increment_offset=lauto_increment_increment=2ENDrootmasterl # systemctl restart mysqldrootmasterl # mysql -uroot -pl23456mysql grant replication slave on *.* to replg192.168.I.%1 identified b y 123456;mysql flush privileges;mysq

7、l exitJ master1.192.168.1.1 - XsheU 4XME) MfV) ZJKT) (W) Wfc(H)tars 夕3- mastcrl J92.168.1.1o I mter2_19Z168.12j kep1_19Z168.1 Jkeef2_192.16a.14- dient.192.16a.1 Jmysqlmysql grant replication slave on *.* to repl192.168.1.%* identified by 1123456*; Query OK, 0 rows affected (0.00 sec)mysql flush priv

8、ileges;Query OK, 0 rows affected (0.38 sec)mysql exitByerootmasterl *f |2) master2上操作rootmaster2 # cat /etc/f log-bin=mysql-master2 server-id=2 log_slave_updates=lauto_incremenauto_increment_increment=2ENDrootmaster2 # systemctl restart mysqldrootmaster2 # mysql -uroot -pl23456mysql grant replicatio

9、n slave on *.* to repl192.168.1.% identified b y 123456;mysql flush privileges;mysql exitJ mastef2_192.16a.1.2 - Xshdl4一XXWF) E) M(V) UKT) D(W) IM3(H)n-.十.個-i9 : fi Jis O Q匚 1 m35ter1J9Z168.1.1 2 msUr2J92.168.12o a keep1J9168.13-4 keep2J9Z168.1.4o J 日g192J68J5mysqlmysql grant replication slave on *.

10、* to repl，192168l$ identified by 123456; Query OK, 0 rows affected (015 sec)mysql flush privileges;Query OK, 0 rows affected (0.00 sec)mysql exitBye rootmaster2 *f |3)建立雙主復(fù)制masterl上操作rootmasterl # mysql -uroot -pl23456mysql change master to master_host= *192.168.1.2 master_password=* 123456;mysql st

11、art slave;mysql show slave statusG;J mMt2_192.168.1.2 XZ4Xmaster1 192.168.1.1 Xshell4XR(F) MI(E) CXV)工JUT) BO(W) HD(X) IHT3 fy* E機 *2 蠶, J miftcr1_192-16&.1.12 EHe292J68J2； i keep119Z168.13 u 4 kee$2s192.168.14 o J clientw192.16&.1.5mysqlmysql change master to- master_host=192.168.1.2*, master_user=

12、1 repl,- master_password=*123456;Query OK, 0 rows affected, 2 warnings (0.18 sec) mysql start slave;Query OK, 0 rows affected (0.00 sec)mysql show slave statusG; * i.Slave_IO_State: Master_Host: Master_User: Master_Port: Connect_Retry: Master_Log_File: Read_Master_Log_Pos: Relay_Log_File: Relay_Log_

13、Pos: Relay_Master_Log_File: Slave_IO_Running: S1ave_SQL_Runn i ng: Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Rep1i cate_W i1d_Do_Table: Replicate_Wild_Ignore_Table:row *Waiting for master to send event 192.168.1.2repl330660mysql-master2.000001120mysqld-relay-b

14、in.000002287mysql-master2.000001YesYes已洌119Z168.1.1u!2.SSH2 xterm 85x3C 30.8 5 話NUMmaster2上操作rootmaster2 # mysql -uroot -pl23456 mysql change master tomaster_host=192.168.1.1,master_user=repl master_password=123456; mysql start slave;mysql show slave statusG;JW)M(V) UkT) Q(W) WtKH)niHi3- f f我 j o1 n

15、wter1J92.168.1.1 a 2 macter2.192.168.13. 4 kwp2 192.168.14o 5 cfintJ92.16&1.5mysqlmysql change master to- master_ho3t=192.168.1.1,- master_user=repl *,- master_pas5word=,123456*;Query OK, 0 rows affected, 2 warnings (0.01 sec)mysql start slave;Query OK, 0 rows affected (000 sec)mysql show slave stat

16、usG; * I siave_io_stateMaster_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Re lay_Master_Log_Fi1e Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Re

17、plicate_Wild_Ignore_Tablerow *Waiting for master to send event 192.168.1.1repl330660mysql-masterl.000001120 master2-relay-bin.000002287mysql-masterl.000001YesYesNUMSSH2 xterm 8Sa3C 30.8 5 玄iS二、部署LVS+Keepalived實現(xiàn)MySQL雙主復(fù)制高可用1 配置主調(diào)度器rootkeepl # yum -y install keepalived ipvsadm rootkeepl # vim /etc/ke

18、epalived/keepalived.conf global_defs router_id 1 vrrp_instance VI_1 state MASTER interface ens33 virtual_router_id 51 priority 100 advert_int 1 authentication auth_type PASS auth_pass 1111 virtual_ipaddress 192.168.1.188 virtual_server 192.168.1.188 3306 delay_loop 6lb_algo rrlb_kind DRpersistence_t

19、imeout 0protocol TCPreal_server 192.168.1.1 3306 weight 1TCP_CHECK connect_port 3306connectjtimeout 3nb_get_retry 3delay_before_retry 3real_server 192.168.1.2 3306 weight 1TCP_CHECK connect_port 3306connect_timeout 3nb_get_retry 3delay_before_retry 3rootkeepl # systemctl start keepalived rootkeep2 #

20、 ip aJ keep! J92.168.1.3 - X0icfl4-OXX* s 2 訂：， O土 0 lmte1_t9M6at.t o 2mMMw2.192.16S.12 c J kMp1 1921U.1 Jo i kMp2J92.16&14 o i cfentJ92.168.15*rootkeep1 f(rootSkeepl -)# systenctl start keepalived(rootkeepl # ip a1: lo: tutu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopbaclc 0

21、0:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lovalid_lft forever preferred_lft foreverinet6 :1/128 scope hostvalid_lft forever preferred“t forever2: ens33: ntu 1500 qdisc pfifo fast state UP group default qlen 1000 iink/ether 00:0c:29:24:d0:8a brd ffiff:ff:ff:ff:ff inet 192.168

22、.1.3/24 brd 192.168.1.255 scope global noprefixroute ens33valid 1ft forever preferred 1ft forever| inet 192.168.1.188/32*scope global ens33rinet6 fe80:aab3:6225:9577:c480/64 scope link noprefixroutevalid_lft forever preferred_lft forever(rootOkeepl -* |2 配置備調(diào)度器rootkeep2 # yum -y install keepalived i

23、pvsadmrootkeep2 # vim /etc/keepalived/keepalived.confglobal_defs router_id 2 vrrp_instance VI_1 state BACKUPinterface ens33virtual_router_id 51priority 99advert_int 1 authentication auth_type PASSauth_pass 1111virtual_ipaddress 192.168.1.188virtual_server 192.168.1.188 3306 delay_loop 6lb_algo rrlb_

24、kind DRpersistence_timeout 0protocol TCPreal_server 192.168.1.1 3306 weight 1TCP_CHECK connect_port 3306connect_timeout 3nb_get_retry 3delay_before_retry 3real_server 192.168.1.2 3306 1weight 1TCP_CHECK connect_port 3306connect_timeout 3nb_get_retry 3delay_before_retry 3rootkeep2 # systemctl start k

25、eepalived查看LVS集群狀態(tài) rootkeepl # ipvsadm -InJ keep1_192.168.1.3 - Xshell 4-X文件(F) m(E) M(v)UkT) BD(W) 助(H):口倔-3 -r令魏J0爲(wèi)品削+oi m4ster1_192.168.1.1 o 2 master2_192.168.12。3 kMp1 192.16&1.3Q 4 keep2_192.168.14e 5 client J92.168.1.5rootkeep1 *#Arootkeepl *# ipvsadm -InIP Virtual Server version 121(size=409

26、6)Prot LocalAddress:Port SchedulerFlags- RemoteAddress:PortForward Weight ActiveConnInActConnTCP 192.168.1.188:3306 rr- 192.168.1.1:3306Route100- 192.168.1.2:3306Route100rootkeepl|3編寫LVS啟動腳本在 masterl master2 上操作 rootmasterl # vim /etc/init.d/realserver#!/bin/bashVIP=192.168.1.188 /etc/rc.d/initd/fun

27、ctions case $1 instart)/sbin/ifconfig lo down/sbin/ifconfig lo upecho I /proc/sys/net/ipv4/conf/lo/arp_ignoreecho 2 /proc/sys/net/ipv4/conf/lo/arp_announceecho 1 /proc/sys/net/ipv4/conf/all/arp_ignoreecho 2 /proc/sys/net/ipv4/conf/all/arp_announce/sbin/sysctl -p /dev/null 2&1/sbin/ifconfig lo:0 $VIP

28、 netmask 255.255.255.255 up /sbin/route add -host $VIP dev lo:0echo LVSDR real server starts successfullynstop)/sbin/ifconfig lo:0 down/sbin/route del $VIP /dev/null 2&1echo 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_

29、ignore echo 2 /proc/sys/net/ipv4/conf/all/arp_announce echo LVS-DR real server stopped.nstatus)isLoOn=/sbin/ifconfig lo:0 | grep $VIP isRoOn=/bin/netstat -rn | grep $VIP if ”$isLoON” = ”“ a “$isRoOn” = “” ; then echo LVS-DR real server has run yet.elseecho LVS-DR real server is runningfiexit 3*)echo

30、 Usage: $0 start|stop|statusexit 1esacexit 0rootmasterl # chmod +x /etc/init.d/realserverrootmasterl # /etc/init.d/realserver start# 啟動腳木rootmasterl # echo /etc/init.d/realserver /etc/rc.d/rc.local#配置開啟自啟動rootmasterl # ifconfig lo:0S md$ter1_192.168.1.1 -Xshell4-OX文件(F) K(E)UKT) a(W) WBD(H)/3 - r y

31、越4 掘 V髭金創(chuàng)也 e 1 masterl J92.168.1.12 master2J92.168.12 o 3 keepl J92.168.1.3 4 keep2J92.168.1.4, client92J68J.rootmasterl -#rootmasterl *# chmod +x /etc/init.d/realserver(rootmasterl/etc/initd/realserver startReloading systemd:確定Starting realserver (via systemctl): 呦定 rootmasterl echo /etc/init.d/rea

32、lserver /etc/rc.d/rc1ocal rootmasterl F ifconfig lo:0lO：0： flags=73 mtu 65536inet 192.168.1.188 netmask 255.255.255.255loop txqueuelen 1000 (Local Loopback)rootmasterl *# |三、驗證在任意一臺master添加一個測試用戶rootmasterl # mysql -uroot -pl23456 mysql grant all on *.* to test% identified by 1123123*;mysql flush pr

33、ivileges; 1 2341 驗證LVS負(fù)載均衡是否正常rootclient # yum -y install mariadbrootclient # mysql -utest -pl23123 -hl92.168.1.188 -e show variable s like 1serverid1rootclient # mysql utest -pl23123 -hl92.168.1.188 -e show variables like server_idJ dient.192.168.1.5 Xshe4-X文瞅n mke） m（v）sn aa（w）k（h）5 -、孰 E 4 $ 2Q仁

34、o2 mastef2J92.16B.U “ J ln1i ice2J92.168.M dkflt 192.16&Y3rootclient -tArootgclient mysql -utest -pl23123 -hl92.168.1.188 -e show variables like server_idI variable_name I value II server_id rootgclient -# mysql -utest -pl23123 -hl92.168.1.188 -e show variables like server_idI Variable_name I Value

35、II server_id I 2+rootSclient|2驗證Keepalived雙機熱備是否正常關(guān)閉LVS主調(diào)度器，查看客戶機是否能夠正常訪問數(shù)據(jù)庫。J kp2.192.l68.1.4 - Xsheil4-oXxwn Mkei mkv) ukn wa(w)如 M夕 和；4K. * v :a “ 1 mMter1JW.16a.11 u 292.168.12 J192.10 4root9keep2 (root6keep2 -f ip a1: lo: mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lovalidft forever preferredft foreverinet6 :1/128 scope hostvalid_lft forever preferred_lft forever2: ens33: mtu 1500 qdisc pfifo_fa