As part of building Tailrank we need to build a high availability and high performance MySQL cluster capable of running on cheap commodity hardware and in high performance environments. Unfortunately MySQL really falls down in a lot of areas especially when you make it do real work.
Luckily this is Open Source which means we can fix things.
We've developed a load balanced JDBC connection pool (named lbpool) meant to be used in production environments:
Right now we're at beta1 which means you should not deploy this in production environments without testing. That said its being used on Tailrank.com right now and is very rock solid. We've had it in production for 60 days now.
Here's a brief intro (but you should def read the full site).
The lbpool project provides a load …
[Read more]