pt-table-checksum and mysql 5.7 with binlog_format=ROW

Asked by Clark

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!?

Question information

Language:
English Edit question
Status:
Expired
For:
Percona Server moved to https://jira.percona.com/projects/PS Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said :
#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Revision history for this message
Clark (clark-3) said :
#2

anyone?

Revision history for this message
Launchpad Janitor (janitor) said :
#3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.