目录
前言
根据之前的文章扩展:Centos7部署MyCAT与测试
实现负载均衡的功能,防止MyCat崩溃,影响业务。
一、准备工作
规划:
序号 | 地址 | 用途 |
---|---|---|
1 | 192.168.8.245:8066 | MyCAT-A |
2 | 192.168.8.246:8066 | MyCAT-B |
3 | 192.168.8.247:5000 | Haproxy |
Haproxy 之后简称为:“HA”
二、安装第二台MyCat
复制 245 服务器上的文件夹
scp -r root@192.168.8.245:/opt/mycat .
启动两台服务器的MyCat服务
[root@tracker opt]# cd mycat
[root@tracker mycat]# ./bin/mycat start
Starting Mycat-server...
三、安装HA
通过 yum 方式安装
yum search haproxy
yum -y install haproxy.x86_64
[root@storage ~]# vim /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
mode tcp ######## 此处需要改为TCP,MyCAT只支持TCP
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 192.168.8.245:8066 check ######## MyCAT地址
server app2 192.168.8.246:8066 check ######## MyCAT地址
#server app3 127.0.0.1:5003 check
#server app4 127.0.0.1:5004 check
四、运行
haproxy -f /etc/haproxy/haproxy.cfg
使用 Navicat 连接