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:
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.
E-mail this to a friend
Printable version
You may also be interested in other helpful articles:
- MySql backup script
- Consistent backup with Linux Logical Volume Manager (LVM) snapshots
- How to MySQL backup and data recovery with mysql-zrm
- Dual network interface card to optimize Linux server backup process
- Copy MySQL database from one server to another remote server
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
Tags: backups, logical_volume_manager, mysql backup, snapshot, snapshots, solaris unix, zfs
Recent Comments
Today ~ 4 Comments
Today ~ 22 Comments
Today ~ 11 Comments
Today ~ 46 Comments
Yesterday ~ 4 Comments