MariaDB 5.2 is no longer maintained. Please use a more recent release.

Download MariaDB 5.2

contains features that didn't have time to go into . For all practical purposes it's a drop in replacement for (and thus MySQL 5.1).

is based on and thus MySQL 5.1.

The new features in 5.2 are quite isolated and as most have been in use by members in the MySQL community for a long time. Current versions of are and can be downloaded from .

New storage engines

• • Allows you to handle hierarchies (tree structures) and complex graphs (nodes having many connections in several directions)

• : Text search within MariaDB.

  • A built-in Sphinx client which allows MariaDB to talk to searchd, run search queries, and obtain search results.

New features

• • Columns that are an expression and are calculated on retrieval.

• • Client, User, Index and Table statistics.

Other things

We have also done several smaller speed improvements, bug fixes and code cleanups.

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

• : : : : : : : []: []: : , : ]: : : :

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download | Release Notes | Changelog |Overview of 5.2

Release date: 29 Nov 2012

MariaDB 5.2.13 is a Stable (GA) release. In general this means that there are no known serious bugs, except for those marked as feature requests, that no bugs were fixed since last release that caused notable code changes, and that we believe the code is ready for general usage (based on bug inflow).

For a description of MariaDB 5.2 see the What is MariaDB 5.2 page.

For a list of changes made in MariaDB 5.2.13, with links to detailed information on each push, see the MariaDB 5.2.13 Changelog.

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

Important Security Fixes

• includes a fix for , a vulnerability that allowed an authenticated user to crash MariaDB server or to execute arbitrary code with the privileges of the mysqld process. This is a serious security issue. We recommend upgrading from older versions as soon as possible.

• A fix is also included for multiple SQL injection vulnerabilities in the replication code. See () for details.

Includes and MySQL 5.1.66

This version of MariaDB includes , and by extension, MySQL 5.1.66. See the for the changes made in and see for what changed between this and previous MySQL versions.

The most recent release in the is:

|Release Notes | |

Release date: 6 Apr 2012

is a (GA) release. In general this means that there are no known serious bugs, except for those marked as feature requests, that no bugs were fixed since last release that caused notable code changes, and that we believe the code is ready for general usage (based on bug inflow).

For a description of see the page.

For a list of changes made in , with links to detailed information on each push, see the .

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

The most recent release in the is:

| Release Notes | |

Release date: 18 Jun 2010

Release Notes

See the page for a high-level overview of the differences between MariaDB and MySQL.

The has a detailed list of the changes inluded in this release. For a description of this release see the .

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download |Release Notes |Changelog |Overview of 5.2

Release date: 22 Sep 2011

MariaDB 5.2.9 is a Stable release.In general this means there are no known serious bugs and we believe the code is ready for general usage. A "stable" MariaDB release is equivalent to a MySQL "GA" release.

For a detailed description of MariaDB 5.2 see the What is MariaDB 5.2 page.

Compared to MariaDB 5.2.8, MariaDB 5.2.9 is a bug-fix release.

For a list of every change made in MariaDB 5.2.9, with links to detailed information on each push, see the MariaDB 5.2.9 Changelog.

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

Be notified of new releases automatically by adding the to your favorite feed reader or by to the announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list).

MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

2 Nov 2011 Update:

We've updated the Ubuntu packages for . Apart from now including packages for Ubuntu 11.10 "Oneiric" the only other change is to remove the default apparmor profile.

Ubuntu 11.10 "Oneiric" introduced some significant . Rather than try to keep our apparmor profile in sync with Ubuntu and risk a future breakage when they decide to change something else, we have decided to include an empty profile in our packages. If you have customized your/etc/apparmor.d/usr.sbin.mysqld file you will be given the option to keep or remove it during the upgrade. If you haven't customized the default profile, the profile will be removed.

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download |Release Notes |Changelog |Overview of 5.2

Release date: 2 Apr 2012

MariaDB 5.2.11 is a Stable (GA) release. In general this means that there are no known serious bugs, except for those marked as feature requests, that no bugs were fixed since last release that caused a notable code changes, and that we believe the code is ready for general usage (based on bug inflow).

For a description of MariaDB 5.2 see theWhat is MariaDB 5.2 page.

For a list of changes made in MariaDB 5.2.11, with links to detailed information on each push, see the MariaDB 5.2.11 Changelog.

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

Includes and MySQL 5.1.61

This version of MariaDB includes , and by extension, MySQL 5.1.61. See the for the changes made in and see for what changed between this and previous MySQL versions.

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download | Release Notes | Changelog |Overview of 5.2

