Percona Tools

From Integrics Wiki
Jump to: navigation, search

pt-table-sync

Synchronize MySQL table data efficiently. The table must have a primary key. If changing the location table and it doesn't have one, you must add one first, and then remove it afterwards.

Documentation:

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

Example command to sync the location table:

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