Yeah, that would be a nasty mess for us too... the change would replicate to all our databases and we'd have to stop the world, restore from the previous day's backups, re-run all the database binlogs up until the point where the disaster happened. It would be a couple of hours of total downtime - not a happy place.
But we do have daily backups and binlogs in multiple places, so it wouldn't actually lead to data loss. It really sounds like you were lucky NOT to be there!
Comments
Yeah, that would be a nasty mess for us too... the change would replicate to all our databases and we'd have to stop the world, restore from the previous day's backups, re-run all the database binlogs up until the point where the disaster happened. It would be a couple of hours of total downtime - not a happy place.
But we do have daily backups and binlogs in multiple places, so it wouldn't actually lead to data loss. It really sounds like you were lucky NOT to be there!