Having been using CloudSQL in production for a few months and am quite happy!
However, I'm still trying to find the best way to automate offsite backups. I'm satisfied that CloudSQL provides good safeguards against hardware failure, through replication and nightly backups, but I'm am still concerned about the possibility of data loss through operator error or the actions of a malicious intruder -- total destruction of our production database is only two clicks a way!
To guard against this, we've been doing manual daily-weekly dumps and archiving them offsite. Is there anyway to automate this? Looking further down the road, have you considered adding "termination" protection so that a key database cannot be terminated without additional user authentication / safeguards?
Thanks,
Alex
No comments:
Post a Comment