> HGST > SATA vs. PCIe Solid-State Storage Solutions for MySQL Environments

SATA vs. PCIe Solid-State Storage Solutions for MySQL Environments

Published By: HGST
HGST
Published:  Feb 05, 2015
Length:  10 pages

Database users are increasingly interested in using Flash-based solid-state drives (SSDs) to speed up application performance. For many database administrators (DBAs), increased database performance directly impacts their user experience and bottom lines. Accelerating a single MySQL instance may allow DBAs to avoid painful sharding exercises, with all their attendant administration, application changes, and high capital and ongoing costs. With the wide range of SSDs available today, choosing any one can be difficult. This paper aims to answer the question, Is it better to use slower SATA SSDs in RAID or a faster PCIe SSD to scale up MySQL database performance?"



Tagssolid-state storage, flash-based, database administrators, mysql, application changes, database users