Re: MySQL Load Balancing...

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.