haproxy负载连接mysql提示 Lost connection to MySQL server
虚拟机环境:
二台虚拟机做 mysql mgr 双主,已成功,也可以进行连接。
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | 1a7f406e-0ffb-11e9-bd17-000c29d7b56e | mgr1 | 3306 | ONLINE |
| group_replication_applier | e2d82e3d-0ff7-11e9-a215-000c298e2917 | mgr2 | 3306 | ONLINE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
一台虚拟机设置haproxy 1.5
listen mysql_proxy
bind 192.168.237.104:33060
mode tcp
balance roundrobin
log 127.0.0.1 local2
option mysql-check user haproxy
option tcplog
option tcpka
timeout connect 10s
timeout client 1m
timeout server 1m
server mysqldb1 192.168.237.101:3306 check inter 5000 rise 2 fall 2
server mysqldb2 192.168.237.102:3306 check inter 5000 rise 2 fall 2
haproxy 启动正常。
mysql 中也有 haproxy 用户,及密码为空
使用 mysql -utest -h192.168.237.104 -P33060 -p
提示:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
mysql也设置了以下参数
skip_name_resolve | ON
connect_timeout | 10
修改了/etc/hosts.allow
mysqld:all:allow
还是一样报以上的错误。