DB and System Backup

DB and System Backup
Category:  Tools
Version:  2.0.4
Size:  34KB
License:  MPL
Updated:  16 Apr 2018 08:14:06AM
Requires:  Amazon Web Services SDK


Backs up your Database, modules, skins and Profile Media on a daily basis to Amazon S3.

Requires system() access to mysqldump to work properly, as well as a working Amazon Web Services account:

https://aws.amazon.com/

Uses Reduced Redundancy storage on S3 to lessen backup storage costs.

 
iLoveHouseMusic
20 Nov 2013 10:26:58AM @ilovehousemusic:
I just set this up on AWS. Testing.

Suggestions: Is there a pruning feature of any sort? Is there an email notification feature that will email you on backup completion, failure, success? Should have method to restore backup from selected date, not only previous. For instance, what if your previous backup is bad/corrupt? You would need to backup to a different one.

Just a few suggestions.

brian
20 Nov 2013 10:31:18AM @brian:
Thanks for the feedback - those are all good ideas:

1) There is no pruning of media files at this time - the DB files are pruned though and only the most recent 7 days are kept. Part of the issue of pruning media is that it (could) require a lot of queries into the local system and S3 to try to find all the matching media files that are no longer in the system, which on a large system could take a VERY long time.

2) email on success/failure is a good idea. Right now everything is logged to the activity log.

3) restore from a specific date would work for the DB, not for media files (but probably still worth it).

When we get to doing updates for this module we'll definitely look at these suggestions.

Thanks!

iLoveHouseMusic
20 Nov 2013 11:08:46AM @ilovehousemusic:
No problem. I'm a network admin so these types of concerns come natural to me. Looking forward to the updates!
B

brian
26 Nov 2013 08:14:58AM @brian:
A quick followup here that we've just released the new Activity Log Watcher module:

https://www.jamroom.net/the-jamroom-network/networkmarket/99/activity-log-watcher

that you could use to send yourself an email when the backup completes or if there are any errors.

Hope this helps!

iLoveHouseMusic
04 Dec 2013 09:47:01AM @ilovehousemusic:
Going to test the log watcher. Thanks!

Tags