0

I have 2 server set on mysql master master replication. we can call it as good server and bad server.

Good server has all the latest data. Once of table in the bad server is not in sync and have old data. How can I sync the new data into that table? Can i dump the table from the good server and then restore it to bad server?

sandy
  • 43
  • 1
  • 1
  • 7

1 Answers1

0

You can try and resynchronise your databases manually but it's usually much easier to use tools designed for this purpose. Check out these two utilities and pick the one the best fits your situation:

MySQL provides mysqlrplsync as part of the Database Utilities package.

Percona offers pt-table-sync as part of their Toolkit.

Paul Campbell
  • 1,906
  • 2
  • 12
  • 19