mysql router单点_MySQL Router单点隐患通过Keepalived实现

目录

一、介绍

有些情况下，可能MySQL Router不便装在每个应用所在的服务器上，那么这时候要解决MySQL Router的单点故障，就需要用到keepalived或者pacemaker了，本文介绍了MySQL Router HA通过keepalived来实现。

二、环境准备

IP地址

角色

172.16.8.53

MySQL Router+MASTER

172.16.8.68

MySQL Router+BACKUP

172.16.8.24

VIP

keepalived版本：2.0.18

三、安装步骤

下载软件包，解压

mkdir /software

wget https://www.keepalived.org/software/keepalived-2.0.18.tar.gz -P /software

tar -zxvf /software/keepalived-2.0.18.tar.gz ; cd /software/keepalived

源码安装

yum -y install openssl* libnl‐dev* gcc-c++

./configure --prefix=/usr/local/keepalived

make

make install

配置keepalived

mkdir /etc/keepalived

cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/

cp /data/keepalived-2.0.18/keepalived/etc/init.d/keepalived /etc/init.d/

cp /data/keepalived-2.0.18/keepalived/etc/sysconfig/keepalived /etc/sysconfig/

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

修改keepalived配置文件

MASTER

! Configuration File for keepalived

global_defs {

notification_email {

zhenweizheng@upchina.com

}

notification_email_from 13912345678@139.com

smtp_server smtp.139.com

smtp_connect_timeout 30

router_id Router1

vrrp_skip_check_adv_addr

# vrrp_strict

vrrp_garp_interval 0

vrrp_gna_interval 0

}

vrrp_script chk_mysqlrouter {

script "/usr/bin/killall -0 /usr/bin/mysqlrouter" # check the haproxy process

interval 2 # every 2 seconds

weight 2 # add 2 points if OK

fall 2

}

vrrp_instance VI_1 {