Hi,
We had a similar problem and we have taken a different approach:
Instead of having dedicated slave servers, we configure a slave mysql
server on each webserver. Each webserver connects only to 'localhost'
slave mysql server. Each slave server only deals with local connections
(200 in your ca
I have a database heavy site that utilizes a master mysql server which
processes all updates and replicates to 4 slave servers that handle the
queries. Right now I have a simple perl randomized selection that
determines which of the four database slaves will receive any given
query. This wo
