
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. Using LVs for DomUs decreases space efficiency as each separate block device needs to have adequate free space. It also makes backups a little more inconveniant as the block device needs to be snapshotted and mounted in the Dom0 instead of just using regular file access or ZFS filesystem snapshot plus regular file access. I expect that both of these options will give a greater latency than the current situation. It's either NFS latency or Ext4 latency on top of ZFS latency as opposed to just Ext4 latency on it's own. As write latency is probably the main performance criteria for a database which is heavily dependent on synchronous writes this would surely be a problem in some situations. However in this case the server averages 71KB/s of writes for 24*7 operation with iowait always staying below 4% so I don't think that a drop in performance is going to cause any problems. What do you think? -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/

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/
participants (2)
-
Arjen Lentz
-
Russell Coker