UPDATED 14:43 EDT / APRIL 23 2014

Server SAN boosts MySQL performance by 3X

flash virtualization speed of lightCompanies can increase MySQL performance by 3 times by using the new Linux Atomic Write and NVM compression extensions in a Server SAN configuration, attaching flash storage either through PCIe or DIMM and eliminating SCSI code designed to support slow spinning disks, writes Wikibon Co-founder and CTO David Floyer in “MySQL receives over 3X Boost in Performance from PCIe Flash“.

This huge performance boost comes without the tradeoffs of the traditional strategies for improving MySQL performance:

  • Turning off compression, which doubles performance but also doubles the required storage space and bandwidth for reading and writing data to storage.

  • Turning off DoubleWrites, which improves performance by 70% at the expense of compromising atomicity and data integrity.

The three MySQL distributors – MariaDB, Oracle and Pecona – all support the extensions, which make MySQL flash-aware. The Server SAN architecture, in which flash storage is directly attached to the server through PCIe or DIMM, takes full advantage of the order-of-magnitude search and read/write speed differential between flash and spinning disk.

As a result, Floyer said in a recent conversation in theCUBE (see video below), “People who are running large-scale databases on MySQL will really benefit from these enhancements. If you can get three times the throughput you essentially have three times the lifetime for these databases.”

As with all Wikibon research, this Professional Alert is available without charge on the Wikibon Web site. IT professionals are invited to register for free membership in the Wikibon community, which allows them to participate in Wikibon research and post questions, comments and research for the community.

photo credit: travellingred via photopin cc


A message from John Furrier, co-founder of SiliconANGLE:

Your vote of support is important to us and it helps us keep the content FREE.

One click below supports our mission to provide free, deep, and relevant content.  

Join our community on YouTube

Join the community that includes more than 15,000 #CubeAlumni experts, including Amazon.com CEO Andy Jassy, Dell Technologies founder and CEO Michael Dell, Intel CEO Pat Gelsinger, and many more luminaries and experts.

“TheCUBE is an important partner to the industry. You guys really are a part of our events and we really appreciate you coming and I know people appreciate the content you create as well” – Andy Jassy

THANK YOU