]]> ]]>

Forecasting MySQL Scalability with the Universal Scalability Law

You are here

Forecasting a system's scalability limitations can help answer questions such as “will my server handle ten times the existing load?” and “at what point will I need to upgrade my hardware?” Timely answers to these questions have more business value than exact predictions. Mathematical models can help reduce guesswork while avoiding the expense and time required for real load testing. Dr. Neil J. Gunther's Universal Scalability Law is such a model. It predicts a system's deviation from ideal scalability, based on simple measurements that are relatively easy to collect. In this paper we show how to model a MySQL database server's scalability, in terms of throughput, for two different servers and workloads.

November, 2010


Authors

Baron Schwartz

Baron Schwartz

-

Baron is the lead author of High Performance MySQL and the creator of Maatkit, which later became Percona Toolkit.


Ewen Fortune

Ewen Fortune

Director of Expert Resources

Ewen joined Percona in early 2008 with many years of systems administration experience. He came to the company immediately after working for Europe's largest clinical analysis laboratory. Prior to that, he worked at several pan-European Internet Service Providers, where he gained a strong background and experience in networking and large-scale ho



Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>