I'm also a very happy ZFS user on FreeBSD. I've tried to use it in a lot of crazy ways. At the moment I'm researching if ZFS and a virtual machine running Microsoft SQL Server can improve query performance(with LZ4/GZIP compression) and improve the backup speed.
Though I'm wondering about if there are any plans to add XZ compression? Or faster hashing with Siphash24 for data checksums?
Improving the backup speed should be as easy as quiescing the database, taking a ZFS snapshot after you are sure everything is written to disk, then backing up that snapshot.
Comments
I'm also a very happy ZFS user on FreeBSD. I've tried to use it in a lot of crazy ways. At the moment I'm researching if ZFS and a virtual machine running Microsoft SQL Server can improve query performance(with LZ4/GZIP compression) and improve the backup speed.
Though I'm wondering about if there are any plans to add XZ compression? Or faster hashing with Siphash24 for data checksums?
LZMA compression (used in the xz format) is much slower than the disk interface and uses a lot of memory, so it would reduce performance.
Improving the backup speed should be as easy as quiescing the database, taking a ZFS snapshot after you are sure everything is written to disk, then backing up that snapshot.