Percona is glad to announce the release of Percona Toolkit 2.2.6 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. This release has 16 bug fixes and a few new features. One bug fix is very important, so 2.2 users are strongly encouraged to upgrade:
Fixed bug 1223458: pt-table-sync deletes child table rows
There is a warning in the pt-table-sync docs:
Also be careful with tables that have foreign key constraints with ON DELETE
or ON UPDATE definitions because these might cause unintended changes on the
child tables.
Until recently, either no one had this problem, or no one reported it, or no one realized that pt-table-sync caused it. In the worst case, pt-table-sync could delete all rows in child tables, which is quite surprising and bad. As of 2.2.6, pt-table-sync has a new option, on by default: –[no]check-child-tables. In cases were this “bug” can happen, pt-table-sync prints a warning and skips the table. Read the option’s docs to learn more.
Fixed bug 1195628: pt-online-schema-change gets stuck looking for its own _new table
pt-online-schema-change was providing poor feedback. There was a point in the tool where it waited forever for slaves to catch up, but it did this silently. Now the tool reports –progress while it’s waiting and it reports which slaves, if any, it found and intends to check. In short: its feedback delivers a better user experience.
Fixed bug 1214685: pt-mysql-summary schema dump prompt can’t be disabled
pt-mysql-summary schema dump prompt couldn’t be disabled. The change is that pt-mysql-summary no longer prompts to dump and summarize schemas. To do this, you must specify –databases or, a new option, –all-databases. Several users said this behavior was better, so we made the change even though some might consider it a backwards-incompatible change.
All Percona software is free and open-source. Details of the release can be found in the release notes and the 2.2.6 milestone at Launchpad. Bugs can be reported on the Percona Toolkit launchpad bug tracker.
