[CentOS] What to backup?

Benjamin Franz jfranz at freerun.com
Wed Feb 24 00:29:53 UTC 2010

Robert Heller wrote:
> What *I'd* do, is have separate partitions for /, /var /opt and /home. 
> And do a monthy full dump of each file system, weekly incremental dumps
> of /var and /opt, and daily or every other day incremental dumps of
> /home.  It is probably iffy to get a meaningful dump of mysql's running
> database.  It probably makes better sense to do a SQL dump -- 'man
> mysqldump'
If you can tolerate a few seconds of having your database offline, the 
fastest and easiest way to get a coherent snapshot is to keep 
/var/lib/mysql on its own LVM partition with extra unallocated extents 
and take an LVM snapshot with the database shutdown for just a few 
seconds. Something like the following:

/bin/mkdir /mnt/mysql-snapshot
/sbin/service mysql stop
/usr/sbin/lvcreate --permission r -L16G -s -n dbbackup /dev/mysql/data
/sbin/service mysql start
/bin/mount -r /dev/mysql/data /mnt/mysql-snapshot
/usr/bin/rsync -Saq --delete /mnt/mysql-snapshot /var/lib/mysql-backup/
/bin/umount /mnt/mysql-snapshot
/usr/sbin/lvremove -f /dev/mysql/data

Now you have a static and coherent snapshot of the database that can be 
used for restoration just by copying it into /var/lib/mysql and that is 
safe to be backed up by ordinary backup software. And the total time 
offline for the backup is typically on the order ~10 seconds. If you do 
it at 2AM no one is likely to even notice that you that you went offline 
for 10 seconds or so.

Benjamin Franz

More information about the CentOS mailing list