Transcript
Accelerate MySQL Server With Seagate Enterprise Performance HDDs With TurboBoost Technology
®
™
Technical Brief
Authored by: Eric Lamkin, Staff Engineer Seagate Challenge One of the primary challenges that an organization must address in order to utilize its data effectively and efficiently is: How do I provide the most responsive access to this data, or more specifically, what storage devices best meet my data access needs?
Solution Seagate Enterprise Performance HDDs with TurboBoost with integrated nonvolatile write-back and flash read caching.
Benefits Scalable I/O performance improvement in the same physical footprint, with no additional software or data partitioning requirements—simple, high performing and cost-effective.
Overview Data centers deploying MySQL have many choices when it comes to configuring the storage platform. One way to achieve significant I/O performance benefits without sourcing and configuring additional caching software, tiered storage hardware or data partitioning is with Seagate Enterprise Performance HDDs with TurboBoost enhanced caching technology. Empirical results demonstrate a significant (up to 2× in these tests) I/O performance enhancement can be achieved within the same physical footprint with Seagate Enterprise Performance HDDs with TurboBoost enhanced caching technology. This technical brief compares traditional storage to Seagate Enterprise Performance HDDs with TurboBoost enhanced caching technology as a preferred platform for a MySQL database.
Problem Definition Traditional storage, while well suited for low $/GB and high capacity, can sometimes create a bottleneck with regard to the challenge of meeting the low latency demands of IOPS-hungry applications.
Solution Overview and Test Configuration Seagate Enterprise Performance 10K and 15K HDDs with TurboBoost increase performance and reduce latency without the need for administration of storage tiering, or the requirement for additional drive bays. For those seeking a high-performance and cost-effective solution, this is an excellent option. The TurboBoost feature simplifies deploying flash-based caching. Unlike other tiering and caching offerings, this drive identifies frequently-accessed read data and moves it to cache. This drive also operates in a nonvolatile write-back mode, which can greatly reduce latency for I/O writes. The following configuration demonstrates the I/O performance gained when utilizing Seagate Enterprise Performance HDDs with TurboBoost for a MySQL database exercised with a SysBench OLTP workload: • Dell T620 2× Intel E5-2650v2 (8 core) 2.6GHz 32GB memory • Dell PERC H710P for 6G SAS connection to storage bays • RHEL 6.4 and in-box megaraid_sas 06.504.01.00-rh1driver • MySQL 5.6.21 / SysBench 0.4.12.5 • MySQL logs configured on dedicated ×3 RAID 0 VD (traditional storage)
Accelerate MySQL Server With Seagate® Enterprise Performance HDDs With TurboBoost™ Technology • MySQL data configured on dedicated ×4 RAID 0 VD (to be compared) • MySQL buffer-pool set to 8GB • SysBench threads set to 55, tuned for maximum transactions per second (TPS). SysBench row count is set to obtain three different database table sizes. Runtime is set long enough for I/O performance to settle. 10K and 15K spindle drives with the TurboBoost enhanced cache feature and basic drives without the feature are included in the tests. • ST1800MM0018 1.8TB 10K RPM
Non-TurboBoost HDD
• ST1800MM0128 1.8TB 10K RPM
TurboBoost HDD
• ST600MP0035 600GB 15K RPM
Non-TurboBoost HDD
• ST600MX0052 600GB 15K RPM
TurboBoost HDD
Performance Results Results are reported via SysBench as TPS. All configurations are tested with the MySQL data files on a RAID 0 volume consisting of four drives.
Figure 1. SysBench OLTP TPS
Plan to scale the total available flash cache for the size of your hot read data. Configuring the drives using RAID ensures hot data is distributed across the read cache in each drive. TurboBoost drives accelerate I/O write performance with nonvolatile write cache. In some of the configurations tested, TurboBoost provided more than two times the TPS levels.
Conclusion Seagate Enterprise Performance HDDs with TurboBoost enhanced caching feature can significantly improve MySQL I/O performance (up to 2× in these tests) in the same physical storage footprint and without additional caching software to configure or data partitioning to tiered storage.
seagate.com
AMERICAS ASIA/PACIFIC EUROPE, MIDDLE EAST AND AFRICA
Seagate Technology LLC 10200 South De Anza Boulevard, Cupertino, California 95014, United States, 408-658-1000 Seagate Singapore International Headquarters Pte. Ltd. 7000 Ang Mo Kio Avenue 5, Singapore 569877, 65-6485-3888 Seagate Technology SAS 16–18, rue du Dôme, 92100 Boulogne-Billancourt, France, 33 1-4186 10 00
© 2015 Seagate Technology LLC. All rights reserved. Printed in USA. Seagate, Seagate Technology and the Spiral logo are registered trademarks of Seagate Technology LLC in the United States and/or other countries. TurboBoost is either a trademark or registered trademark of Seagate Technology LLC or one of its affiliated companies in the United States and/or other countries. All other trademarks or registered trademarks are the property of their respective owners. When referring to product capacity, one gigabyte, or GB, equals one billion bytes and one terabyte, or TB, equals one trillion bytes. Your computer’s operating system may use a different standard of measurement and report a lower capacity. In addition, some of the listed capacity is used for formatting and other functions, and thus will not be available for data storage. Actual data rates may vary depending on operating environment and other factors. Seagate reserves the right to change, without notice, product offerings or specifications. TB100.1-1506US, June 2015
