Percona Toolkit 2.1.6
Bug fixes, pt-stalk --plugin, renaming columns with pt-online-
Download files for this release
Percona Toolkit 2.1.6 has been released. This release includes 33 bug fixes and three new features: pt-online-
* Bug 978133: pt-query-digest review table privilege checks don't work
The same checks were removed from pt-table-checksum on 2.1.3 and pt-table-sync on 2.1.4, so this just follows suit.
* Bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
A particularly important fix, as it may stop pt-table-checksum from breaking replication in these setups.
* Bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
If you run multiple instances of pt-table-checksum on a badly lagged server, actually respecting --run-time stops the instances from divebombing the server when the replica catches up.
* Bug 1062324: pt-online-
Fixed by choosing a key on the new table for the DELETE trigger.
* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
A follow up to the same fix in the previous release, this adds to warnings for cases in which pt-table-checksum may work incorrectly and require some user intervention: One for the case of master -> cluster, and one for cluster1 -> cluster2.
* Bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
This bug has hounded the toolkit for quite some time. In some platforms, trying to use LOAD DATA LOCAL INFILE would fail as if the user didn't have enough privileges to perform the operation. This was a misdiagnoses from MySQL; The actual problem was that the libmysqlclient.so provided by some vendors was compiled in a way that disallowed users from using the statement without some extra work. This fix adds an 'L' option to the DSNs the toolkit uses, tells the the tools to explicitly enables LOAD DATA LOCAL INFILE. This affected two pt-archiver and pt-upgrade, so if you are on an effected OS and need to use those, you can simply tag an L=1 to your DSN and everything should start working.
* Bug 866075: pt-show-grant doesn't support column-level grants
This was actually the 'hottest' bug in the tracker.
This is another solid bug fix release, and all 2.1 users are encouraged to upgrade.
3 blueprints and 34 bugs targeted
|Rename columns with pt-online-schem-change||4 High||Brian Fraser||11 Implemented|
|pt-stalk --plugin||4 High||Daniel Nichter||11 Implemented|
|pt-online-schema-change --default-engine||3 Medium||Daniel Nichter||11 Implemented|