This release is the current GA (Generally Available) stable release in the 2.0 series.
--defaults-extra-filehas been introduced. This option specifies from what extra file to read the default MySQL options before the standard defaults-file. It can be used to load the user/password combination for the dedicated backup user from a separate configuration file, to avoid storing it in the crontab or a script somewhere in the system.
UNLOCK TABLES. This caused database to be unnecessarily locked with
FLUSH TABLES WITH READ LOCK. Innobackupex now waits only till log copying is finished to unlock the databases. Bug fixed #1055989 (Alexey Kopytov).
--tables-fileoptions of innobackupex, and by the
--tables-fileoptions of XtraBackup. Fixed by removing the partition suffix (
#P#…) before doing filtering. Bug fixed #711166 (Sergei Glushchenko).
sleep()in innobackupex lead to
FLUSH TABLES WITH READ LOCKtaking too long. Fixed by replacing 2 seconds sleep interval with 100 milliseconds one. Bug fixed #1095551 (Sergei Glushchenko).
xtrabackup_suspendedfile on the filesystem. This could then cause innobackupex to think XtraBackup has suspended itself the moment it started, and then when XtraBackup actually does suspend itself, innobackupex would wait for it to end and wouldn’t re-remove the suspend file, leading to a wait deadlock. Fixed by removing the stale
xtrabackup_suspendedfile when innobackupex is started. Bug fixed #1007446 (George Ormond Lorch III).
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.