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 ?
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.
> 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 ?
> 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.
> > 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 ?
On Wed, Sep 19, 2012 at 4:26 AM, Laurent MINOST <lolo...@gmail.com> wrote:
> 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
> Le mercredi 19 septembre 2012 11:49:33 UTC+2, Seppo Jaakola a écrit :
>> 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.
>> > 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 ?
> To post to this group, send email to percona-discussion@googlegroups.com.
> To unsubscribe from this group, send email to
> percona-discussion+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/percona-discussion?hl=en.
> It should be supported in our next Percona Toolkit 2.1.4 release.
> On Wed, Sep 19, 2012 at 4:26 AM, Laurent MINOST <lol...@gmail.com<javascript:>> > wrote: > > 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
> > Le mercredi 19 septembre 2012 11:49:33 UTC+2, Seppo Jaakola a écrit :
> >> 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.
> >> > 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 ?
On Fri, Sep 21, 2012 at 12:58 AM, Laurent MINOST <lolo...@gmail.com> wrote:
> Hi Vadim,
> Thanks for this information, do you know when is it planned to be released
> please ?
> Regards,
> Laurent
> Le mercredi 19 septembre 2012 20:43:51 UTC+2, Vadim Tkachenko a écrit :
>> Laurent,
>> It should be supported in our next Percona Toolkit 2.1.4 release.
>> On Wed, Sep 19, 2012 at 4:26 AM, Laurent MINOST <lol...@gmail.com> wrote:
>> > 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
>> > Le mercredi 19 septembre 2012 11:49:33 UTC+2, Seppo Jaakola a écrit :
>> >> 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.
>> >> > 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 ?
>> > To post to this group, send email to percona-d...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > percona-discussion+unsubscribe@googlegroups.com.
>> > For more options, visit this group at
>> > http://groups.google.com/group/percona-discussion?hl=en.
> To post to this group, send email to percona-discussion@googlegroups.com.
> To unsubscribe from this group, send email to
> percona-discussion+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/percona-discussion?hl=en.
> On Fri, Sep 21, 2012 at 12:58 AM, Laurent MINOST <lol...@gmail.com<javascript:>> > wrote: > > Hi Vadim,
> > Thanks for this information, do you know when is it planned to be > released > > please ?
> > Regards,
> > Laurent
> > Le mercredi 19 septembre 2012 20:43:51 UTC+2, Vadim Tkachenko a écrit :
> >> Laurent,
> >> It should be supported in our next Percona Toolkit 2.1.4 release.
> >> On Wed, Sep 19, 2012 at 4:26 AM, Laurent MINOST <lol...@gmail.com> > wrote: > >> > 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
> >> > Le mercredi 19 septembre 2012 11:49:33 UTC+2, Seppo Jaakola a écrit :
> >> >> 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.
> >> >> > 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 ?
> >> > To post to this group, send email to percona-d...@googlegroups.com. > >> > To unsubscribe from this group, send email to > >> > percona-discussion+unsubscribe@googlegroups.com <javascript:>. > >> > For more options, visit this group at > >> > http://groups.google.com/group/percona-discussion?hl=en.