Release date: 6 Dec 2010

This is a stable release. In general this means there are no known serious bugs and we believe the code is ready for general usage. For a high-level description of MariaDB 5.2 see the MariaDB 5.2 overview.

See the Changelog for a list of all changes included in this release.

Includes

has all changes from , including MySQL 5.1.53.

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

Includes 5.1.52-11.6

We have included XtraDB from Percona-server-5.1.52-11.6 in this version of MariaDB.

New Packages

For this version of MariaDB we have started building Ubuntu 10.10 "Maverick" and Debian 6 "Squeeze" packages.

Bug Fixes

Like , includes several bug fixes and other improvements. Specific bugs fixed in include:

• slow shutdown of XtraDB

• A fix from MySQL 5.1.52 for a serious regression: and Windows service cannot start

• Various fixes for .deb packaging:

  • mysqld_safe hangs spinning at 100% CPU

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download |Release Notes |Changelog |Overview of 5.2

Release date: 14 Jun 2011

MariaDB 5.2.7 is a Stable release. In general this means there are no known serious bugs and we believe the code is ready for general usage. A "stable" MariaDB release is equivalent to a MySQL "GA" release.

For a high-level description of MariaDB 5.2.7 see the What is MariaDB 5.2 page.

For a list of every change made in MariaDB 5.2.7, including the various bugs that were fixed and links to detailed information on each push, see the MariaDB 5.2.7 Changelog. See previous release notes and changelogs for changes made in previous versions of MariaDB.

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

Be notified of new releases automatically by adding the to your favorite feed reader or by to the announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list).

MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

contains the following changes:

Faster Internal Temporary Tables

In we've added some improvements and optimizations which result in faster internal temporary tables for some edge cases (when using GROUP BY without summary functions).

HeidiSQL GUI client now included in Windows MSI package

Beginning with , the GPLv2 licensed graphical client is now included in the Windows MSI installer package. A big thanks to Ansgar Becker for helping make this happen.

Red Hat Enterprise Linux (RHEL) 5 RPMs

Starting with , we are now building Red Hat Enterprise Linux (RHEL) 5 RPM packages. This is in addition to our CentOS 5 packages, which we will continue to provide.

Other fixes and enhancements

• Fixed problem with wrong priority (nice -19) on mysqld server

• Fixed crash with partitioned archive tables where there were too few file descriptors

• Lots of small fixes for easier windows builds

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download | Release Notes | Changelog |Overview of 5.2

Release date: 28 Sep 2010

This is a gamma release. In general this means we believe the code is ready for general usage (based on bug inflow), but we want more testing before calling it stable. For a list of every change made in this release, see the Changelog. For a description of this release see the MariaDB 5.1 overview.

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

In addition to the differences noted in previous release notes and changelogs, the main new things in this version of MariaDB 5.2 are:

Includes

For we have merged in all of the changes from , which included + some new bug fixes which will be in , and MySQL 5.1.51. The have details of what changes were made.

Maria Storage Engine Renamed to Aria

In this version of the Maria Storage Engine has been renamed to .

SphinxSE

The Sphinx Storage Engine has been added to MariaDB. It is built as a dynamically loadable .so plugin, so use it you need to perform a one-time . See the page for more details.

Bug Fixes

The main drive for this version of (compared to the previous two beta releases) was to fix bugs and otherwise prepare for a stable release of . So, as in , in many bug fixes and other improvements were made. See the for details and links to the bugs that were fixed.

| Release Notes | |

Release date: 30 Jan 2013

This is a (GA) release. In general this means that there are no known serious bugs, except for those marked as feature requests, that no bugs were fixed since last release that caused a notable code changes, and that we believe the code is ready for general usage (based on bug inflow).

For a description of see the page.

For a list of changes made in this release, with links to detailed information on each push, see the .

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

This release is primarily a bug-fix release.

The most recent release in the is:

| Release Notes | |

Release date: 10 Nov 2010

Update: New Packages for Debian and Ubuntu (22 Nov 2010) A bug () was recently discovered with the Debian and Ubuntu packages of . Debian and Ubuntu packages with build identifier "mariadb87" in the package filename are affected. Updated packages have been created. The updated build number is 90. The updated packages are being pushed out to the . The has a link to the changes made to fix the bug.

This is a . In general this means there are no known serious bugs and we believe the code is ready for general usage. For a high-level description of see the .

See the for a list of all changes included in this release.

The most recent release in the is:

