安装:
yum install haproxy
编辑配置文件:
[root@test1 haproxy]# vim haproxy.cfg
启动服务:
[root@test1 haproxy]# systemctl status haproxy
[root@test1 haproxy]# systemctl start haproxy
日志检查:
[root@test1 rsyslog.d]# tail -20 /var/log/haproxy.log
Oct 26 10:35:27 test1 haproxy-systemd-wrapper: haproxy-systemd-wrapper: SIGTERM -> 7063.
Oct 26 10:35:27 test1 haproxy-systemd-wrapper: haproxy-systemd-wrapper: exit, haproxy RC=0
Oct 26 10:35:30 test1 haproxy-systemd-wrapper: haproxy-systemd-wrapper: executing /usr/sbin/haproxy -f /etc/haproxy/haproxy.cfg -p /run/haproxy.pid -Ds
Oct 26 10:35:30 localhost haproxy[11323]: Proxy mysql-57 started.
Oct 26 10:35:30 localhost haproxy[11323]: Proxy stats started.
检查haproxy服务状态:
[root@test1 haproxy]# netstat -ntl | grep "3307\|8888"
tcp 0 0 192.168.2.30:3307 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:8888 0.0.0.0:* LISTEN
测试负载均衡到slave上:
[root@test2 ~]# /usr/local/mysql56/bin/mysql -uroot -poracle -h192.168.2.30 -P3307 -e"show variables like 'hostname'"
Warning: Using a password on the command line interface can be insecure.
+---------------+-------------------+
| Variable_name | Value |
+---------------+-------------------+
| hostname | test4.localdomain |
+---------------+-------------------+
[root@test2 ~]# /usr/local/mysql56/bin/mysql -uroot -poracle -h192.168.2.30 -P3307 -e"show variables like 'hostname'"
Warning: Using a password on the command line interface can be insecure.
+---------------+-------------------+
| Variable_name | Value |
+---------------+-------------------+
| hostname | test3.localdomain |
+---------------+-------------------+