Consider I have a master on DC1 and slave on DC2. Now, DC1 network is completely down for indefinite time and I want to resume the service as soon as possible on DC2 by promoting the slave to master.
There are two problems:
- I don't know how much the slave is lag behind the master
- If original master went back online, how to solve the conflict?
Are there any recommended steps and procedures?