CENTOS中如何利用Keepalived构建双主MySQL+双机热备

2.在MySQL-master2：192.168.7.249服务器上keepalived安装及配置

编译安装，实际以本机kernel版本为准

# wget http://www.keepalived.org/software/keepalived-1.2.7.tar.gz

# tar zxvf keepalived-1.2.7.tar.gz

# cd keepalived-1.2.7

# ./configure --prefix=/usr/local/keepalived --with-kernel-dir=/usr/src/kernels/2.6.32-

279.el6.x86_64

# make && make install

设置keepalived开机启动脚本

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

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

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

# chkconfig keepalived on

新建一个配置文件，默认keepalived启动会去/etc/keepalived目录下寻找配置文件

# mkdir /etc/keepalived

# vi /etc/keepalived/keepalived.conf

------------------

global_defs {

notification_email {

lzyangel@126.com

}

notification_email_from lzyangel@126.com

smtp_server stmp.126.com

smtp_connect_timeout 30

router_id MySQL-ha

}

vrrp_instance VI_1{

# 两台配置此处均是BACKUP

state BACKUP

# 注意网卡接口

interface eth0

virtual_router_id 51

# 优先级，另一台改为100

priority 90

advert_int 1

# 不主动抢占资源

nopreempt

authentication {

auth_type PASS

auth_pass 1111

}

virtual_ipaddress {

192.168.7.253

}

}

virtual_server 192.168.7.253 3306 {

# 每个2秒检查一次real_server状态

delay_loop 2

# LVS算法

lb_algo wrr

# LVS模式

lb_kind DR

# 会话保持时间

persistence_timeout 60

protocol TCP

real_server 192.168.7.249 3306 {

weight 3

# 检测到服务down后执行的脚本

notify_down /etc/rc.d/keepalived.sh

TCP_CHECK {

# 连接超时时间

connect_timeout 10

# 重连次数

nb_get_retry 3

# 重连间隔时间

delay_before_retry 3

# 健康检查端口

connect_port 3306

}

}

}

----------------------

编写检测服务down后所要执行的脚本

# vi /etc/rc.d/keepalived.sh

-------------

#!/bin/sh

/etc/init.d/keepalived stop

-------------

# chmod +x /etc/rc.d/keepalived.sh

启动keepalived

# /etc/init.d/keepalived start

查看连接状态

# ps -aux | grep keepalived

返回：

---------------

root 1387 1 0 21:13 ? 00:00:00 keepalived -D

root 1390 1387 0 21:13 ? 00:00:00 keepalived -D

root 1391 1387 0 21:13 ? 00:00:00 keepalived -D

root 1976 1911 0 21:16 pts/0 00:00:00 grep keepalived

--------------------

至此配置完成，网站后台只需要配置MySQL-VIP：192.168.7.253虚拟地址即可

这里实际连接的master数据库，以哪台master先开mysql服务为准。

当master1：192.168.7.201 mysql端口挡掉或者服务器异常关闭，keepalived会自动跳转到master2：192.168.7.249.

因为两台数据库的数据时同步的,用户访问的是MySQL-VIP：192.168.7.253虚拟地址，所以网站数据连接会无缝透明转接到master2服务器，实现双机热备+数据同步功能。保证网站数据库的实时可用性。

注：当某一台master服务器挂掉恢复后，需同时打开MYSQL服务和keepalived服务，保证另一台服务器如果挂掉会无缝转接。

所以建议mysql与keeplived设置服务开机启动。

# chkconfig mysqld on

# chkconfig keepalived on

----------大功告成------------

本文出自 “一路向北” 博客，请务必保留此出处http://showerlee.blog.51cto.com/2047005/1188549

（编辑：佛山站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!