Hi Team,
I have setup pt-table-checksum and pt-table-sync for fixing the data issues between master and slaves.
when i ran pt-table-checksum i found few tables were not sink with the master tables,then i fired pt-table-sync it’s applied some inserts into that particular table.
Then in the next pt-table-checksum run i’m able to see the old table which had updated by the pt-table-sync(this shouldn’t come right ?). what is reason of this ?
Below are the commands i’m using.
pt-table-checksum -u xxxx -pxxxx --replicate-check --databases db --replicate percona.checksum P=3306,h=Master IP
Output :
db tbl total_rows chunks
db tb11 60 1
db tbl3 38 1
Then i fired pt-table-sync,
pt-table-sync h=Master IP,P=3306,D=“db”,t=“tbl1”,u=“xxxxx”,p=“xxxxx” h=Slave IP,P=3306 --print --no-check-trigger --no-foreign-key-checks --no-check-slave
Output : this fired few inserts on “tbl1” table
Then i fired pt-table-checksum again, but i could see the old output which i had seen before the pt-table-sync
pt-table-checksum -u xxxx -pxxxx --replicate-check --databases db --replicate percona.checksum P=3372,h=Master IP
Output :
db tbl total_rows chunks
db tb11 60 1
db tbl3 38 1
Please provide the solution of this ASAP.
Thanks,
Krish