MariaDB 5.2.5 MySQL released

Late news but MariaDB MySQL 5.2.5 was released a couple of weeks back. MariaDB 5.2.5 is based on MySQL 5.1.55 with XtraDB InnoDB plugin from Percona Server 5.1.54-12.5. MariaDB version based off MySQL 5.5 seems to close too.

Tried a test upgrade on my local CentOS 5.5 64bit server from MariaDB 5.2.4 Server 64bit to MariaDB 5.2.5 Server 64bit RPM binaries gave me an error complaining that the MariaDB server rpm package was provided by a different vendor MariaDB vs OurDelta so had to manually remove MariaDB 5.2.4 server and install MariaDB 5.2.5 server. As always remember to do a full mysqldump backup of all your MySQL databases before doing upgrades.

rpm -Uvh MariaDB-server-5.2.5-99.el5.x86_64.rpm
warning: MariaDB-server-5.2.5-99.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1bb943db
Preparing...                ########################################### [100%]
 
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-5.2.4-94.el5) is installed.
 
The current MariaDB server package is provided by a different
vendor (MariaDB (http://mariadb.com/)) than OurDelta - http://ourdelta.org/.  Some files may be installed
to different locations, including log files and the service
startup script in /etc/init.d/.
 
A manual upgrade is required.
 
- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'
 
  You may choose to use 'rpm --nodeps -ev ' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by OurDelta - http://ourdelta.org/
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
 
This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(MariaDB-server-5.2.5-99.el5.x86_64) scriptlet failed, exit status 1
error:   install: %pre scriptlet failed (2), skipping MariaDB-server-5.2.5-99.el5

Checking to see MariaDB server is still 5.2.4 based

rpm -qa | grep -i '^MariaDB'
MariaDB-server-5.2.4-94.el5
MariaDB-client-5.2.5-99.el5
MariaDB-devel-5.2.5-99.el5
MariaDB-test-5.2.5-99.el5
MariaDB-shared-5.2.5-99.el5

manually remove it

rpm --nodeps -ev MariaDB-server-5.2.4-94.el5

manually install MariaDB 5.2.5 server

rpm -Uvh MariaDB-server-5.2.5-99.el5.x86_64.rpm
warning: MariaDB-server-5.2.5-99.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1bb943db
Preparing...                ########################################### [100%]
   1:MariaDB-server         ########################################### [100%]
110324 18:32:32 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
110324 18:32:32 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
 
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
 
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
 
Alternatively you can run:
/usr/bin/mysql_secure_installation
 
which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.
 
See the MySQL manual for more instructions.
 
Please report any problems with the /usr/bin/mysqlbug script!
 
The latest information about MariaDB is available at http://www.askmonty.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
Monty Program Ab. You can contact us about this at sales@askmonty.org.
Alternatively consider joining our community based development effort:
http://askmonty.org/wiki/index.php/MariaDB#How_can_I_participate_in_the_development_of_MariaDB
 
Starting MySQL.[  OK  ]
Giving mysqld 2 seconds to start
mysqladmin  Ver 9.0 Distrib 5.2.5-MariaDB, 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.2.5-MariaDB-mariadb99
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 5 min 5 sec
 
Threads: 1  Questions: 1  Slow queries: 0  Opens: 15  Flush tables: 1  Open tables: 8  Queries per second avg: 0.3

For a list of every change made in MariaDB 5.2.5, see the MariaDB 5.2.5 Changelog. For a high-level description of MariaDB 5.2 see the MariaDB 5.2 Overview page.

In most respects MariaDB will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB.

MariaDB 5.2.5 contains the following changes:

Includes MariaDB 5.1.55

For MariaDB 5.2.5 we have merged in all of the changes from MariaDB 5.1.55, including all of the upstream changes from MySQL 5.1.54 and 5.1.55. The MySQL 5.1.54 and 5.1.55 release notes have details of what changes were made upstream by MySQL since 5.1.53.

See the MariaDB 5.1.55 Changelog for a detailed list of the changes in MariaDB 5.1.55.

Includes XtraDB 5.1.54-12.5

We have included XtraDB from Percona Server 5.1.54-12.5 in this version of MariaDB. See the Percona Server release notes for what changes were made upstream by Percona.

New Debian and Ubuntu Repositories

As with MariaDB 5.1.55, for this version of MariaDB we are pleased to announce the availability of Debian and Ubuntu repositories that we will keep up-to-date going forward. The new repositories make use of our world-wide network of MariaDB mirrors and will enable hassle-free upgrades to the latest version of MariaDB as soon as it is released.

See Installing MariaDB .deb Files for information how to setup your Debian or Ubuntu system to use the new repositories.

RPM Package Signing

As part of the new Debian and Ubuntu repositories we have also signed the RPM packages. All RPM package releases going forward will be signed.

New Downloads System

With this version of MariaDB we are also debuting a new MariaDB downloads website. This new site allows you to filter the various files to show only the ones you are interested in and it will attempt to locate the nearest mirror to you based on your IP address.

Bug Fixes

Like previous releases, MariaDB 5.2.5 includes several bug fixes and other improvements. Specific bugs fixed in MariaDB 5.2.5 are listed in the MariaDB 5.2.5 Changelog and MariaDB 5.1.55 Changelog.


Previous:
Next:



MaxCDN Site Acceleration

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



No Comments

Trackbacks/Pingbacks

  1. WHM/Cpanel - MariaDB 5.2.4 MySQL upgrade to MariaDB 5.2.5 | vbtechsupport.com - [...] entry I had me switch out WHM/Cpanel’s default MySQL 5.1.54 for MariaDB 5.2.4 MySQL. Now that MariaDB 5.2.5 MySQL…

Leave a Comment