Determine and implement DB backup policy and method

[broadwell]

Presumably the DB backups would be generated via mysqldump (compressed). Details to work out:

• How often to generate the backups
• Where to store the backups (probably S3) and how to make sure they're copied there
• How to trigger the backups: probably a chron job would be easiest, but note that Django has a DB backup module

Note that Reclaim offers daily rolling backups of the DB via its Jetbackup app, but these are only kept around for a few weeks, and there does not seem to be any API for accessing the backups or scheduling new ones.

[simonwiles]

I've just assigned this to myself. The Jetbackup backups are available in the hosting account (~/.jbm), but they're less than ideal for a number of reasons. For now, I've set up a cron job that takes a backup of all MySQL databases on the instance (which is just the one, and will presumably remain just the one) every night. The present behaviour is to overwrite the backup file every night, keeping only the one from the first of each month for posterity (i.e., at any given time you should expect to be able to find last night's backup, and one from the 1st day of each month from here on out).

The issue of getting this backup somewhere else (i.e. off reclaim) for safekeeping remains outstanding.