Percona is glad to announce the release of Percona XtraBackup 2.0.3 on October 1st, 2012. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. New Features: innobackupex now supports new –move-back option that can be used instead of –copy-back in case [...]
Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
Percona is glad to announce the release of Percona Server 5.1.65-14.0 on September 4th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.65, including all the bug fixes in it, Percona Server 5.1.65-14.0 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 [...]
Announcing Percona XtraBackup 2.0.2
August 14, 2012 By 2 Comments
Percona is glad to announce the release of Percona XtraBackup 2.0.2 on August 13th, 2012. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. Bugs Fixed: Fixed false positive test suite failures with grep 2.10. Bug fixed #996483 (Alexey Kopytov). Incremental backup would [...]
Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
Some people want to use a backup to prepare a new Percona XtraDB Cluster node. They want this to avoid State Snapshot Transfer that could slow down the donor (depending of the SST method you are using, the donor can be blocked. I will cover this in a future blog post). As backup are generally [...]
Announcing Percona XtraBackup 2.0.1
June 25, 2012 By 1 Comment
Percona is glad to announce the release of Percona XtraBackup 2.0.1 on June 25th, 2012. Downloads are available from our download site and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. This release contains over 20 fixed bugs, some of the more significant bugs fixed are: [...]
On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
The MySQL manual tells us that regardless of whether or not we use “SET FOREIGN_KEY_CHECKS=0″ before making schema changes, InnoDB will not allow a column referenced by a foreign key constraint to be modified in such a way that the foreign key will reference a column with a mismatched data type. For instance, if we [...]
Find and remove duplicate indexes
June 20, 2012 By 9 Comments
Having duplicate keys in our schemas can hurt the performance of our database: They make the optimizer phase slower because MySQL needs to examine more query plans. The storage engine needs to maintain, calculate and update more index statistics DML and even read queries can be slower because MySQL needs update fetch more data to [...]
Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
Thanks to all who attended my webinar today. The session was recorded and will be available to watch for free soon here. There were a lot of great questions asked during the session, so I’d like to take this opportunity to try to answer a few of them: Q: Is there an easy way to [...]
Secure passwords being insecure
May 27, 2012 By 6 Comments
If you follow the general advices to create secure password the following ones seem to be secure, right? s11P$||!sh&2 pr0&!!ke0 3kj39|!381 The answer to the question is, “it depends on how you use them” Notice that these passwords all contain multiple exclamation points and ampersands which are normally special characters for your shell. The people [...]
Percona is Speaking At Open Source Data Center Conference in Nuremberg, Germany
April 19, 2012 By Leave a Comment
Percona has 2 talks lined up at OSDC in Nuremberg, Germany: – Taking hot backups with XtraBackup by Alexey Kopytov – Expert Troubleshooting: Resolving MySQL Problems Quickly by Kenny Gryp Feel free to come and say Hi! On April 25 & 26, 2012 the Open Source Data Center Conference will invite experienced administrators and architects [...]
