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/ _______________________________________________ luv-main mailing list [email protected] http://lists.luv.asn.au/listinfo/luv-main
