mysql: haproxy to mysql 5.7 slave

安装:

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 |
+---------------+-------------------+