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 ?
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 ?
Hi,
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.
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.