- Original Message -
> From: "Andrew Moore"
> Subject: Re: binlog_format and pt-table-checksum?
>
> pt-table-checksum will set binlog_format to statement for it's own
> session.
To clarify, that means it sets it on the host where it's running; but the set
statement does not get replicat
Rafał,
pt-table-checksum will set binlog_format to statement for it's own session.
As for data drift, there are many causes for it but with statement
based replication for your general replication configuration leaves
you open to non-deterministic functions causing diffs throughout your
data.
HT
Hi All.
I use binlog_format = row for my production databases. In this format most
binlog_format changes are sent not as SQL statements but in some other
format.
I understand that when binlog_format = statement is used, queries on master
and slave can give different results, but should pt-table-ch