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.
- MariaDB 5.2.5 release notes
- Download MariaDB 5.2.5 here: http://downloads.askmonty.org/mariadb/5.2.5.
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.
