New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Alert admins of database changes without a backup. #200

Open
bcipolli opened this Issue Feb 11, 2016 · 1 comment

Comments

Projects
None yet
2 participants
@bcipolli
Collaborator

bcipolli commented Feb 11, 2016

Rather than back up the entire database, we can use LogEntry to identify models that have changed, and to dump their information to a json file.

We should alert admins when a LogEntry has a newer date than the json file.

@bcipolli bcipolli added this to the v1.0-RC1 milestone Feb 11, 2016

@adborden

This comment has been minimized.

Member

adborden commented Jun 23, 2016

Can you provide more details? I feel like a dumb/simple approach is better than a smart/complex approach when it comes to disaster recovery.

I'd be afraid this would complicate the restore process. Right now it's a simple gunzip backup.sql.gz | mysql command to restore. If we're dealing with json paritals, how do you apply them once the schema has changed?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment