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.

  1. Subquery optimizations
  2. Join & disk access optimizations
  3. NoSQL-style interfaces
  4. Dynamic columns
  5. Group commit for the binary log
  6. Microsoft Windows performance improvementsincluding 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.

New Options

–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-table set in the server, the variable is checked by xtrabackup when using the --export option. 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, innobackupex ignored the specified xtrabackup binary with the --ibbackup option. 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 the XtraBackup Test Suite: #744303#787966 (Alexey Kopytov)
  • Improvements and fixes on platform-specific distribution: #785556 (Ignacio Nin)
  • Improvements and fixes on the XtraBackup Documentation: #745185#721339 (Rodrigo Gadea)

For more information, please see the following links:

 
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
================================
********************************

 


Previous:
Next:



MaxCDN Site Acceleration

Get Cost Effective Content Delivery
Unbeatable speed, stats, & price
http://www.maxcdn.com



Leave a Comment