Not the answer you need?
Register and ask your own question!

can pt-table-checksum support row-based replication

Edward tsangEdward tsang EntrantCurrent User Role Beginner
in manual , row-based replication is LIMITATIONS.

that means pt-table-checksum only support statement-based replication ?

if i set binlog_format as ROW or MIXED ,the pt-table-checksum will not working ?


  • mirfanmirfan Database Administrator Inactive User Role Beginner

    No replication format is not the limitation.
    pt-table-checksum runs equally well regardless of the replication format. pt-table-checksum queries replicates as statement based replication which means if replication format is set as row-based than pt-table-checksum tool will set session binlog format as statement based for pt-table-checksum queries only.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.