robert_pdx Posted August 20, 2006 Share Posted August 20, 2006 I'm working on a backup scheme for our oscommerce site. This server is connected to a UPS, although I don't yet have it setup to do a graceful shutdown yet if the battery is about to run out....still to-do. The system has dual SATA hard drives, set up in RAID1 mirror. I'm going to use mondorescue for a monthly backup, useful if the whole thing crashes. These will be stored on DVD-R. Maybe do these weekly? Final .iso size is just under 1GB, though this will grow - I suspect this will fit on one DVD-R disk for quite a while. Daily backup is simply a rotating collection (7 days worth) of tar'ing the catalog folder/subfolders and the /etc folder, and then mysqldump --all-databases. These I'm just storing locally on the hard disk. Have I forgotten anything to make this reasonably safe for live operation? Any comments or suggestions are appreciated. Thanks, Robert Link to comment Share on other sites More sharing options...
Iggy Posted August 20, 2006 Share Posted August 20, 2006 I'm working on a backup scheme for our oscommerce site. This server is connected to a UPS, although I don't yet have it setup to do a graceful shutdown yet if the battery is about to run out....still to-do. The system has dual SATA hard drives, set up in RAID1 mirror. I'm going to use mondorescue for a monthly backup, useful if the whole thing crashes. These will be stored on DVD-R. Maybe do these weekly? Final .iso size is just under 1GB, though this will grow - I suspect this will fit on one DVD-R disk for quite a while. Daily backup is simply a rotating collection (7 days worth) of tar'ing the catalog folder/subfolders and the /etc folder, and then mysqldump --all-databases. These I'm just storing locally on the hard disk. Have I forgotten anything to make this reasonably safe for live operation? Any comments or suggestions are appreciated. Thanks, Robert That's pretty comprehensive. You might look into rDiff for longterm backups or automagically sending them offsite. You could set a 3rd drive outside the RAID just for backups (you could even mount it only when backing up via cron) and use rdiff for increments of any duration you're comfortable with. You could even do an incremental backup of all the partitions you could swap over to in a hurry if you ever needed to. HTH, Iggy Everything's funny but nothing's a joke... Link to comment Share on other sites More sharing options...
Guest Posted August 20, 2006 Share Posted August 20, 2006 Whoooooooooosh way over my head Link to comment Share on other sites More sharing options...
insomniac2 Posted August 20, 2006 Share Posted August 20, 2006 One other point you might wish to consider. RAID is only good for keeping your system up and running and ... Not for a reliable backup copy of your data. RAID is only a mirror duplicate of your main system drive. If you already have corrupt data on that drive ... all you are doing is copying the errors. Not good if the errors are in your database. You may even end up restoring a RAID partition that has the very errors on it that you are trying to get rid of. You should alwyas keep a hard copy of your entire site that you know is fully functional and devoid of any database errors etc. Label the DVD-R's or CD-RW's etc with something like "NO RAID Error Free Backup" just so you know its not a RAIDED Copy. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.