如何重置（？）MySQL 主主复制上的（不同步）数据库
我有一个主-主 MySQL 复制。直到昨天为止都很美味，但是由于某种我还不明白的原因，他们失去了同步。我一直在论坛和一些工具、技巧和建议中闲逛，但似乎我自己无法及时弄清楚。
所以我的想法就是重置有问题的数据库。如果我没有想象错的话，我打算转储（不同步）数据库中的所有数据，然后将其重新连接到另一个主服务器，就像我添加一个全新的从服务器一样。
我当然担心没有问题的主人。 （基本上是另一个）。当我从有问题的（不同步）数据库中转储所有内容时，它不应该同时将所有内容转储为从属数据库。
我希望我说清楚了。我试图尽可能清晰、简短。如果需要，我随时可以提供更多信息。
提前致谢。
I have a master-master MySQL replication. It was delicious until yesterday but, for some reason which I could not figure it out yet, they lost synchronization. I've been wandering around forums and several tools, tips and advices but it seems like I cannot not figure it out myself in time.
So I have the idea just to reset the problematic DB. If I am not imagining wrong, I was planning to dump all the data from the (out-of-sync)DB and then re-attach it to the other master as if I am adding a brand new slave.
Of course I am worried about the NON-problematic master. (the other one basically). When I dump everything from the problematic (out-of-sync)DB, it should not also dump everything as being a slave at the same time.
I hope I made myself clear. I tried to be as clear and short as I can. I can always provide more information if needed.
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您研究过 Maakit 的工具吗？
Mk-Table-Sync 应该能够帮助你。
Did you look into Maakit's tools?
Mk-Table-Sync should be able to help you out.
实际上我碰巧写了一篇简短的博客文章关于以后如何克服这个问题。
Actually I happened to wrote a short blog post about how to overcome this ages later.