May 29, 2019
 Percona Live Open Source Database Conference 2019
  Yves Trudeau

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.

About the Author

Yves Trudeau

Yves is a Principal Consultant at Percona, specializing in MySQL High-Availability and scaling solutions. Prior to joining Percona in 2009, he worked as a senior consultant for MySQL AB and Sun Microsystems, assisting customers across North America with NDB Cluster and Heartbeat/DRBD technologies. Yves holds a Ph.D. in Experimental Physics from Université de Sherbrooke. He lives in Québec, Canada with his wife and three daughters.