1

I have two mysql servers, both of which are masters. After some problems with their local network they lost connection with each other but continued working some time, without any synchronization. Both of them store some data from this period, and it would be bad to lose part of it.

Is it possible to merge dumps from these servers with any util?

VictorKilo
  • 1,839
  • 3
  • 24
  • 39
Anton Ishkov
  • 115
  • 1
  • 5

1 Answers1

2

I think you could find pt-table-sync helpful. But be sure to use it on backups of your data for safety and to reset the replication after using it as the changes you make will be replicated to the origin server if not.

Clarence
  • 2,944
  • 18
  • 16