On Thu, May 13, 2004 at 06:49:01AM -0400, PARTHA DUTTA, BLOOMBERG/ 499 PARK wrote:
> Hello all, I would like to find out if anyone has implemented an architecture
> where a hardware load balancer is placed in front of some MySQL servers in a
> Multi-master replication scheme. I want to use the load balancer more for high
> availability, than for load balancing. All connections to the database server
> would go the mysql server 1. If server1 fails, the load balancer should send all
> connections to server 2, etc. Thanks for any insight on any implementation
> gotchas.
Have you considered the Linux High Availability project:
http://linux-ha.org/
We use it for failover at work. It does a good job.
Luis
--
GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E
