MySQL Forums
Forum List  »  Router & Proxy

Connection Pool Proxy: Load balance across a pool of replicants
Posted by: Fernando Padilla
Date: July 18, 2007 04:15PM

What I am concerned about is scale out of our web server farm and their connections pools going against our databases.

1) Connections Pools on each server are set to not go beyond the max connections on the database servers, but if we are forced to bring a few servers online, then the connection math is wrong and we would have to reconfigure the whole cluster.

2) I want to load balance across a pool of replicants, without having to configure precisely which replication which webserver will go to. I know Connector/J has some support for this, but I bet the proxy would support it much better.

3) A more advanced connection math issue, if we go through the process of sharding our database, but still host multiple shards on one server ( hardware costs ), then the connection pool settings essentially double against that one host. A connection pool proxy should deal with this as well.

Edited 1 time(s). Last edit at 07/18/2007 10:54PM by Edwin DeSouza.

Options: ReplyQuote

Written By
Connection Pool Proxy: Load balance across a pool of replicants
July 18, 2007 04:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.