Pt-table-checksum row

Polyglot Projects Percona Toolkit
1

Tried running the pt-table-checksum with the --no-check-binlog-format, thought that using this flag would by-pass the need to set it as STATEMENT binlog format?

pt-table-checksum --recursion-method=dsn=t=percona.DSN_Table -u percona --ask-pass --no-check-binlog-format

03-11T04:38:51 Failed to /*!50108 SET @@binlog_format := 'STATEMENT'*/: DBD::mysql::db do failed: Access denied; you need (at least one of) the SUPER privilege(s) for this operation [for Statement "/*!50108 SET @@binlog_format := 'STATEMENT'*/"] at /usr/bin/pt-table-checksum line 10211, <STDIN> line 1.

This tool requires binlog_format=STATEMENT, but the current binlog_format is set to ROW and an error occurred while attempting to change it.  If running MySQL 5.1.29 or newer, setting binlog_format requires the SUPER privilege.  You will need to manually set binlog_format to 'STATEMENT' before running this tool.

Running pt-table-checksum 3.5.7

2

Please check your grants , issue is with the grants.

3

Does the master require statement based replication? Currently my master + slaves are running statement based.

Is --[no]check-binlog-format only for bypassing configuration of statement based replication on the slaves?