MySQL

Backup LAMP Stacks with LVM Snapshots

published on Sat, 11/29/2008 - 17:11

I've done a lot with LVM in the past, but up until now had never really played around with LVM snapshots. I recently used LVM snapshots to implement a "hot backup" of my LAMP stack running this blog. I quote "hot backup" because, while mysql is indeed running, I do have to place a read lock on all tables for a second or two. You don't need to do this if you're using Innodb, but you do if you use the MyISAM engine (which Drupal does by default).

Simple & Effective Apache+MySQL Backups for your Blog/CMS

published on Sat, 08/02/2008 - 13:59

As part of setting up my new Linode host, I needed a quick, easy, and maintanable way to create backups of my LAMP webapps.  Follow the jump to see how I set up my backup strategy.

DISCLAIMER: I make no guarantees to the effectiveness of this script. It works for me, and it should work for you, but it is up to you to test it! Also note, you need to have SSH access and root privileges to your server.

Subscribe to SysAdmin's Journey RSS