mysql-MHA预发布环境架构分享(五)之keepalived安装
安装keepalivetar zxf keepalived-1.2.2.tar.gzcd keepalived-1.2.2./configure --sysconf=/etc --with-kernel-dir=/usr/src/kernels/2.6.18-164.el5-x86_64sudo makesudo make installsudo cp /usr/local/sbin/keepalived /sbin/keepalivedservice keepalived startservice keepalived stop
make时报错如下：
解决方法：进入源码目录cd keepalived-1.2.2vi keepalived/libipvs-2.6/ip_vs.h找到下面一行：#include <linux/types.h> /* For __beXX types in userland */把他放到如下一行的下面：#include <sys/types.h>接下来顺利make了。
-----------编辑keepalived资源配置文件-----------
vim/etc/keepalived/keepalived.conf! Configuration File for keepalivedglobal_defs { router_id MYSQL-ha}vrrp_script check_running { script"/etc/keepalived/keepalived_check_mysql.sh" interval 5}vrrp_instance PWRD_1 { state BACKUP interface bond0 virtual_router_id 88 priority 150 #[另一台是100] advert_int 1 nopreempt #[另一台不加] authentication{ auth_type PASS auth_pass 99999 } virtual_ipaddress { 10.142.132.49 } track_script { check_running } notify_master/etc/keepalived/master.sh notify_backup/etc/keepalived/slave.sh notify_fault/etc/keepalived/notify_fault.sh notify_stop/etc/keepalived/down.sh}
vikeepalived_check_mysql.sh
#!/bin/bashMYSQL=/app/mysql/bin/mysqlMYSQL_HOST=localhostMYSQL_USER=rootMYSQL_PASSWORD=mysqlCHECK_COUNTS=3
#mysql is working MYSQL_OK is 0 , mysql isnot working MYSQL_OK is 1MYSQL_OK=0
function check_Mysql_Runing (){
$MYSQL -h $MYSQL_HOST -u $MYSQL_USER -p${MYSQL_PASSWORD}-e "show grants;" >/dev/null 2>&1
if [ $? = 0 ] ;then MYSQL_OK=0
else MYSQL_OK=1
fireturn $MYSQL_OK
}
while [ $CHECK_COUNTS -ne 0 ]
do let"CHECK_COUNTS -= 1"
check_Mysql_Runing
if [ $MYSQL_OK= 0 ] ; then
echo "mysql is runing!"
exit 0 fi
if [ $MYSQL_OK-eq 1 ] && [ $CHECK_COUNTS -eq 0 ] then
echo "mysql is not runing!"
exit 1 fi
sleep 1done
vim/etc/keepalived/master.sh
#!/bin/bashecho "#`date +"%Y-%m-%d%H:%M"` change master status!!! " >> /etc/keepalived/change.log
vim/etc/keepalived/slave.sh#!/bin/bashecho "#`date +"%Y-%m-%d%H:%M"` change slave status!!!" >> /etc/keepalived/change.log
vim/etc/keepalived/notify_fault.sh
#!/bin/bashecho "#`date +"%Y-%m-%d%H:%M"` change notify_fault status!!!" >>/etc/keepalived/change.log
sleep 3
echo "#`date +"%Y-%m-%d%H:%M"` try startup mysql!!!" >> /etc/keepalived/change.log
service mysql start
vim/etc/keepalived/down.sh
#!/bin/bashecho "#`date +"%Y-%m-%d%H:%M"` keepalived is down!!!" >> /etc/keepalived/change.log
chmod +x keepalived_check_mysql.shchmod +x /etc/keepalived/master.shchmod +x /etc/keepalived/slave.shchmod +x /etc/keepalived/notify_fault.shchmod +x /etc/keepalived/down.shmysql -h10.142.132.49 -ulipengfei-plipengfei
测试SHOW VARIABLES LIKE 'server_id';【查看当前是哪个mysql主机】
页:
[1]