I got a release the other day that will be pretty interesting for those worried about scaling MySQL up to high transaction counts. ScaleBase (more on them here) have just achieved a rate of 190000 transactions a minute while sitting within an Amazon RDS environment. It’s an interesting result, and one that will be noticed by those who claim that it’s impossible to use MySQL and still maintain performance.
ScaleBase utilizes two techniques for scaling: read-write splitting and transparent sharding (a technique for scaling-out relational database). The software enables the database to scale transparently, without forcing developers to move off MySQL.
Scalebase is reporting that cost per 100000 transactions was
50 cents 0.50 cents – more details on the benchmark are here.
I’d be keen to hear from DBAs who have some stories around the limitations of scaling MySQL – does the promise of ScaleBase change your world?