Storage Methods for Nonstandard Data Patterns
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!
Database Operations Engineer, Shopify
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.