Update on the April 5th, 2017 Outage
digitalocean.com
digitalocean.com
Classic. Someone manually ran the test automation while pointing at production including its cleanup routine of DROP. Very foundational access control was not in place.
1.) If they have a time-delayed replica, why not recover it to the point-in-time before the issue, and then switch master over to it?
2.) They took a backup of the replica, moved the backup to the master, and then restored from it. Do they not have direct backups of the master? A time-delayed replica is no replacement for valid backups.
I wonder if there's anything to be done about reducing the duration of these outages. I suppose copying TBs of data around the world is simply always going to take hours.