HAProxy and MySQL

2009-08-07 Thread Evgeniy Sudyr
Hi, I'm trying to use HAProxy as round robin load balancer for 2 MySQL servers. I'm using mysqlslap for benchmarking. At the moment I figured that load balanced connection is slowest in times. I need explanation from HAProxy experts why ? There is my config: cat /etc/haproxy/haproxy.cfg global

Re: Multiple config files

2009-08-07 Thread Jeremy
Ahhh 1.3.19 that just came out supports this, yay. Thanks!

Re: Multiple config files

2009-08-07 Thread Jeremy
Ahh only 10 files? http://haproxy.1wt.eu/git?p=haproxy.git;a=commit;h=5d01a63b7862235fdd3119cb29d5a0cfd04edb91 I was hoping more like hundreds i.e. 1 per site on a busy server :-) No big deal I see someone made some haproxy_join script but I'll probably make some dead simple shell script that

RE: HAProxy and MySQL

2009-08-07 Thread John Lauro
Nearly an extra .1 seems high, but to be fair it doesn’t appear you did much of a test: Number of clients running queries: 1 Average number of queries per client: 0 Simulating only 1 client, I wouldn’t expect any performance improvement, and without doing any queries, you

Stats as counters for graphing

2009-08-07 Thread Karl Pietri
Is there any way to get the # of queued connections for a backend as a counter so that i can graph it properly? as far as i can tell at any random time i pull the stats it gives me the current number, which isn't that useful, i need to get the # that happened since the last time i pulled the

RE: Stats as counters for graphing

2009-08-07 Thread John Lauro
(ignore previos message that had this response replying to wrong message.) I set my to alert if ever non 0 for queue and for my graphs I just use current sessions, and also total connections (graph as delta / sec) for connection rate. I assume you normally have a queue during busy times

Re: Stats as counters for graphing

2009-08-07 Thread Karl Pietri
The last couple of days we have had a spike in traffic so it has been queueing, but i can't tell for sure if its just general overloaded during peak or if we have some random large spikes (which would be ok). from other tools i'm pretty sure we are overloaded and so adding new machines, but in

WARNING: Nasty bug in haproxy 1.3.19

2009-08-07 Thread Willy Tarreau
Hi all, With the very kind help from Cristian Ditoiu, I've just isolated a very nasty bug introduced in 1.3.19 by the fix for the timer drift : http://haproxy.1wt.eu/git?p=haproxy-1.3.git;a=commitdiff;h=4de2dea8076782d0685cd1f25edfb961d3a9d40c If you are running a configuration with some