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>
