Haproxy+MySQL实现负载均衡

Haproxy+MySQL搭建如下

要求: 做负载之前需要把mysql的双主关系做好。

#1. 安装haproxy
yum install -y haproxy

#2. 编辑配置文件haproxy
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
        log global
        log 127.0.0.1 local3
        mode http
        option tcplog
        option dontlognull
        retries 10
        option redispatch
        maxconn 2000
        timeout connect 10s
        timeout client 1m
        timeout server 1m
        timeout http-keep-alive 10s
        timeout check 10s
 
listen mysql
        bind *:7063
        mode tcp
        balance roundrobin
        server mysql1 192.168.1.6:3306 check inter 2000 rise 1 fall 2
        server mysql2 192.168.1.7:3306 check inter 2000 rise 1 fall 2
 
listen stats
        bind *:1080
        mode http
        option httplog
        maxconn 10
        stats refresh 30s
        stats uri /stats
        stats realm XingCloud\ Haproxy
        stats auth admin:admin #用这个账号登录，可以自己设置
        stats auth Frank:Frank
        stats hide-version
        stats admin if TRUE


#3. 重启或启动haproxy 
systemctl start haproxy

#4. 在数据库建立个测试账号
mysql>grant all on *.* to 'admin'@'%' identified by 'admin';
mysql>flush privileges;

#5. 测试：
mysql -uadmin -padmin -h192.168.1.7 -P7063

#用配置文件：Frank:Frank账号密码登录haproxy web页面查看信息：
192.168.1.6:1080/stats