Background
Building small software to take space efficient and versioned online database backups can be a challenge. The goal of this project will be build such a solution.
Project Details
- One fairly efficient system to conserve storage space for database backups is to use a version control system to storage sql data dumps. That way only the changes are stored as a 'diff' to the first complete dump.
- The project will investigate and build "little tools" to enable space and resource efficient database backups.
Use Cases
- You have an extremely large database driving a large website or application and want to be able to take and store daily backups and want to be able to roll back to any date if I so wanted.
I want to take complete backups daily (to simply restores) but don't want to devote so much storage to the backups.
Tools
- A good version control system
- Databases such as MySQL and PostresQL
- Perl / Bash