一:服务器资源
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
启动haproxy
chkconfig haproxy on
/etc/init.d/haproxy start
haproxy 监控结果
四:安装keepalived
sudo yum install keepalived -y
配置haproxy+keepalived node1 vi /etc/keepalived/keepalived.conf
配置haproxy+keepalived node2 vi /etc/keepalived/keepalived.conf
启动keepalived
chkconfig keepalived on
/etc/init.d/keepalived start
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博客 ” ,链接:http://blog.itpub.net/28624388/viewspace-2137324/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28624388/viewspace-2137324/