Hello,
I was wondering what the best technique for implementing a DB connection pool for a web application which uses shards. From what I can tell most (all?) open-source implementations only support a single database behind. At least, I have not found one that supports shards.
Also, even though I using shards not all of the database will have the same schema as I will have other databases too. I'm not sure if that's important to mention.
The only solution that I can come up with so far is to write a layer that sits on top of multiple and distinct pools. Each distinct pool can be any of the available single database implementations.
Are there already solutions for this? What would be the best technique otherwise?
Thanks in advance,
Stephen.