Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server

May, 2011

Hardware continues to outpace software, and with the large amounts of memory, many CPU cores, and enormously powerful flash drives readily available today, a hybrid strategy of multiple database servers per physical server is necessary to better utilize the hardware's capacity. Such a configuration can enable a 5x to 15x consolidation factor, and improve performance and hardware utilization many-fold. This paper measures Percona Server's scalability in terms of memory size and CPU core count. Based on the result, we identified several configurations that achieve a much lower price-to-performance ratio while balancing memory, CPU, and I/O capacity. Our benchmarks and suggested configurations are based on the Virident tachIOn PCI-E storage device.


Baron Schwartz

Vice President of Consulting

Shridar Subramanian

Vice President, Product Marketing and Management, Virident

Vadim Tkachenko


Vadim leads Percona's Development group which produces the Percona Server, Percona XtraDB, and Percona XtraBackup. He is an expert in LAMP performance, especially optimizing MySQL and InnoDB internals to take full advantage of modern hardware using his multi-threaded programming background. Source code patches authored by Vadim have been incorporated by Oracle Corporation and its predecessors into the mainstream MySQL and InnoDB products. At Percona, Vadim also designs no-gimmicks benchmark tests of hardware, filesystems, storage engines, and databases.

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