Keepalive 双主搭建配置
keepalived保证双主数据库的可用性
环境说明
192.168.1.10 keepalive 主1
192.168.1.20 keepalive 主2
192.168.1.111 keepalive 主1 从2 VIP
192.168.1.222 keepalive 从1 主2 VIP
1、官网下载最新版本
keepalived-1.2.19
2、部署安装
yum install gcc gcc-c++ make openssl openssl-devel tar zxvf keepalived-1.2.19.tar.gz cd keepalived-1.2.19 ./configure --sysconf=/etc/ --with-kernel-dir=/usr/src/linux --prefix=/usr/local/keepalived make ; make install cp /usr/local/keepalive/sbin/keepalived /usr/bin/ cp /usr/local/keepalived/sbin/keepalived /usr/bin/ cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/ cp /usr/local/keepalived/etc/rc.d/init.d/keepalived /etc/init.d/ chkconfig keepalived on
3、建立配置文件
vim /etc/keepalived/keepalived.conf global_defs { notification_email { cwliu@atman.com } notification_email_from root@localhost smtp_server 127.0.0.1 smtp_connect_timeout 30 router_id Mariadb_keepalive1 } vrrp_script notification { script "/data/ops/script/mail.sh" interval 1 weight 2 } vrrp_script check_alive { script "/data/ops/script/mysql_check.sh" interval 1 weight 2 } vrrp_instance Mariadb_keepalive_channel1 { state MASTER interface eth0 virtual_router_id 100 priority 200 advert_int 1 authentication { auth_type PASS auth_pass 1111 } virtual_ipaddress { 192.168.1.111 } track_script { check_alive } } vrrp_instance Mariadb_keepalive_channel2 { state BACKUP interface eth0 virtual_router_id 101 priority 100 advert_int 1 authentication { auth_type PASS auth_pass 1111 } virtual_ipaddress { 192.168.1.222 } track_script { check_alive } }
4、然后启动即可
/etc/init.d/keepalived start
5、Keepalive 另一主服务器除配置文件不一样，其他配置步骤如上，配置文件如下
vim /etc/keepalived/keepalived.conf global_defs { notification_email { cwliu@atman.com } notification_email_from root@localhost smtp_server 127.0.0.1 smtp_connect_timeout 30 router_id Mariadb_keepalive } vrrp_script notification { script "/data/ops/script/mail.sh" interval 1 weight 2 } vrrp_script check_alive { script "/data/ops/script/mysql_check.sh" interval 1 weight 2 } vrrp_instance Mariadb_keepalive_channel1 { state BACKUP interface eth0 virtual_router_id 100 priority 100 advert_int 1 authentication { auth_type PASS auth_pass 1111 } virtual_ipaddress { 192.168.1.111 } track_script { check_alive } } vrrp_instance Mariadb_keepalive_channel2 { state MASTER interface eth0 virtual_router_id 101 priority 200 advert_int 1 authentication { auth_type PASS auth_pass 1111 } virtual_ipaddress { 192.168.1.222 } track_script { check_alive } }
6、效果图
两台同时运行：
192.168.1.10：
192.168.1.20
192.168.1.10 keepalive 关闭后：
