Hi Russell ----- Original Message -----
I've got a virtual server running MySQL where I'm going to convert the Dom0 to ZFS. Currently the Dom0 exports a LVM volume to the DomU which uses Ext4 for the database. My options are to use a ZFS zvol instead of a LV for the Ext4 filesystem or to use a ZFS filesystem that is NFS exported.
ext4 performs pretty well for many MySQL/MariaDB setups. zfs is faster, but for many use cases it's not relevant. Either way, always do basic FS tuning such as set noatime (if you have a 2.6 or above kernel, relatime is already the default). For more info, see http://openquery.com/blog/hint-day-noatime-relatime-fstab and the comment thread. NFS has overhead as well as nasty behaviour, I would recommend against using an NFS mount for MySQL/MariaDB storage at any time for any reason. Cheers, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MariaDB/MySQL services Sane business strategy explorations at http://upstarta.com.au Personal blog at http://lentz.com.au/blog/