Realservers as client

[Leon Botes]

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.
> Joe
>