MySQL on Flash: Start Today, Expand Tomorrow

Utilizing Hardware
12 November 1:50pm - 2:40pm @ Sentosa 5-8
50 minutes conference
As an increasing number of MySQL environments move to all flash based storage, additional resources aim to make the database better utilise this advanced technology. Applications have assumed rotational mechanical storage devices for the past 20+ years, trying to get the most performance by working around their limitations. Moving to fast flash based storage today increases performance significantly, but because of assumptions about hard disk drives and optimisations for their characteristics, the full potential of MySQL on flash has yet to be reached. The characteristics of seek-less flash storage has the ability to improve performance by an order of magnitude once fully understood and used by applications. This presentation will cover a wide range of configuration, tuning and performance data of MySQL workloads running on seek-less flash storage today. The differences between MySQL servers and storage engines are explained, showing the importance of having a properly configured server. Using this data we will identify areas that can be further improved by giving MySQL native access to the unique characteristics of flash. The second part of the talk will cover advanced features such as atomic writes, low latency transaction logging and advanced file systems. Features that will both take the database performance to the next level and change how application storage engines are written.


Principal Application Architect, Fusion-io
Torben Mathiasen is an application architect at Fusion-io, where he spends his time tuning and evaluating software stacks for optimal performance and reliability. Prior to joining Fusion-io, he spent 11 years at Hewlett-Packard, architecting firmware for the ProLiant BladeServer portfolio. He also held a senior system architect position at Prevas, designing the next generation embedded systems for use by customers around the globe. He has made contributions to the Linux kernel in areas like ethernet, PCI-X and storage controller drivers.