|
>
>
> 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@xxxxxxxxx>
|
