pt-table-sync sets binlog_format needlessly

Bug #997155 reported by Burak Gürsoy
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
Medium
Baron Schwartz

Bug Description

Hi,

We have a RBR setup and also limited permissons for the related MySQL user.
So, this command

SET @@binlog_format="STATEMENT

is causing problems in our systems. I think it needs to be controlled with an
option to be able to override. I'm attaching a patch for this. The search
functionality in this bug tracker is giving me not found errors. Sorry if
there is an already existing related bug.

Thanks,
Burak

Relevant additional info:

I'm using pt-table-sync 2.1.1

Revision history for this message
Burak Gürsoy (burakgursoy-9) wrote :
Changed in percona-toolkit:
status: New → Triaged
tags: added: privs pt-table-sync rbr
Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

pt-table-sync absolutely requires binlog_format=STATEMENT for making changes in a safe way. However we can do the same thing we did for pt-table-checksum, which is set the format only if it isn't already STATEMENT.

Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

This will be fixed in the upcoming release.

Changed in percona-toolkit:
milestone: none → 2.1.2
assignee: nobody → Baron Schwartz (baron-xaprb)
importance: Undecided → Medium
status: Triaged → Confirmed
summary: - Make the binlog_format setting in pt-table-sync optional
+ pt-table-sync sets binlog_format needlessly
tags: added: useless-work
Changed in percona-toolkit:
status: Confirmed → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-531

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.