HAproxy - Linux 安装并反向代理MySQL

HAproxy - Linux 安装并反向代理MySQL

安装

yum search haproxy

yum yinstall haproxy.x86_64 -y

 配置

• 192.168.213.156:3306 与 192.168.213.162:3306 是两个 mysql 服务

vim /etc/haproxy/haproxy.cfg

global
    log         127.0.0.1 local2

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

    stats socket /var/lib/haproxy/stats

defaults
    mode                    tcp
    log                     global
    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

frontend  main *:5000

    default_backend             app

backend app
    balance     roundrobin
    server  app1 192.168.213.156:3306 check
    server  app2 192.168.213.162:3306 check

启动

haproxy -f /etc/haproxy/haproxy.cfg

测试