mycat+haproxy服务与高可用（

#---------------------------------------------------------------------
# Example configuration for a possible web application.  See the
# full configuration options online.
#
#   http://haproxy.1wt.eu/download/1.4/doc/configuration.txt
#
#---------------------------------------------------------------------

#---------------------------------------------------------------------
# Global settings
#---------------------------------------------------------------------
global
    # to have these messages end up in /var/log/haproxy.log you will
    # need to:
    #
    # 1) configure syslog to accept network log events.  This is done
    #    by adding the '-r' option to the SYSLOGD_OPTIONS in
    #    /etc/sysconfig/syslog
    #
    # 2) configure local2 events to go to the /var/log/haproxy.log
    #   file. A line like the following can be added to
    #   /etc/sysconfig/syslog
    #
    #    local2.*                       /var/log/haproxy.log
    #
    log         127.0.0.1 local2

    chroot      /var/lib/haproxy
    pidfile     /var/run/haproxy.pid
    maxconn     4000
    user        haproxy
    group       haproxy
    daemon

    # turn on stats unix socket
    stats socket /var/lib/haproxy/stats

#---------------------------------------------------------------------
# common defaults that all the 'listen' and 'backend' sections will
# use if not designated in their block
#---------------------------------------------------------------------
defaults
    mode                    http
    log                     global
    option                  httplog
    option                  dontlognull
    option http-server-close
    option forwardfor       except 127.0.0.0/8
    option                  redispatch
    retries                 3
    timeout http-request    10s
    timeout queue           1m
    timeout connect         10s
    timeout client          1m
    timeout server          1m
    timeout http-keep-alive 10s
    timeout check           10s
    maxconn                 3000

#---------------------------------------------------------------------
# listen page
#---------------------------------------------------------------------
listen stats
    mode http
    bind 0.0.0.0:1080
    stats enable
    stats hide-version
    stats uri     /listen-page
    stats realm   welcome login\ listen-page
    stats auth    admin:000000
    stats admin if TRUE

#---------------------------------------------------------------------
# main frontend which proxys to the backends
#---------------------------------------------------------------------
frontend  main *:80                      #haproxy的监听端口
    acl url_static       path_beg       -i /static /images /javascript /stylesheets
    acl url_static       path_end       -i .jpg .gif .png .css .js

    use_backend static          if url_static
    default_backend             app

#---------------------------------------------------------------------
# static backend for serving up images, stylesheets and such
#---------------------------------------------------------------------
backend static
    balance     roundrobin
    option httpchk GET /index.html
    server      static1 192.168.9.35:80 check port 80 inter 5s rise 2 fall 3

#---------------------------------------------------------------------
# round robin balancing between the various backends
#---------------------------------------------------------------------
backend app
    balance     roundrobin
    server      app1 192.168.9.35 check port 80 inter 5s rise 2 fall 3
    server      app2 192.168.9.36 check port 80 inter 5s rise 2 fall 3

[root@haproxy ~]# vim /etc/keepalived/keepalived.conf 

! Configuration File for keepalived
global_defs {
   router_id master                              #此处唯一
}
vrrp_script checkhaproxy {
        script "/usr/local/bin/chk_haproxy.bash"
        weight -20
        interval 3
}
vrrp_instance VI_1 {
    state MASTER                             #此处为MASTER或BACKUP
    interface ens33
    virtual_router_id 51                      #此处为虚拟组，要相同表示一个组
    priority 100                                   #此处为优先级，MASTR要大
    advert_int 1                                  #广播时间间隔
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    track_script {
            checkhaproxy
    }
    virtual_ipaddress {
        192.168.9.202/24
    }
}

[root@haproxy-keeplived ~]# vim /etc/keepalived/keepalived.conf 

! Configuration File for keepalived
global_defs {
   router_id slave
}
vrrp_script checkhaproxy {
        script "/usr/local/bin/chk_haproxy.bash"
        weight -20
        interval 3
}
vrrp_instance VI_1 {
    state BACKUP
    interface ens33
    virtual_router_id 51
    priority 90
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    track_script {
        checkhaproxy
    }
    virtual_ipaddress {
        192.168.9.202/24
    }
}

       ＃组播组用于IPv4 VRRP通告
       ＃（默认值：224.0.0.18）
       vrrp_mcast_group4 224.0.0.18

       #Multicast Group用于IPv6 VRRP通告
       ＃（默认值：ff02 :: 12）
       vrrp_mcast_group6 ff02 :: 12

#!/bin/bash
count=`ps aux | grep -v grep | grep haproxy.cfg | wc -l`
if [ $count -gt 0 ]; then
    exit 0
else
    pkill keepalived
    exit 1
fi

#!/bin/bash
lb01_vip=192.168.0.240
lb01_ip=192.168.0.221
while true
do
ping -c 2 -W 3 $lb01_ip &>/dev/null
if [ $? -eq 0 -a `ip a | grep "$lb01_vip" | wc -l` -eq 1 ];then
echo "ha is split brain.warning."
else
echo "ha is OK"
fi
sleep 5
done