gtalug / infrastructure

GTALUG infrastructure (the server).
0 stars 0 forks source link

MySQL Backup #41

Open myles opened 8 years ago

myles commented 8 years ago

We currently have three applications that require MySQL (GNUSocial and Piwik) we need to have a backup solution that is privacy aware.

davecb commented 8 years ago

On 26/10/15 08:12 PM, Myles Braithwaite wrote:

We currently have three applications that require MySQL (GNUSocial http://social.gtalug.org/ and Piwik http://piwik.gtalug.org/) we need to have a backup solution that is privacy aware.

— Reply to this email directly or view it on GitHub https://github.com/gtalug/infrastructure/issues/41.

A public key encryption pipeline where multiple people have offline copies of the private key, and then any backup scheme you like, and then a download-and-checksum script on the source machines with the current and immediately previous day's backup sitting there for a quick restore. In short, something roundtrippable and trivially testable. --dave

David Collier-Brown, | Always do right. This will gratify System Programmer and Author | some people and astonish the rest davecb@spamcop.net | -- Mark Twain