Hi All,
I am working on master-slave replication.
Some how two table in slave are showing the difference when i ran pt-table-chekcsum.
The two tables which are having difference doesn’t have unique index or primary key.
i am getting follwoing error while running the table sync for one of the two tables.
Can’t make changes on the master because no unique index exists at /usr/bin/pt-table-sync line 9241.
The pt-table-sync syntax i used is listed as follows:
pt-table-sync --print --sync-to-master --no-check-trigger --no-foreign-key-checks --replicate percona.checksum h=“slave_host_name”,P=port_no,D=“DB _NAME”,t="TABLE_NAME ",u=“username”,p="password&quo t;.
later i found the option --no-check-slave can be used if no unique index are present on a table.
pt-table-sync --print --sync-to-master --no-check-trigger --no-foreign-key-checks --replicate percona.checksum --no-check-slave h=“slave_host_name”,P=port_no,D=“DB _NAME”,t="TABLE_NAME ",u=“username”,p="password&quo t;.
Can some one please help with this issue… …