Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Storage Methods for Nonstandard Data Patterns

Storage Methods for Nonstandard Data Patterns

 19 April 11:30 AM - 12:20 PM @ Ballroom B
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Architecture/Design
Scalability/Performance
Topics:
MySQL
InnoDB
Optimization

Description

Different patterns of data (or data access) in MySQL can often benefit from out-of-the-ordinary methods of storing or arranging the data. The main choices include storage engines, storage hardware, and table structure. Combinations of these three variables alone can be overwhelming. In this talk, I will discuss several shapes of data and data access and reveal results of testing various combinations of engine, disk, and table structure for them. Several of these tests stemmed from requirements in our environment. The results may surprise you. Beginners will learn about some data-storage options they didn't know existed, while more advanced users will appreciate someone else doing the testing legwork for them!

Speakers

Bob Burgess's picture

Bob Burgess

Database Operations Engineer, Shopify

Biography:

Bob has been squeezing every drop out of MySQL for several years, having previously spent several years roaming in the Garden of Oracle. In late 2007, he found himself suddenly (and without warning) responsible for storing and retrieving all the information amassed at Radian6, the original leading social media monitoring company. Now, as an operations engineer for Shopify, the database challenges are bigger than ever.

Share this talk


Slides