List:General Discussion« Previous MessageNext Message »
From:Jaime Crespo Rincón Date:December 22 2009 9:14am
Subject:Re: mysql load balancing
View as plain text  
2009/12/21 Miguel Angel Nieto <correo@stripped>:
> Hi,
>
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
>
> What do you prefer?

Hi,

The solutions I have heard most from our customers (in production) are
not mysql-specific:

1) Simple, not load-aware *DNS balancing* for simple applications
without fault-tolerance: http://en.wikipedia.org/wiki/Round_robin_DNS
2) More complex and customizable *Linux Virtual Server*, with
integrated heartbeat and "session aware":
http://www.linuxvirtualserver.org/

It depends a lot on how you plan to coordinate the db servers
(sharding, replication, ndb), the kind of applications you are going
to deploy and how much scability you need.

I hope that helps. Regards,
-- 
Jaime Crespo
MySQL & Java Instructor
Warp Networks
<http://warp.es>
Thread
mysql load balancingMiguel Angel Nieto21 Dec
  • Re: mysql load balancingJaime Crespo Rincón22 Dec
    • Re: mysql load balancingMiguel Angel Nieto22 Dec
      • Re: mysql load balancingJaime Crespo Rincón24 Dec
        • Re: mysql load balancingPascal Charest24 Dec
  • Re: mysql load balancingBaron Schwartz25 Dec
    • Re: mysql load balancingMiguel Angel Nieto25 Dec
      • Re: mysql load balancingBaron Schwartz29 Dec
    • RE: mysql load balancingNeil Aggarwal26 Dec