I’m using pt-table-sync to try to synchronize a table between two hosts. I have executed this command (Passwords are clear because are hosts in lan environment - lab):
pt-table-sync h=127.0.0.1,u=root,p=mySQL3v@n,P=3306,D=radius,t=radcheck h=192.168.1.78,u=root,p=m1rr0r,P=3306,D=radius,t=radcheck --execute --replicate percona.checksums
This command’s output shows a lot of querys (REPLACE INTO) but I would like to get differences between both only. So, what is wrong? Anybody can help me?
Thanks in advance.