Re: MySQL Load Balancing...

I just stumbled across this article on how to loadbalance a mysql
cluster with ultra monkey ... hope it helps
http://www.howtoforge.com/book/print/1179

Allan

On 1/31/06, Horms <[email protected]> wrote:
> Jim Mchugh <[email protected]> wrote:
> >
> > Hello all!!!
> >
> > We would like to put an UltraMonkey director in front of a cluster of 3
> > MySQL Clustered Database Servers to balance the incoming client requests
> > between them.
> >
> > The standard MySQL port is 3306.
> >
> > Does anyone have any experience of this???
>
> I did set up Ultra Monkey for MySQL once. The Ultra Monkey portion of
> the problem is pretty simple. ldirectord has a MySQL check, and the rest
> just works. The main trick is synchronising the backend databases. In
> particular, you probably want to make sure writes always go to just one
> of them by having a read and write virtual service with different pools
> of real servers. The project I worked (breifly) on was using MySQL
> Cluster, but I believe there are several other viable ways.
>
>
> --
> Horms
>
>
> --
> Ultra Monkey - http://www.ultramonkey.org/
> To UNSUBSCRIBE, email to [email protected], with a body:
> unsubscribe ultramonkey-users [email protected]
> where "[email protected]" is YOUR email address.
>
>


-- 
Ultra Monkey - http://www.ultramonkey.org/
To UNSUBSCRIBE, email to [email protected], with a body:
unsubscribe ultramonkey-users [email protected]
where "[email protected]" is YOUR email address.