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
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.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.