| Release Notes | |

Release date: 3 Mar 2011

Get notified of new releases automatically by adding the to your favorite feed reader or by to the announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list).

MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

For a list of every change made in , see the . For a high-level description of see the page.

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

contains the following changes:

The most recent release in the is:

|Release Notes | |

Release date: 18 Aug 2011

is a . In general this means there are no known serious bugs and we believe the code is ready for general usage. A "stable" MariaDB release is equivalent to a MySQL "GA" release.

For a high-level description of see the page.

For a list of every change made in , including the various bugs that were fixed and links to detailed information on each push, see the . See previous and for changes made in previous versions of MariaDB.

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

Be notified of new releases automatically by adding the

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download | Release Notes | Changelog |Overview of 5.2

Release date: 10 Apr 2010

Release Notes

See the MariaDB versus MySQL page for a high-level overview of the differences between MariaDB and MySQL. For a description of this release see the MariaDB 5.1 overview.

This is a beta release of MariaDB. We believe it to be relatively bug-free, and want to get it out so everyone can try it. Development is ongoing, see for a list of features that are planned for future releases.

New features and changes in this version include:

patch from Percona

• This patch enables the gathering of more detailed statistics in . As part of this patch, several new tables (with corresponding new FLUSH andSHOW commands) have been added. See: for details.

Virtual columns patch (Contribution)

• We've added VIRTUAL and PERSISTENT virtual columns to . See: for details.

Add a mysqlbinlog option to change the used database.

• We've added a new --rewrite-db=name option to mysqlbinlog for applying updates to a database with a different name than the original. See: for details.

Maria storage engine group commit

• Two new system variables have been added:maria_group_commit andmaria_group_commit_interval. See for details.

Backport libservices

• We've backported the to .

Fix the packaging scripts

• We updated the packaging scripts in to fix some errors.

Pluggable authentication.

• In the authentication of users is delegated to plugins. See: for details.

Additional information added to engine description, new MariaDB plugin declaration

• We've added two new columns to the .

• For plugin authors: As part of this change, the MariaDB plugin declaration now differs slightly from the MySQL plugin declaration (the MySQL plugin declaration is still supported for dynamically loaded plugins). See: for details.

Segmented Key Cache for MyISAM

New engine-defined options in the CREATE TABLE

• Storage engines can now allow the user to specify additional attributes per index, field, or table. The engine needs to declare what attributes it introduces. See: for more information.

The most recent release in the is:

|Release Notes | |

Release date: 12 May 2011

is a . In general this means there are no known serious bugs and we believe the code is ready for general usage. A "stable" MariaDB release is equivalent to a MySQL "GA" release.

For a high-level description of see the page.

For a list of every change made in , including the various bugs that were fixed and links to detailed information on each push, see the . For a high-level description of see the page.

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

Be notified of new releases automatically by adding the

The most recent release in the MariaDB 5.2 series is:MariaDB 5.2.14

Download |Release Notes |Changelog |Overview of 5.2

Release date: 5 Dec 2011

MariaDB 5.2.10 is a Stable release.In general this means there are no known serious bugs and we believe the code is ready for general usage. A "stable" MariaDB release is equivalent to a MySQL "GA" release.

For a detailed description of MariaDB 5.2 see the What is MariaDB 5.2 page.

Compared to MariaDB 5.2.9, MariaDB 5.2.10 is a bug-fix release.

For a list of every change made in MariaDB 5.2.10, with links to detailed information on each push, see the MariaDB 5.2.10 Changelog.

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

Be notified of new releases automatically by adding the to your favorite feed reader or by to the announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list).

MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

PAM Authentication Plugin

includes a new open source PAM authentication plugin. See the page for details on this plugin and how to use it. For this version of MariaDB the plugin is only available in the source tarball.

Includes and MySQL 5.1.60

This release of includes , which in turn includes MySQL 5.1.60.

See the for a list of changes made upstream in MySQL.

Includes XtraDB from Percona-Server-5.1.59-13

includes from Percona Server 5.1.59-13. See the for details on what is new in this version of XtraDB.

Windows Packages -- UPDATE, 6 Dec 2011

The Windows packages are now available from the primary mirror (osuosl). They will be available on all mirrors within 24 hours.

Special Note for Debian and Ubuntu Users

The Layerjet mirror was recently deactivated. If you were using the Debian or Ubuntu repositories on this mirror, you will need to update your entries to use a different mirror.

If you ever notice the mirror you are using is not responding, check the for the current list of mirrors.