MySQL+keepalived的高可用自动切换实现教程
Keepalived安装配置:
[root@localhost ~]# wget
tar zxf keepalived-1.2.13.tar.gz
cdkeepalived-1.2.13
yum install gcc gcc-c++
yum install kernel-devel -y
[root@localhost keepalived-1.2.13]# ./configure --with-kernel-dir=/usr/src/kernels/2.6.32-696.20.1.el6.x86_64/
&&make && make install
[root@localhost keepalived-1.2.13]# DIR=/usr/local/
[root@localhost keepalived-1.2.13]# cp /usr/local/etc/rc.d/init.d/keepalived /etc/rc.d/init.d/
[root@localhost keepalived-1.2.13]# cp /usr/local/etc/sysconfig/keepalived /etc/sysconfig/ && mkdir -p /etc/keepalived
[root@localhost keepalived-1.2.13]# cp /usr/local/sbin/keepalived /usr/sbin/
修改Master服务器上keepalived.conf配置如下,vi /etc/keepalived/keepalived.conf
! Configuration File for keepalived
global_defs {
notification_email {
251469868@qq.com
}
notification_email_from 251469868@qq.com
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id LVS_DEVEL
}
#VIP1
vrrp_instance VI_1 {
state MASTER
interface eth0
lvs_sync_daemon_inteface eth0
virtual_router_id 151
priority 100
advert_int 5
#nopreempt
authentication {
auth_type PASS
auth_pass 2222
}
virtual_ipaddress {
192.168.227.100
}
}
virtual_server 192.168.227.100 3306 {
delay_loop 6
lb_algo wrr
lb_kind DR
persistence_timeout 60
protocol TCP
real_server 192.168.227.138 3306 {
weight 100
notify_down /data/sh/msyql.sh
TCP_CHECK {
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
connect_port 3306
}
}
}
[root@localhost keepalived]# /etc/init.d/keepalived restart
停止 keepalived: [失败]
正在启动 keepalived: [确定]
[root@localhost keepalived]# /etc/init.d/keepalived restart
停止 keepalived: [确定]
正在启动 keepalived: [确定]
[root@localhost keepalived]# ps -ef |grep keep
root 46101 30792 0 07:57 pts/0 00:00:00 vi keepalived.conf
root 46140 1 0 07:59 00:00:00 keepalived -D
root 46142 46140 0 07:59 00:00:00 keepalived -D
root 46143 46140 0 07:59 00:00:00 keepalived -D
root 46148 30792 0 07:59 pts/0 00:00:00 grep keep
[root@localhost keepalived]# tail -fn100 /var/log/messages
[root@localhost keepalived]# cd
[root@localhost ~]# modprobe ip_vs
[root@localhost ~]# lsmod |grep ip_vs
ip_vs 125694 1
libcrc32c 1246 1 ip_vs
ipv6 334932 294 ip_vs,ip6t_REJECT,nf_conntrack_ipv6,nf_defrag_ipv6
[root@localhost ~]# /etc/init.d/keepalived restart
停止 keepalived: [确定]
正在启动 keepalived: [确定]
[root@localhost ~]# tail -fn 10 /var/log/messages
Mysql 从服务器配置keepalived.conf跟master 一样,只需要把Realserver IP修改成
real_server 192.168227.139;优先级从100改为90即可
在master、slave数据库上创建/data/sh/mysql.sh脚本,内容为:
pkill keepalived
然后分别重启两台数据库上keepalive服务即可,最后测试停止master mysql 服务,是否会自动切换
到backup上
上一篇: SQL临时表调用存储过程
下一篇: 常用的SQL语句
推荐阅读
-
MySQL+keepalived的高可用自动切换实现教程
-
用shell脚本实现自动切换内网和外网实现高可用
-
DB2+HADR+TSA高可用性测试--DB2HAICU配置TSA实现故障自动切换_PHP教程
-
用shell脚本实现自动切换内网和外网实现高可用
-
Ubuntu搭建Mysql+Keepalived高可用的实现(双主热备)
-
使用MySQL Router实现高可用、负载均衡、读写分离的详细教程
-
关于使用Keepalived实现Nginx的自动重启及双主热备高可用问题
-
MySQL高可用方案:基于MHA实现的自动故障转移群集_MySQL
-
MySQL+keepalived的高可用自动切换实现教程
-
DB2+HADR+TSA高可用性测试--DB2HAICU配置TSA实现故障自动切换_PHP教程