Hi,
I wonder if anybody has seen this problem with haproxy 1.3.17. We
have a mysql server behind an haproxy and about 5% of the queries hang
and cause haproxy to time out, i.e. the query returns after 150
seconds. On average the query we are issuing takes 0.1 seconds. If
we increase the rate at which we hit the server a higher percentage of
queries seem to time out. The config is below.
Thanks!
ttyl
Dima
# this config needs haproxy-1.1.28 or haproxy-1.2.1
global
log 127.0.0.1 local0
maxconn 10000
chroot /usr/share/haproxy
pidfile /var/run/haproxy.pid
user haproxy
group haproxy
daemon
defaults
mode tcp
retries 3
clitimeout 150000
srvtimeout 150000
contimeout 150000
listen mysql-proxy :3306
mode tcp
log 127.0.0.1 local0
balance roundrobin
#server olddbserver 10.251.162.255:13306
server newdbserver 10.251.131.63:13306
# HTTP response : 'HTTP/1.0 200 OK'
listen http_health_check 0.0.0.0:60001
mode health
option httpchk
--
[email protected]
"The price of reliability is the pursuit of the utmost simplicity.
It is a price which the very rich find the most hard to pay."
(Sir Antony Hoare, 1980)
