Comment 5 for bug 938068

Revision history for this message
Keith Murphy (bmurphy) wrote :

Why would it no be possible to fix this from the server end? If I have read this correctly, the problem is that MySQL Server doesn't honor the binlog_format setting through multiple levels of slaves. This causes the very real possibility that you could have a slave two levels deep that checksums correctly even though the tables aren't the same because of a setting of row-based replication.

So, at least for Percona Server, why can't this be fixed? In my opinion I should be able to make this change (binlog_format) at the session level and have it replicate through.. I know this is making a modest incompatibility with Oracle, but i think it's a good thing. This is utter speculation, but I would guess the majority of the percona-toolkit packages would be deployed against Percona Server pacakges and not Oracle anyways.

Many of us have moved to row or mixed based replication for performance or data drift issues. It becomes very difficult to use and recommend this tool when it doesn't work in those environments. And fixing the problem in Percona Server would give me one more reason to recommend Percona Server over Oracle or any other variant.

Just my thoughts.

Keith