Keepalived实现原理:Keepalived详细介绍简介

实验环境

Master1、Amoeba--IP:192.168.1.5

Master2---IP:192.168.1.10

同时安装keepalived

依赖包
[root@dep5 keepalived-1.1.20]# yum install openssl-devel popt-devel -y
make clean&& make clean all

tar -xvf keepalived-1.1..tar.gz && cd keepalived-1.1. && ./configure --prefix=/usr/local/keepalived && make && make install && cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/rc.d/init.d/ && cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/ &&  mkdir /etc/keepalived && cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/ &&  cp /usr/local/keepalived/sbin/keepalived /usr/sbin/

#############必须给检查文件给执行权限
chmod /etc/keepalived/manage_mysql/ -x -R

双主都需要设置用户
grant all on *.* to keepalived@'%' identified by 'keepalived';

双主都需要安装keepalived并且配置
keepalived配置文件

! Configuration File for keepalived
global_defs {
notification_email {
acassen@firewall.loc
failover@firewall.loc
sysadmin@firewall.loc
}
notification_email_from Alexandre.Cassen@firewall.loc
smtp_server 192.168.200.1
smtp_connect_timeout
router_id MYSQLHA_DEVEL
} vrrp_script check_mysqld {
script "/etc/keepalived/mysqlcheck/check_mysql.sh" #检查MYSQL 复制状态脚本
interval
weight
} vrrp_instance VI_1 {
state BACKUP #这里主201和主202都写上BACKUP
interface eth0 #vip对外的网络接口
virtual_router_id #标识号。。主主要统一起来
priority #优先级。主202上改成90
advert_int
# nopreempt #不抢占模式。在优先级高的那台设置此参数,一般在主上设置,主的优先级高 authentication {
auth_type PASS
auth_pass
} track_script {
check_mysqld #调用MYSQL脚本的函数
} virtual_ipaddress {
192.168.5.10/
}
}

检查Mysql状态脚本

#!/bin/bash
#Totle:check_mysql
#Description:Check mysql status
#system:Use Linux
#======================================
#Set mysql host
#每个机器改成自己的IP地址和远程授权的用户
Host_S=192.168.1.5
User_S=keepalived
Pwss_S=keepalived
Port_S=3306
#======================================
#Function-->Check_mysql_IO
#=====================================
Check_mysql_IO()
{ Check_IO=`mysql -u$User_S -p$Pwss_S -h $Host_S -P $Port_S -e "show slave status\G" | grep "Runnin" | sed 's/ //g' | grep "IO" | awk -F: '{print $NF}' | grep "Yes" | wc -l` Check_SQL=`mysql -u$User_S -p$Pwss_S -h $Host_S -P $Port_S -e "show slave status\G" | grep "Runnin" | sed 's/ //g' | grep "SQL" | awk -F: '{print $NF}' | grep "Yes" | wc -l` if [ $Check_IO -ne 1 -o $Check_SQL -ne 1 ]
then
/etc/init.d/keepalived stop
return 1
else
Check_PID=`/etc/init.d/keepalived status | grep "pid" | wc -l`
if [ $Check_PID -eq 1 ]
then
echo "OK"
exit 0
else
/etc/init.d/keepalived start
if [ $? -eq 0 ]
then
echo "keepalived start ok" >/tmp/checkmysql.log
exit 0
else
echo "keepalived start fail..">/tmp/checkmysql.log
return 1
fi
fi
fi
} #======================================
#Function-->Main
#=====================================
Main()
{ Check_mysql_IO
if [ $? -eq 1 ]
then
echo "Mysql $Host_S IO or SQL error" | mail -s "Mysql IO error" 50738846@qq.com
exit 1
fi }
Main;

最新文章

  1. JS和JSON的区别
  2. 【博客美化】08.添加"扩大/缩小浏览区域大小" 按钮
  3. C#------如何获取本机IP地址
  4. HDU1294 Rooted Trees Problem(整数划分 组合数学 DP)
  5. 14SpringMvc_在业务控制方法中写入HttpServletRequest,HttpServletResponse等传统web参数(这个知识点知道就好了,不推荐这么去做)
  6. matlab 之字体调整
  7. ViewPager撤消左右滑动切换功能
  8. 添加远程链接MySQL的权限
  9. Cookie API
  10. Hibernate 主键生成策略
  11. 搭建lamp环境Q&A
  12. Python中切片的工作原理
  13. vue中部分api解释 ($nextTick)
  14. std::string 用法总结
  15. asp.net mvc 实现上传文件带进度条
  16. Git的安装和创建版本库
  17. 力奋github:https://github.com/birdstudiocn
  18. js-图片时间(倒计时)
  19. Musle比对软件
  20. 【模板】 全排列 && 有重复元素的全排列

热门文章

  1. 【floyd 多源最短路】 poj 1125
  2. Mishka and Interesting sum
  3. Dynamic Performance Tables not accessible Automatic Statistics disabled for this session
  4. mysql问题总结,远程登录
  5. 快学Scala-第四章 映射和元组
  6. python 中调用shell命令
  7. angular项目——小小记事本1
  8. HDU - 1083 Courses /POJ - 1469
  9. SQL Server 2012 - 内置函数
  10. Polygone对象