How to use
pt-table-checksum in mysql 5.7 where
binlog_format=ROW is default
I also need
binlog_format=ROW to be set this way in relation to other parameters in the mysql configuration
# pt-table-checksum h=localhost,u=checksum,p=xxx Replica Worker-Intel-i7-2600-16gb has binlog_format ROW which could cause pt-table-checksum to break replication. Please read "Replicas using row-based replication" in the LIMITATIONS section of the tool's documentation. If you understand the risks, specify --no-check-binlog-format to disable this check.
I have tried to read about the limitations, but doesn't really understand what would/could happen if
--no-check-binlog-format is used
If I set
binlog_format=MIXED I still get the error!?