MySQL and ZFS

Wednesday 5:10 PM - 5:35 PM

@ Texas 1

MySQL/MariaDB

50 minutes conference

Intermediate

Tracks:
MySQL

MySQL, as a database, strives on a filesystem but not all filesystems are equal! On Linux, ZFS is gaining attention and there are good reasons for that, especially if you happen to also run MySQL. In this talk, I'll describe the main characteristics and features of ZFS and draw parallels with the architecture of InnoDB. From easy backups to compression and improved caching, you'll see that MySQL has a lot to benefit from ZFS. I'll discuss the configurations of both MySQL and ZFS so they play well together and perform at their best. Finally, cost-saving MySQL/ZFS reference architectures using both, bare metal and clouds servers will be presented and reviewed.


Speakers

Yves Trudeau

Yves Trudeau (Percona)

Principal architect

Biography:

Yves Trudeau has over 20 years of experience as a consultant specializing in database software development and Linux high availability. Principal architect with Percona since 2009, he previously worked with MySQL and Sun Microsystems. Along with a focus on database high availability, he also has a strong interest on all aspects related to scalability and distributed systems. Past experiences include DBA work on SQL Server, Oracle, MaxDB and MySQL and programming in C/C++, Python, PHP, Perl, Java and Go. Yves has a Ph. D. degree in experimental Physics from Université de Sherbrooke.


Slides



  Download Slides  


Video

Please sign in for 15 day access

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863