ScaleArc hired Percona to perform various tests on its database traffic management product. This case study is the outcome of the benchmarks carried out by Uday Sawant (ScaleArc) and Peter Boros (Percona).
The goal of these benchmarks is to identify the potential overhead of the ScaleArc software itself and the potential benefits of caching. The benchmarks were carried out with the trunk version of sysbench. For this reason, we used a very small set of data, so the measurements will be fast, and it's known that caching has huge benefits when the queries themselves are rather expensive. We decided that we would rather show that benefit with a real-world application, which is coming later is this series.
Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.