Realservers as client

[Kenny Dail]

> 
> 
> Joseph Mack NA3T wrote:
> > On Mon, 29 Jan 2007, Leon Botes wrote:
> > 
> >> Can anyone suggest a solution or at least show me the flaws in this 
> >> sort of setup. I desperately need to balance the mysql services with 
> >> the real servers as clients.
> > 
> > since the users initial connection to the realserver is balanced, why 
> > can't you let the realserver connect directly
> > to the database? You don't need to balance again.
> > 
> The mysql service is depended upon by all the real servers for many 
> different applications. The load placed on one mysql server by all the 
> real servers cumulatively would be rather high and the potential loss 
> involved in loosing database records could be very high. For that reason 
> i need to provide mysql failover as well as load balancing.

Perhaps using MySQL's Cluster option would be prudent.
http://www.howtoforge.com/loadbalanced_mysql_cluster_debian

-- 
Kenny Dail <kend at amigo.net>