MariaDB 5.3.0 Beta MySQL & Percona Xtrabackup 1.6.2 Released
MariaDB 5.3.0 Beta MySQL and Percona Xtrabackup 1.6.2 releases have been announced one day apart. MariaDB 5.3.0 Beta can be downloaded here. Percona Xtrabackup 1.6.2 was released a day before MariaDB 5.3.0 beta so I assume they didn’t have time to update their Innobackupex-1.5.1 script to detect and work with MariaDB 5.3.0 beta so I updated my Innobackupex-1.5.1 patch mentioned here to work with MariaDB 5.3.0 beta. I’ve confirmed the patch allows Percona Xtrabackup 1.6.2’s Innobackupex-1.5.1 script to detect and work with MariaDB 5.2 and 5.3 MySQL servers.
What about MariaDB 5.5 ?
Posted on Monty’s blog:
When it comes to MariaDB 5.5 we have just finished the first big merge between MariaDB 5.3 and MySQL 5.5 and we are now working on merging the recent changes. This should be released shortly (you can follow the work on launchpad). We will continue to fix bugs in both version for some time! The reason we are releasing 5.3 and 5.5 is that we don’t want to delay users the features in 5.3 while we work to merge and stabilize 5.5. (We don’t expect any problems with 5.5 but as one never knows we want to play safe.).
Please test MariaDB 5.3 and report bugs to launchpad! The more input we can ge the quicker we can do stable (GA) release.
MariaDB 5.3.0 Beta:
MariaDB 5.3.0 is a Beta release. In general this means that there are no known serious bugs, except for those marked as feature requests. MariaDB 5.3 radically improves performance for subqueries as well as for joins and single-table queries over large data sets.
- Subquery optimizations
- Join & disk access optimizations
- NoSQL-style interfaces
- Dynamic columns
- Group commit for the binary log
- Microsoft Windows performance improvements – including back porting Windows performance patches from MySQL 5.5 to MariaDB 5.3
MariaDB 5.3.0 Beta installed on local test CentOS 5.5 64bit server
[root@localhost ~]# rpm -qa | grep -i Mariadb MariaDB-server-5.3.0-101.el5 MariaDB-client-5.3.0-101.el5 MariaDB-devel-5.3.0-101.el5 MariaDB-test-5.3.0-101.el5 MariaDB-shared-5.3.0-101.el5 |
[root@localhost ~]# mysqladmin ver mysqladmin Ver 9.0 Distrib 5.3.0-MariaDB-beta, for unknown-linux-gnu on x86_64 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc, 2009 Monty Program Ab This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.3.0-MariaDB-beta-mariadb101 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 7 min 17 sec Threads: 1 Questions: 34 Slow queries: 0 Opens: 15 Flush tables: 2 Open tables: 0 Queries per second avg: 0.77 |
MariaDB [(none)]> show plugins; +--------------------------------+--------+--------------------+---------+---------+ | Name | Status | Type | Library | License | +--------------------------------+--------+--------------------+---------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL | | mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | partition | ACTIVE | STORAGE ENGINE | NULL | GPL | | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL | | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | FEDERATED | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | Aria | ACTIVE | STORAGE ENGINE | NULL | GPL | | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | PBXT | ACTIVE | STORAGE ENGINE | NULL | GPL | | PBXT_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL | | INNODB_RSEG | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_POOL_PAGES | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_POOL_PAGES_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_POOL_PAGES_BLOB | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_TABLE_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_INDEX_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | XTRADB_ADMIN_COMMAND | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | XTRADB_ENHANCEMENTS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | +--------------------------------+--------+--------------------+---------+---------+ 33 rows in set (0.00 sec) |
Percona Xtrabackup 1.6.2:
This release is purely composed of bug fixes and is the current stable release of Percona Xtrabackup. All of Percona’s software is open-source and free, all the details of the release and its development process can be found in the 1.6.2 milestone at Launchpad.
–version
The --version option has been added to the xtrabackup binary for printing its version. Previously, the version was displayed only while executing the binary without arguments or performing a backup. Bug Fixed: #610614 (Alexey Kopytov).
Changes
-
As exporting tables should only be used with
innodb-file-per-tableset in the server, the variable is checked byxtrabackupwhen using the--exportoption. It will fail before applying the archived log without producing a potentially unusable backup. Bug Fixed: #758888 (Alexey Kopytov).
Bugs Fixed
-
When creating an InnoDB with its own tablespace after taking a full backup, if the log files have been flushed, taking an incremental backup based on that full one would not contain the added table. This has been corrected by explicitly creating the tablespace before applying the delta files in such cases. Bug Fixed: #766607(Alexey Kopytov).
-
In some cases,
innobackupexignored the specifiedxtrabackupbinary with the--ibbackupoption. Bug Fixed: #729497 (Stewart Smith). -
Minor file descriptors leaks in error cases were fixed. Bug Fixed: #803718 (Stewart Smith).
Other Changes
-
Improvements and fixes on platform-specific distribution: #785556 (Ignacio Nin)
For more information, please see the following links:
-
Downloads: Binary distributions, Percona Software Repositories
Patched Innobackupex-1.5.1 from Percona Xtrabackup output from my mysqlmybackup.sh script’s xtrabackup option
[root@localhost ~]# ./mysqlmybackup.sh xtrabackup InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona Inc 2009-2011. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. 110729 14:33:25 innobackupex-1.5.1: Starting mysql with options: --defaults-file='/etc/my.cnf' --password='pass' --user='mysqlmon' --unbuffered -- 110729 14:33:25 innobackupex-1.5.1: Connected to database with mysql child process (pid=5637) 110729 14:33:31 innobackupex-1.5.1: Connection to database server closed IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex-1.5.1 prints "completed OK!". innobackupex-1.5.1: Using mysql Ver 15.0 Distrib 5.3.0-MariaDB-beta, for unknown-linux-gnu (x86_64) using readline 5.1 innobackupex-1.5.1: Using mysql server version This software comes with ABSOLUTELY NO WARRANTY. This is free software, innobackupex-1.5.1: Created backup directory /mysqlbackup/xtrabackup/2011-07-29_14-33-31 110729 14:33:31 innobackupex-1.5.1: Starting mysql with options: --defaults-file='/etc/my.cnf' --password='pass' --user='mysqlmon' --unbuffered -- 110729 14:33:31 innobackupex-1.5.1: Connected to database with mysql child process (pid=5661) 110729 14:33:35 innobackupex-1.5.1: Connection to database server closed 110729 14:33:35 innobackupex-1.5.1: Starting ibbackup with command: xtrabackup --defaults-file="/etc/my.cnf" --backup --suspend-at-end --target-dir=/mysqlbackup/xtrabackup/2011-07-29_14-33-31 innobackupex-1.5.1: Waiting for ibbackup (pid=5672) to suspend innobackupex-1.5.1: Suspend file '/mysqlbackup/xtrabackup/2011-07-29_14-33-31/xtrabackup_suspended' xtrabackup version 1.6.2 for Percona Server 5.1.55 unknown-linux-gnu (x86_64) (revision id: 274) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql/ xtrabackup: Target instance is assumed as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:50M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 67108864 xtrabackup: use O_DIRECT >> log scanned up to (8221581047) [01] Copying ./ibdata1 to /mysqlbackup/xtrabackup/2011-07-29_14-33-31/ibdata1 [01] ...done 110729 14:33:39 innobackupex-1.5.1: Continuing after ibbackup has suspended 110729 14:33:39 innobackupex-1.5.1: Starting mysql with options: --defaults-file='/etc/my.cnf' --password='pass' --user='mysqlmon' --unbuffered -- 110729 14:33:39 innobackupex-1.5.1: Connected to database with mysql child process (pid=5685) >> log scanned up to (8221581047) 110729 14:33:43 innobackupex-1.5.1: Starting to lock all tables... >> log scanned up to (8221581047) >> log scanned up to (8221581047) 110729 14:33:53 innobackupex-1.5.1: All tables locked and flushed to disk 110729 14:33:53 innobackupex-1.5.1: Starting to backup .frm, .MRG, .MYD, .MYI, innobackupex-1.5.1: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in innobackupex-1.5.1: subdirectories of '/var/lib/mysql/' innobackupex-1.5.1: Backing up file '/var/lib/mysql//db2/db.opt' innobackupex-1.5.1: Backing up file '/var/lib/mysql//sbtest/sbtest1.MYI' innobackupex-1.5.1: Backing up file '/var/lib/mysql//sbtest/sbtest1.MYD' >> log scanned up to (8221581047) >> log scanned up to (8221581047) >> log scanned up to (8221581047) >> log scanned up to (8221581047) innobackupex-1.5.1: Backing up file '/var/lib/mysql//sbtest/db.opt' >> log scanned up to (8221581047) innobackupex-1.5.1: Backing up file '/var/lib/mysql//sbtest/sbtest2.MYD' >> log scanned up to (8221581047) >> log scanned up to (8221581047) >> log scanned up to (8221581047) >> log scanned up to (8221581047) innobackupex-1.5.1: Backing up file '/var/lib/mysql//sbtest/sbtest1.frm' innobackupex-1.5.1: Backing up file '/var/lib/mysql//sbtest/sbtest2.frm' innobackupex-1.5.1: Backing up file '/var/lib/mysql//sbtest/sbtest2.MYI' >> log scanned up to (8221581047) >> log scanned up to (8221581047) >> log scanned up to (8221581047) >> log scanned up to (8221581047) >> log scanned up to (8221581047) innobackupex-1.5.1: Backing up files '/var/lib/mysql//roundcube/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (28 files) innobackupex-1.5.1: Backing up files '/var/lib/mysql//horde/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (130 files) innobackupex-1.5.1: Backing up files '/var/lib/mysql//mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (69 files) 110729 14:35:43 innobackupex-1.5.1: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files innobackupex-1.5.1: Resuming ibbackup xtrabackup: The latest check point (for incremental): '8221581047' >> log scanned up to (8221581047) xtrabackup: Stopping log copying thread. xtrabackup: Transaction log of lsn (8221581047) to (8221581047) was copied. 110729 14:35:45 innobackupex-1.5.1: All tables unlocked 110729 14:35:45 innobackupex-1.5.1: Connection to database server closed innobackupex-1.5.1: Backup created in directory '/mysqlbackup/xtrabackup/2011-07-29_14-33-31' innobackupex-1.5.1: MySQL binlog position: filename '', position 110729 14:35:45 innobackupex-1.5.1: completed OK! Successfully backed up all databases using Percona XtraBackup / innobackupex ******************************************************* Full MySQL data directory backed up at: /mysqlbackup/xtrabackup ******************************************************* Jul 29 14:35 4.0K 2011-07-29_14-33-31 XtraBackup last backup directory created at: 2011-07-29_14-33-31 Jul 29 14:33 382 backup-my.cnf Jul 29 14:33 50M ibdata1 Jul 29 14:33 0 mysql-stderr Jul 29 14:33 1 xtrabackup_binlog_info Jul 29 14:33 4.0K db2 Jul 29 14:35 4.0K sbtest Jul 29 14:35 4.0K roundcube Jul 29 14:35 2.5K xtrabackup_logfile Jul 29 14:35 83 xtrabackup_checkpoints Jul 29 14:35 4.0K test Jul 29 14:35 312 mysql-stdout Jul 29 14:35 4.0K mysql Jul 29 14:35 4.0K horde Jul 29 14:35 10 xtrabackup_binary Time: ******************************** ================================ Fri Jul 29 14:35:46 EST 2011 ================================ ******************************** |
