Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Solid State Storage for your MySQL Databases: What you need to Know to Optimize Performance

Solid State Storage for your MySQL Databases: What you need to Know to Optimize Performance

 20 April 04:30 PM - 05:20 PM @ Room 210
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Scalability/Performance
Topics:
MySQL
Optimization

Description

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

Speakers

Vadim Tkachenko's picture

Vadim Tkachenko

CTO, Percona

Biography:

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.

Share this talk


Slides