mysql +keeplive

╰+攻爆jí腚メ 2021-09-30 03:40 195阅读 0赞

下载tar包

./configure --prefix=/usr/local/keepalived **--with-kernel-dir=**/usr/src/kernels/2.6.32-431.el6.x86\_64/ \\      注意加内核

&&make && make install

![1086108-20170511235007457-712225703.png][]

cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/

cp  /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/

cp /usr/local/keepalived/sbin/keepalived  /usr/sbin/

cp -r /usr/local/keepalived/etc/keepalived/ /etc   将配置文件 CP可到/etc

架构 192.168.10.129 httpd服务器 连的VIP    192.168.10.128 真实IP 为master   192.168.10.130 真实IP 为bakcup

配置文件  **VIP需跟本地IP同一网段且IP未曾使用**

**master 配置**

! Configuration File for keepalived  
global\_defs \{  
notification\_email \{  
liu6630@qq.com  
\}  
notification\_email\_from liu6630@qq.com  
smtp\_server 127.0.0.1  
smtp\_connect\_timeout 30  
router\_id LVS\_DEVEL  
\}  
vrrp\_instance VI\_1 \{  
state BACKUP  
interface eth0  
lvs\_sync\_daemon\_inteface eth0  
virtual\_router\_id 151  
priority 100  
advert\_int 5  
nopreempt  
authentication \{  
auth\_type PASS  
auth\_pass 2222  
\}  
virtual\_ipaddress \{  
192.168.111.111  
\}  
\}  
virtual\_server 192.168.111.111 3306 \{  
delay\_loop 6  
lb\_algo wrr  
lb\_kind DR  
persistence\_timeout 60  
protocol TCP  
real\_server 192.168.10.128 3306 \{  
weight 100  
notify\_down /root/shell/mysql\_keepalived.sh  
TCP\_CHECK \{  
connect\_timeout 10  
nb\_get\_retry 3  
delay\_before\_retry 3  
connect\_port 3306  
\}  
\}

**BACK\_UP 配置**

! Configuration File for keepalived  
global\_defs \{  
notification\_email \{  
liu6630@qq.com  
\}  
notification\_email\_from liu6630@qq.com  
smtp\_server 127.0.0.1  
smtp\_connect\_timeout 30  
router\_id LVS\_DEVEL  
\}  
vrrp\_instance VI\_1 \{  
state BACKUP  
interface eth0  
lvs\_sync\_daemon\_inteface eth0  
virtual\_router\_id 151  
priority 100  
advert\_int 5  
nopreempt  
authentication \{  
auth\_type PASS  
auth\_pass 2222  
\}  
virtual\_ipaddress \{  
192.168.111.111  
\}  
\}  
virtual\_server 192.168.111.111 3306 \{  
delay\_loop 6  
lb\_algo wrr  
lb\_kind DR  
persistence\_timeout 60  
protocol TCP  
real\_server 192.168.10.130 3306 \{  
weight 100  
notify\_down /root/shell/mysql\_keepalived.sh  
TCP\_CHECK \{  
connect\_timeout 10  
nb\_get\_retry 3  
delay\_before\_retry 3  
connect\_port 3306  
\}  
\}

TCP\_CHECK  模板只能 检测本机端口    notify\_down检测到端口挂了执行 杀死keepalived 脚本

global\_defs \{  
notification\_email \{  
wgkgood@139.com  
\}  
notification\_email\_from wgkgood@139.com  
smtp\_server 127.0.0.1  
smtp\_connect\_timeout 30  
router\_id LVS\_DEVEL  
\}

vrrp\_script chk\_nginx \{  
script "/data/sh/nginx.sh"  
interval 2  
weight 2  
\}

vrrp\_instance VI\_1 \{  
state BACKUP  
interface eth0  
lvs\_sync\_daemon\_inteface eth0  
virtual\_router\_id 151  
priority 90  
advert\_int 5  
authentication \{  
auth\_type PASS  
auth\_pass 2222  
\}

track\_script \{  
chk\_nginx  
\}

virtual\_ipaddress \{  
192.168.111.188  
\}  
\}

用脚本检测   脚本内容可为

BACKMSG= \`ps -C nginx --noheader |wc -l \`

if \[ $BACKMSG -eq 0 \];then

service keepalived stop

else

exit

notify\_master 脚本 放到VRRP实例  
URL\_CHECK  
HTTP\_GET

配置文件重启keeeplived

需手动加载 **modprobe ip\_vs  ![1086108-20170520144717697-797905163.png][]**

排错

1.编译是否加了内核 没加内核不会启动检测 加了![1086108-20170520153429463-1440762289.png][]

2配置文件是否在 /etc/keepalivde 下  cp -r /usr/local/keepalived/etc/keepalived/ /etc                 最终配置文件/etc/keepalived/keepalived.cof

3是否加载**modprobe ip\_vs   未加载虚拟IP模块 有VIP也不能 其他服务也不能访问VIP**

**4是否VIP与真实IP同一网段且无IP冲突 **

5VIP是否起来 可以用 ip addr list 查看

6 virtual\_router\_id  同一集群的keepalived的主、备机的virtual\_router\_id 必须相同,取值0-255 但是同一内网中不应有相同virtual\_router\_id的集群

7 查看/var/messages日志

转载于:https://www.cnblogs.com/linxizhifeng/p/6843566.html

[1086108-20170511235007457-712225703.png]: /images/20210725/227d4eac2243483fa712b1a02e626d95.png
[1086108-20170520144717697-797905163.png]: /images/20210725/d5f3b48e416348bfb5d853605abd8404.png
[1086108-20170520153429463-1440762289.png]: /images/20210725/eba44409c9cb433ba4bcd6bfcf6ddf3f.png