CODEWITHSUNDEEP
mysqlreplicationmaster-slave
sarp
sarp

Reputation: 3750

How to reset(?) a (out-of-sync)DB on a MySQL master-master replication

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.

Upvotes: 1

Views: 1548

Answers (2)

sarp
sarp

Reputation: 3750

Actually I happened to wrote a short blog post about how to overcome this ages later.

Upvotes: 0

Gary
Gary

Reputation: 2916

Did you look into Maakit's tools?

Mk-Table-Sync should be able to help you out.

Upvotes: 1

Related Questions