Re: replication consistency checking

[hydra <hydrapolic@xxxxxxxxx>]

On Tue, Jun 9, 2015 at 10:15 PM, Jan Lentfer <Jan.Lentfer@xxxxxx> wrote:

Am 04.06.2015 um 06:49 schrieb hydra <hydrapolic@xxxxxxxxx>:

After setting up streaming replication, is it possible to check whether the slave has the same data as the master?

In the MySQL world there is the percona-toolkit with pt-table-checksum that does this job:
https://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html

Thank you

I have not digged to deep, but as far as I can see from your link:

pt-table-checksum requires statement-based replication, and it sets binlog_format=STATEMENT on the master

And the mysql manual says

If you are using InnoDB tables and the transaction isolation level is READ COMMITTED or READ UNCOMMITTED, only row-based logging can be used. 

https://dev.mysql.com/doc/refman/5.6/en/binary-log-setting.html

So, if I am not misinterpreting, this plays in a different league.

Jan

The recommended binlog format for replication is ROW, so everything except the checks is using ROW and only those checks have STATEMENT set.