Postgres Pro
Downloads
Home   >   mailing lists

Re: replication consistency checking - Mailing list pgsql-admin

From Jan Lentfer
Subject Re: replication consistency checking
Date
Msg-id 4623FDBC-612E-46CC-A615-AE1F9CA8C460@web.de
Whole thread Raw
In response to replication consistency checking  (hydra <hydrapolic@gmail.com>)
Responses Re: replication consistency checking
List pgsql-admin
Tree view


Am 04.06.2015 um 06:49 schrieb hydra <hydrapolic@gmail.com>:

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. 



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



pgsql-admin by date:

Previous
From: Jan Lentfer
Date:
Subject: Re: replication consistency checking
Next
From: Wei Shan
Date:
Subject: Re: replication consistency checking