Connection Pool Proxy: Load balance across a pool of replicants

[Fernando Padilla]

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.