一：服务器资源

Haproxy+keepalived node1 10.116.19.251

Haproxy+keepalived node2 10.44.90.201

mariadb+galera node1 10.44.66.2

mariadb+galera node2 10.116.148.103

mariadb+galera node3 10.170.142.108

二：mariadb 集群安装

请参照上一篇博文，安装成功后，集群中新增haproxy访问用户

mysql -u root -p
CREATE USER 'haproxy'@' 10.116.19.251';
CREATE USER 'haproxy'@' 10.44.90.201';
FLUSH PRIVILEGES;

三：haproxy 安装

sudo yum install haproxy

配置haproxy vi /etc/haproxy/haproxy.cfg

点击(此处)折叠或打开

#---------------------------------------------------------------------
# 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
#---------------------------------------------------------------------
# main frontend which proxys to the backends
#---------------------------------------------------------------------
frontend main *:5000
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
server static 127.0.0.1:4331 check
#---------------------------------------------------------------------
# round robin balancing between the various backends
#---------------------------------------------------------------------
backend app
balance roundrobin
server app1 127.0.0.1:5001 check
server app2 127.0.0.1:5002 check
server app3 127.0.0.1:5003 check
server app4 127.0.0.1:5004 check
listen mariadb-cluster
bind 0.0.0.0:3306
mode tcp
option tcplog
option mysql-check user haproxy
balance roundrobin
server mdb01 10.44.66.2:3306 check
server mdb02 10.116.148.103:3306 check
server mdb03 10.170.142.108:3306 check
listen web-interface
bind 0.0.0.0:8888
mode http
stats enable
stats uri /
stats realm Strictly\ Private
stats auth admin:admin

启动haproxy

chkconfig haproxy on
/etc/init.d/haproxy start

haproxy 监控结果

四：安装keepalived

sudo yum install keepalived -y

配置haproxy+keepalived node1 vi /etc/keepalived/keepalived.conf

点击(此处)折叠或打开

global_defs {
lvs_id LBL01
}
vrrp_sync_group SyncGroup01 {
group {
FloatIP1
}
}
vrrp_script check_haproxy {
script "killall -0 haproxy"
interval 2
weight 2
}
vrrp_instance FloatIP1 {
state MASTER
interface eth0
virtual_router_id 10
priority 101
advert_int 1
virtual_ipaddress {
192.168.1.60
}
track_script {
check_haproxy
}
}

配置haproxy+keepalived node2 vi /etc/keepalived/keepalived.conf

点击(此处)折叠或打开

global_defs {
lvs_id LBL01
}
vrrp_sync_group SyncGroup01 {
group {
FloatIP1
}
}
vrrp_script check_haproxy {
script "killall -0 haproxy"
interval 2
weight 2
}
vrrp_instance FloatIP1 {
state BACKUP
interface eth0
virtual_router_id 10
priority 100
advert_int 1
virtual_ipaddress {
192.168.1.60
}
track_script {
check_haproxy
}
}

启动keepalived

chkconfig keepalived on

/etc/init.d/keepalived start

ITPub博客

mairadb+galera+haproxy+keepalived实现mysql负载均衡与高可用

最新文章