MyCat Haproxy实践 | Eddie'Blog
MyCat Haproxy实践

MyCat Haproxy实践

eddie 523 2020-11-08

目录

前言

根据之前的文章扩展:Centos7部署MyCAT与测试
实现负载均衡的功能,防止MyCat崩溃,影响业务。

一、准备工作

规划:

序号地址用途
1192.168.8.245:8066MyCAT-A
2192.168.8.246:8066MyCAT-B
3192.168.8.247:5000Haproxy

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 连接

图片.png