Re: replication consistency checking

Поиск
Список
Период
Сортировка
От Jan Lentfer
Тема Re: replication consistency checking
Дата
Msg-id 4623FDBC-612E-46CC-A615-AE1F9CA8C460@web.de
обсуждение исходный текст
Ответ на replication consistency checking  (hydra <hydrapolic@gmail.com>)
Ответы Re: replication consistency checking  (hydra <hydrapolic@gmail.com>)
Список pgsql-admin


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 по дате отправления:

Предыдущее
От: Jan Lentfer
Дата:
Сообщение: Re: replication consistency checking
Следующее
От: Wei Shan
Дата:
Сообщение: Re: replication consistency checking