Howto: Make consistent MySQL database backups using Solaris ZFS snapshots
Iâ€™ve already written about MySQL backup using a shell script and consistent backup with Linux Logical Volume Manager (LVM) snapshots:
A snapshot volume is a special type of volume that presents all the data that was in the volume at the time the snapshot was created. This means you can back up that volume without having to worry about data being changed while the backup is going on, and you donâ€™t have to take the database volume offline while the backup is taking place.
Niclas has posted a nice howto about consistent MySQL backups using Solaris UNIX ZFS snapshots:
Share this on:
In this article I will show you how to install MySQL on a ZFS file system and supply you with a script to make consistent snapshots of the databases. This script may not be 100% fit for busy sites but for most smaller places I think it is perfect.
Your support makes a big difference:
I have a small favor to ask. More people are reading the nixCraft. Many of you block advertising which is your right, and advertising revenues are not sufficient to cover my operating costs. So you can see why I need to ask for your help. The nixCraft, takes a lot of my time and hard work to produce. If you use nixCraft, who likes it, helps me with donations:
Become a Supporter → Make a contribution via Paypal/Bitcoin →
Don't Miss Any Linux and Unix Tips Get nixCraft in your inbox. It's free: