I have one master environment and two slaves.
MASTER: 192.168.200.14
SLAVE: 192.168.200.74
SLAVE: 192.168.200.12
I ran pt-table-checksum and noticed a difference in slave 200.74.
According to the pt-table-sync manual, “changes are always made at the replication source, never directly on the replica.”
If the changes are made directly at the source (MASTER), I believe that through the binlog, the changes (replace) will also happen on 200.12, which has no differences. Am I right?
The command I intend to execute is this:
pt-table-sync --execute --replicate=percona.checksums --sync-to-master --databases=teste–tables=cadlogenviosmsespecifico h=192.168.200.74,u=usr_xxxxxx,p=xxxxxx --socket=/var/lib/mysql/mysql.sock
The question is:
Does it apply the correction to 200.74 without applying it to the master? Or does it apply it to the master and the data comes through the binlog, also executing on 200.12?
I’m a little confused about how the tool works when you have two replicas.