Hi all,
I’ve upgraded my version haproxy from 1.8 to 3.0.5 and now i get error on applications “mysql gone away”. I reverted to 1.8 and the error is gone, but with version 3.0.5 get back the error.
One solution is stay with version 1.8 but i want upgrade to 3.0.5 for security issues.
I used haproxy on rocky 8 and the service is used only for mysql (galera)
My configuration:
defaults
mode http
log global
option httplog
option dontlognull
option http-server-close
option redispatch
retries 3
timeout http-request 10s
timeout queue 5m
timeout connect 10s
timeout client 5m
timeout server 5m
timeout http-keep-alive 10s
timeout check 10s
maxconn 20000
load-server-state-from-file global
....
frontend galera
bind x.x.x.x:3306
mode tcp
option tcpka
option tcplog
timeout client 480m
acl ipgalera src -f /etc/haproxy/galera.lst
use_backend galera if ipgalera
default_backend trash
backend galera
mode tcp
timeout server 480m
timeout connect 60s
option external-check
external-check path "/usr/bin:/bin:/usr/local/bin"
external-check command /usr/local/bin/mysql_galera.sh
server g1prod y.y.y.y:3306 check inter 5s fall 2 rise 1
server g2prod z.z.z.z:3306 check inter 5s fall 2 rise 1 backup
Any idea about the problem exist with version 3.0.5 and not with 1.8?
Thank you for your help