Percona Tools

pt-table-sync

Synchronize MySQL table data efficiently.

Documentation:

https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-sync.html

Example command:

   pt-table-sync --password <mysql root password> --execute --sync-to-master h=<other database server>,D=enswitch,t=location --print