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.
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.