The Percona Toolkit team is happy to announce the release of Percona Toolkit versions 2.0.5 and 2.1.2. These are bug-fix releases in the 2.0 and 2.1 series, respectively. These releases fix many dozens of bugs, and we suggest that users upgrade to the latest versions of the tools.

The complete list of changes is on Launchpad for 2.0.5 and 2.1.2. Here are some highlights of the changes in version 2.1.2, which is the current development focus:

• We fixed several bugs in pt-table-sync that prevented it from working properly, and disabled the –lock-and-rename feature when using it with MySQL versions that don’t support it reliably.
• We enhanced pt-table-checksum and pt-online-schema-change to add even more safety checks, and to detect and deal with …

Many of you heard of this nasty security vulnerability in MySQL, and as we are getting a lot of inquiries how does it affect Percona Server, I decided to address it in this post.

• The issue exists in the source code of MySQL 5.5.23 or earlier and MySQL 5.1.62 or earlier. The same is true for Percona Server, as we share the same code base.
• However binaries provided by Percona do not have this problem, as in our build process we do not use sse-optimized glibc memcmp. This is true for any version of Percona and all tar.gz, RPM and DEB packages. Once again, if you use binary builds, provided by Percona from our official download area, or from our repositories, you are safe.
• If you use your own or third-party binaries, …

I am happy to announce next version Percona XtraDB Cluster 5.5.24, which is mostly jump to the current version of Percona Server.

It includes an important bug fix:

• table with no PK but still having UK, can cause crash in slave using PA

Binaries are available from downloads area or from our repositories.

For this release we provide binaries for Ubuntu 12.04.

If you want to know more how to migrate to XtraDB Cluster, you can check our recent webinar Migrating To Percona XtraDB Cluster.

This is an General Availability release. We did our best to eliminate bugs and problems during alpha and …

One of our customers asked me whether it’s safe to enable the so-called USER_STATISTICS features of Percona Server in a heavy-use production server with many tens of thousands of tables.

If you’re not familiar with this feature, it creates some new INFORMATION_SCHEMA tables that add counters for activity on users, hosts, tables, indexes, and more. This is very helpful information. It lets you run queries to see which tables get the most reads and writes, for example. Another popular use for it is to find unused indexes.

I knew that some of our customers were using the feature enabled in production all the time, and I knew that Google and Facebook and others (the original developers) did also. But I didn’t know the …

Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working on a customer case this week I saw an interesting problem where a table had many heavily utilized TEXT fields with some read queries exceeding 500MB (!!), and stored in a 100GB table. In this case we were not allowed to make any query or application logic changes so we chose to implement the Barracuda file format and utilize compressed rows as this appealed to me for this mostly-read application. One quick way you can see if your rows will benefit from compression would be to read Peter Zaitsev’s blog post and execute:

SELECT AVG(LENGTH((`colTextField`)) FROM `t1` WHERE `id` < 1000

compare this to:

SELECT AVG(LENGTH(COMPRESS(`colTextField`))) FROM `t1` WHERE `id` < …

Percona is glad to announce the release of Percona Server 5.1.63-13.4 on May 24th, 2012 (Downloads are available from Percona Server 5.1.63-13.4 downloads and from the Percona Software Repositories).

Based on MySQL 5.1.63, including all the bug fixes in it, Percona Server 5.1.63-13.4 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.1.63-13.4 milestone at Launchpad.

Bugs fixed:

Our previous GA release of Percona XtraDB Cluster caused a lot of interest and feedback. I am happy to announce next version Percona XtraDB Cluster 5.5.23, which comes with bug fixes and improvements.

List of changes:

• Fixes merged from upstream (Codership-mysql)
• Support for MyISAM, now changes to MyISAM tables are replicated to other nodes
• Improvements to XtraBackup SST methods, better error handling
• New SST wsrep_sst_method=skip, useful when you start all nodes from the same sources (i.e. backup)
• Ability to pass list of IP addresses for a new node, it will connect to the first available

Binaries are available from downloads area or from our repositories.

For …

I’m happy to announce that version 1.0 of Percona Monitoring Plugins is now available. The Percona Monitoring Plugins are high-quality plugins, templates, and add-ons for Nagios and Cacti, so you can add world-class MySQL monitoring to your existing enterprise open-source monitoring products.

Version 1.0 fixes a variety of bugs that users found in version 0.9.0. Here are the usual links: changelog, documentation, downloads, source code, …

If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL.

• Percona Live DC 2012
• Percona Live MySQL Conference & Expo 2012

PRM is an OCF Resource Agent for Corosync / …

I’m proud to announce the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL.

With this release we introduce a new version of pt-online-schema-change, a tool that enables you to ALTER large tables with no blocking or downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking. Client applications can continue reading and writing the table with no interruption.

With this new version of the tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project’s schedule because the release involved an ALTER, which …