Solid State Storage for your MySQL Databases: What you need to Know to Optimize Performance
The rise of Solid State or Flash storage is one of the great technology changes impacting the database world. With this impact comes many questions for potential users of the technology. Traditionally, databases were designed based on the premise that storage is slow and that sequential IO operations are much faster than "random" ones. This is not the case with Solid State storage. To successfully operate your open source database, there are many options that you need to understand about solid state storage. This presentation will help explore these options and answer your key questions by discussing: · The properties of Solid State storage and Multi-Tiered storage solutions · How to best use them to a build and optimize a high-performance and cost efficient storage solution for database workloads · What specific configurations are proven to work well
Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB, and Percona XtraBackup. He is an expert in LAMP performance, especially optimizing MySQL and InnoDB internals to take full advantage of modern hardware using his multi-threaded programming background. Source code patches authored by Vadim have been incorporated by Oracle Corporation and its predecessors into the mainstream MySQL and InnoDB products. At Percona Vadim also designs no-gimmicks benchmark tests of hardware, filesystems, storage engines, and databases. He focuses on real-world performance and functionality scenarios that are often missed by standard benchmarks. Most benchmarks are done on a sponsored basis for vendors who wish to validate their product's worthiness, with the unedited results published on the MySQL Performance Blog (if the sponsor allows). Vadim actively consults for many Alexa Top 1000 web properties, but has an increasing focus on hardware appliances and storage engines. He is leading Percona's emerging expertise in solid-state storage with his launch of the SSD Performance Blog.