mysql主从高可用用f5_MySQL主从高可用

MySQL主从不介绍

安装keepalived

keepalived在epel源，需要先安装epel

然后直接yum 安装keepalive

默认配置文件安装在/etc/keepalived/下

! Configuration File for keepalived

global_defs {

router_id MySQL-HA

}

vrrp_script check_run {

script "/home/mysql/mysql_check.sh" #脚本权限

interval 5

}

vrrp_instance VI_1 {

state MASTER #备机BACKUP

interface bond0 #网卡地址

virtual_router_id 51

priority 100 #优先级

advert_int 1

authentication {

auth_type PASS

auth_pass 1111

}

track_script {

check_run

}

virtual_ipaddress {

10.205.28.20

}

}

MySQL检查脚本

#!/bin/bash

count=1

mysql -uroot -pzkjin@mysql123 -S /home/mysql/mysql3306/mysql3306.sock -e "show status;" > /dev/null 2>&1

i=$?

j=`ps aux | grep mysqld | grep -v grep|wc -l`

if [ $i != 0 ] && [ $j != 2 ]

then

systemctl stop keepalived

fi