]]> ]]>

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

You are here

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.

May, 2011


Authors

Baron Schwartz

Baron Schwartz

-

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


Shridar Subramanian

Shridar Subramanian

Vice President, Product Marketing and Management, Virident


Vadim Tkachenko

Vadim Tkachenko

Co-Founder, CTO

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 incorpor



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
]]>