]]> ]]>

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

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

Vadim Tkachenko

Vadim Tkachenko

CTO and Co-FounderPercona

Vadim leads Percona's development group, which produces Percona Server and Percona XtraBackup. He is an expert in solid-state storage, and has helped many hardware and software providers succeed in the MySQL market.


Shridar Subramanian

Shridar Subramanian

Vice President, Product Marketing and ManagementVirident

Mr. Subramanian has over 18 years of experience in senior level marketing and engineering positions with high-technology/high growth companies. Mr. Subramanian received his undergraduate degree in Computer Engineering from the University of Bombay, Master's in Computer Science from Penn State University and MBA from the University of Chicago.


Baron Schwartz

Baron Schwartz

Chief Performance ArchitectPercona

Baron is the lead author of High Performance MySQL, and creator of Maatkit. He consults with Percona's customers, and develops tools and practices for Percona's team.



Our MySQL white papers are free and require no registration to download. 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
Sales Latin America +54-0800-666-3243 (Arg.)
+55-0800-020-4918 (Brazil)
Training (855) 55TRAIN or
(925) 271-5054
Share This
]]> ]]>