HI,
>It should not because as you can see in the trace, the whole check happens in
>only 2 milliseconds, which is quite fast. What are the other parameters you
>changed ? Could you also please share all your timeouts ? Maybe some of
>them are wrong ?
>
I am getting a layer 4 timeout in the environment where I should get this
running. Here is my file -
global
pidfile /var/run/haproxy1.pid
stats socket /tmp/haproxy
defaults
log global
timeout connect 50000 # default 10 second time out if a backend is not found
timeout client 30000
timeout server 30000
listen stats :1936
mode http
stats enable
stats realm Haproxy\ Statistics
stats uri /
frontend mysql_proxy *:3309
mode tcp
default_backend request_mysql
backend request_mysql
mode tcp
option mysql-check user haproxy
server svr2 192.168.8.37:3406 weight 1 check port 3406 inter 5000 rise
3 fall 3
server svr1 192.168.2.27:3306 weight 1 check port 3306 inter 5000 rise
3 fall 3
Please note that the IPs have changed and now they are both windows machines.
Do we need MySQL client to be installed on the m/c for this to work?
Regards,
Jayadevan
DISCLAIMER: "The information in this e-mail and any attachment is intended only
for the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly contact
the sender and destroy all copies of the original communication. IBS makes no
warranty, express or implied, nor guarantees the accuracy, adequacy or
completeness of the information contained in this email or any attachment and
is not liable for any errors, defects, omissions, viruses or for resultant loss
or damage, if any, direct or indirect."
