Merge lp:~percona-toolkit-dev/percona-toolkit/docu-ptc-rbr-limitation into lp:percona-toolkit/2.1

Proposed by Daniel Nichter
Status: Merged
Merged at revision: 378
Proposed branch: lp:~percona-toolkit-dev/percona-toolkit/docu-ptc-rbr-limitation
Merge into: lp:percona-toolkit/2.1
Diff against target: 50 lines (+16/-5)
1 file modified
bin/pt-table-checksum (+16/-5)
To merge this branch: bzr merge lp:~percona-toolkit-dev/percona-toolkit/docu-ptc-rbr-limitation
Reviewer Review Type Date Requested Status
Daniel Nichter Approve
Review via email: mp+121300@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Daniel Nichter (daniel-nichter) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'bin/pt-table-checksum'
2--- bin/pt-table-checksum 2012-08-24 21:27:11 +0000
3+++ bin/pt-table-checksum 2012-08-24 23:18:18 +0000
4@@ -9784,7 +9784,7 @@
5
6 =head1 SYNOPSIS
7
8-Usage: pt-table-checksum [OPTION...] [DSN]
9+Usage: pt-table-checksum [OPTIONS] [DSN]
10
11 pt-table-checksum performs an online replication consistency check by executing
12 checksum queries on the master, which produces different results on replicas
13@@ -9818,15 +9818,12 @@
14 have a schema that exists on the master (and that schema is checksummed),
15 or if the structure of a table on a replica is different than on the master.
16
17-At the time of this release, we know of no bugs that could cause harm to
18-users.
19-
20 The authoritative source for updated information is always the online issue
21 tracking system. Issues that affect this tool will be marked as such. You can
22 see a list of such issues at the following URL:
23 L<http://www.percona.com/bugs/pt-table-checksum>.
24
25-See also L<"BUGS"> for more information on filing bugs and getting help.
26+See also L<"LIMITATIONS"> and L<"BUGS">.
27
28 =head1 DESCRIPTION
29
30@@ -10900,6 +10897,20 @@
31 You need Perl, DBI, DBD::mysql, and some core packages that ought to be
32 installed in any reasonably new version of Perl.
33
34+=head1 LIMITATIONS
35+
36+=over
37+
38+=item Replicas using row-based replication
39+
40+pt-table-checksum requires statement-based replication, and it sets
41+C<binlog_format=STATEMENT> on the master, but due to a MySQL limitation
42+replicas do not honor this change. Therefore, checksums will not replicate
43+past any replicas using row-based replication that are masters for
44+further replicas. (L<Bug 899415|https://bugs.launchpad.net/percona-toolkit/+bug/899415>)
45+
46+=back
47+
48 =head1 BUGS
49
50 For a list of known bugs, see L<http://www.percona.com/bugs/pt-table-checksum>.

Subscribers

People subscribed via source and target branches