MySQL实战七：mycat+keepalived高可用

最新推荐文章于 2024-08-19 20:24:50 发布

qq_28710983

最新推荐文章于 2024-08-19 20:24:50 发布

阅读量3.2k

点赞数 1

分类专栏： MySQL

本文链接：https://blog.csdn.net/qq_28710983/article/details/80938284

版权

MySQL 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

1：安装Keepalived
#yum install keepalived -y


2:MyCat-Master配置
# vi /etc/keepalived/keepalived.conf
! Configuration File for keepalived 
 
global_defs { 
   notification_email { 
     acassen@firewall.loc 
     failover@firewall.loc 
     sysadmin@firewall.loc 
   } 
   notification_email_from Alexandre.Cassen@firewall.loc 
   smtp_server 127.0.0.1 
   smtp_connect_timeout 30 
   router_id MYCAT_HA 
}
vrrp_instance VI_1 { 
    state MASTER 
    interface ens33  
    virtual_router_id 53  
    priority 100    
    advert_int 1   
    authentication { 
        auth_type PASS 
        auth_pass 1111 
    } 
    virtual_ipaddress { 
        192.168.31.53/24 
    } 
} 
virtual_server 192.168.31.53 8066 { 
    delay_loop 6 
    protocol TCP 
    real_server 192.168.31.3 8066 { 
        notify_down "kill -9 $(cat /var/run/keepalived.pid)" 
        TCP_CHECK { 
            connect_port 8066  
            connect_timeout 3  
            nb_get_retry 3  
            delay_before_retry 3  
        } 
    } 
} 


MyCat-BACKUP配置

# vi /etc/keepalived/keepalived.conf
! Configuration File for keepalived 
 
global_defs { 
   notification_email { 
     acassen@firewall.loc 
     failover@firewall.loc 
     sysadmin@firewall.loc 
   } 
   notification_email_from Alexandre.Cassen@firewall.loc 
   smtp_server 127.0.0.1 
   smtp_connect_timeout 30 
   router_id MYCAT_HA 
}
vrrp_instance VI_1 { 
    state BACKUP 
    interface ens33  
    virtual_router_id 53  
    priority 90    
    advert_int 1   
    authentication { 
        auth_type PASS 
        auth_pass 1111 
    } 
    virtual_ipaddress { 
        192.168.31.53/24 
    } 
} 
virtual_server 192.168.31.53 8066 { 
    delay_loop 6 
    protocol TCP 
    real_server 192.168.31.4 8066 { 
        notify_down "kill -9 $(cat /var/run/keepalived.pid)" 
        TCP_CHECK { 
            connect_port 8066  
            connect_timeout 3  
            nb_get_retry 3  
            delay_before_retry 3  
        } 
    } 
}