How to recover from failed Mysql schema update, with replication?
- by OmerGertel
I have two MySQL servers configured with master-slave replication.
Before we deploy a new application version we:
1) STOP SLAVE
2) Take a MySQL dump of the slave.
However, if a mistake is done during the deployment of the new schema version (a table is dropped by mistake, for example), having the slave intact doesn't help. Our service is…