Thanks. will share screenshot shortly. roundrobin recommented for mysql also?
On Fri, Feb 28, 2014 at 3:22 PM, Baptiste <bed...@gmail.com> wrote: > Hi, > > this may be due to your load-balancing algorithm and the speed of your > servers. > leastconn applies to currently established connections, not to number > of connections established per second. > > could you enable haproxy stats page and share us (or to me directly) a > screenshot of it? > > You could give a try to 'balance roundrobin' and see what happens. > > Baptiste > > > On Fri, Feb 28, 2014 at 9:41 AM, vijeesh vijayan > <vijeeshk.vija...@gmail.com> wrote: > > we are using haproxy (1.4)to distribute traffic to 30 of our db nodes. > > we are facing an issue with weights. > > > > sample configs > > > > ========================= > > defaults > > mode tcp > > retries 2 > > option redispatch > > maxconn 256000 > > timeout connect 10s > > timeout client 10s > > timeout server 10s > > > > > > log global > > > > option dontlognull > > > > > > > > listen newone :4000 > > mode tcp > > > > balance leastconn > > option mysql-check user abcd > > > > > > server x.x.x.3:3306 weight 125 check inter 3s rise 2 fall 2 > > > > server y.com x.x.x.4:3306 weight 12 check inter 3s rise 2 fall 2 > > server y.com x.x.x.4:3306 weight 12 check inter 3s rise 2 fall 2 > > ===================== > > > > > > issue is we are getting only 150qps on server x.com even with weight > 125. > > > > but on y.com we are getting 500qps with a weight of 12 , but mentioned > > twice. > > > > > > can you explain why it is so? > > > > > > > > -- > > ========================= > > Vijeesh K > > "The temptation to quit will be greatest just before you are about to > > succeed" > -- ========================= Vijeesh K "The temptation to quit will be greatest just before you are about to succeed"