pt-table-checksum compatibility with Percona XtraDB Cluster

103 views
Skip to first unread message

Laurent MINOST

unread,
Sep 19, 2012, 5:12:49 AM9/19/12
to percona-d...@googlegroups.com
Hi,

Was just wondering if pt-table-checksum is compatible with Percona XtraDB Cluster to check data integrity against all nodes, if yes how do we need to use it in this case please ?

Thanks,
Regards.

Laurent

seppo....@codership.com

unread,
Sep 19, 2012, 5:49:31 AM9/19/12
to percona-d...@googlegroups.com
afaik, pt-table-checksum is not yet compatible with PXC. To run the
checksum in synchronous cluster, each node needs to process the
checksum in same slot of transaction stream. There is support in
Galera side to enable synchronous checksumming. However,
pt-table-checksum will need some tuning to use this new feature.

-seppo

Laurent MINOST

unread,
Sep 19, 2012, 7:26:42 AM9/19/12
to percona-d...@googlegroups.com
Hi Seppo,

Thanks for this answer, maybe someone from Percona will answer with some details about the support of PXC with pt-table-checksum in the near future ?

Regards,

Laurent

Vadim Tkachenko

unread,
Sep 19, 2012, 2:43:06 PM9/19/12
to percona-d...@googlegroups.com
Laurent,

It should be supported in our next Percona Toolkit 2.1.4 release.
> --
> You received this message because you are subscribed to the Google Groups
> "Percona Discussion" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/percona-discussion/-/Y8R95N4jM0MJ.
>
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to
> percona-discuss...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/percona-discussion?hl=en.



--
Vadim Tkachenko, CTO, Percona Inc.
Phone +1-925-400-7377, Skype: vadimtk153
Schedule meeting: http://tungle.me/VadimTkachenko

Looking for Replication with Data Consistency?
Try Percona XtraDB Cluster!

Laurent MINOST

unread,
Sep 21, 2012, 3:58:30 AM9/21/12
to percona-d...@googlegroups.com
Hi Vadim,

Thanks for this information, do you know when is it planned to be released please ?

Regards,

Laurent

Vadim Tkachenko

unread,
Sep 21, 2012, 10:54:59 AM9/21/12
to percona-d...@googlegroups.com
Laurent,

It should be released next week.

Thanks,
Vadim
>> > percona-discuss...@googlegroups.com.
>> > For more options, visit this group at
>> > http://groups.google.com/group/percona-discussion?hl=en.
>>
>>
>>
>> --
>> Vadim Tkachenko, CTO, Percona Inc.
>> Phone +1-925-400-7377, Skype: vadimtk153
>> Schedule meeting: http://tungle.me/VadimTkachenko
>>
>> Looking for Replication with Data Consistency?
>> Try Percona XtraDB Cluster!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Percona Discussion" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/percona-discussion/-/PzkQzVuCyZEJ.
>
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to
> percona-discuss...@googlegroups.com.

Laurent MINOST

unread,
Sep 24, 2012, 3:19:29 AM9/24/12
to percona-d...@googlegroups.com
Hi Vadim,

Thks, I was not expecting such a near ETA :) That's good !

Regards,

Laurent
>> > For more options, visit this group at
>> > http://groups.google.com/group/percona-discussion?hl=en.
>>
>>
>>
>> --
>> Vadim Tkachenko, CTO, Percona Inc.
>> Phone +1-925-400-7377,  Skype: vadimtk153
>> Schedule meeting: http://tungle.me/VadimTkachenko
>>
>> Looking for Replication with Data Consistency?
>> Try Percona XtraDB Cluster!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Percona Discussion" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/percona-discussion/-/PzkQzVuCyZEJ.
>
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to
Reply all
Reply to author
Forward
0 new messages