I basically have 2 queries.
(1) I have a lot of temporary tables on master , which i am not replicating on slave , and i want to skip those tables during check , all table starts with “TMP_” , i tried all possible regex combination but the tool is not ignoring those tables.
(2) I am trying to figure out the consistancy at slave and running the tool on master , i have got two ways through internet but don’t know which is the best. Following are the two ways.
(A.) perl /usr/bin/pt-table-checksum --set-vars innodb_lock_wait_timeout=50 --set-vars wait_timeout=50 --no-check-binlog-format --quiet
(B) pt-table-checksum --replicate=test.checksum --replicate-check-only --set-vars innodb_lock_wait_timeout=50 --set-vars wait_timeout=50 --no-check-binlog-format
Can some one help me in guiding me which is best for master/slave.