2009/12/21 Miguel Angel Nieto <correo@stripped>:
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
> What do you prefer?
The solutions I have heard most from our customers (in production) are
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":
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,
MySQL & Java Instructor