Ryan Ordway wrote:
The problem is you'll have some inconsistency between your master A's view of the database and the master B's view. You lose any changes to the data on master B. It would be nice to be able to merge any changes from B that hadn't made their way to master A yet. At that point you're examining binlogs.
I wonder if someone has spent the time to write such a tool, that would workout what this diff/delta was, and then be able to bring both machines upto speed, so after a period of time ( hopefully short ), they would both be in the same state.