We take backups of our Clear Books database and other site files hosted by CatN on a new schedule.
All of our backups are stored on Amazon S3. We use the EC2 Slave to perform all of our backups to Amazon S3 storage. Using Amazon S3 provides redundancy so that in the case of our local site being damaged we can still recover data from an off site, cloud based storage service.
Backups
For Clear Books, a backup is an individual customer database dump that is exported (mysqldump), compressed (bz2), encrypted (gpg) before being copied to another location (S3). We take these backups daily, and store each one for 7 days. We also store backups from the 1st of the month for 3 months. This gives us a historic view of individual customer databases.
Schedule
The backup schedule for ClearBooks data is as follows:
- Every Clear Books database is dumped on a daily basis.
- Snapshots of the entire Clear Books filesystem daily.
- User generated backups as often as required.
Previous post: MySQL replicationNext post: Customer generated backups
