Tag Archives: Snapshot

MySQL ZFS snapshot restoration

Since yesterdays test on ZFS snapshots, we now have 25 snapshots in the snapshot archive which can be seen below. # cd /DATA/mysql/.zfs/snapshot/ # ls -lah total 36 dr-xr-xr-x 21 root wheel 21B Oct 16 21:00 . dr-xr-xr-x 4 root … Continue reading

Posted in FreeBSD Administration, MySQL, ZFS | Tagged , , , | Leave a comment

Using ZFS snapshots to keep MySQL backups

Whilst at a customer site the other day the question was raised over how they could keep a fair volume of backups of a MySQL database off site, while minimising bandwidth and disk space. So the usual ‘moon on a … Continue reading

Posted in FreeBSD Administration, MySQL, ZFS | Tagged , , , | Leave a comment

More ZFS on FreeBSD

After yesterday’s success with the ZFS configuration I’m hoping to perform some snapshots and get the compression to be a bit better. I was a bit disappointed with the compression ratio yesterday which was a pitiful 1.15x. I’ll be cheating … Continue reading

Posted in FreeBSD Administration | Tagged , , , | Leave a comment