MariaDB 10.8.2 RC and MariaDB 10.7.3, 10.6.7, 10.5.15, 10.4.24, 10.3.34 and 10.2.43 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.2, a release candidate in the MariaDB 10.8 series, MariaDB 10.7.3, a Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.7, MariaDB 10.5.15, MariaDB 10.4.24, MariaDB 10.3.34 and MariaDB 10.2.43, the latest stable releases in their respective series.

These primarily fix a problem in last week’s releases when manually running mariadb-upgrade. See MDEV-27789, and the release notes and changelogs for details. …

MariaDB 10.8.1 RC and MariaDB 10.7.2, 10.6.6, 10.5.14, 10.4.23, 10.3.33 and 10.2.42 now available

2022 is off to a flying start and there are seven new MariaDB Server releases to kick things off. The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.1, the first release candidate in the MariaDB 10.8 series, MariaDB 10.7.2, the first Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.6, MariaDB 10.5.14, MariaDB 10.4.23, MariaDB 10.3.33 and MariaDB 10.2.42, the latest stable releases in their respective series. …

MariaDB 10.8.0 preview releases now available

Following up on our announcement of the new release model, first used in 10.7.0, we are pleased to announce that the MariaDB Server 10.8.0 preview releases are now available.

Maturing MariaDB more quickly

One of the purposes of the new model is to get features into the hands of users more quickly, in a form which supports stability by allowing the new feature to be more easily tested, separate from other new features being developed at the same time.

Candidate features for MariaDB 10.8

The features available in the preview releases, and therefore under consideration for release in 10.8.1, are:

  1. MDEV-4989 mysqlbinlog GTID support
  2. MDEV-10654 Stored Procedures INOUT Parameters
  3. MDEV-11675 Lag free ALTER TABLE in replication
  4. MDEV-13756 Descending indexes
  5. MDEV-14425 InnoDB redo log improvements
  6. MDEV-17554 Auto create partition
  7. MDEV-26519 JSON Histograms
  8. MDEV-26713 Windows – Improved i18n support
  9. MDEV-27106 Spider Storage Engine Improvements
  10. MDEV-27265 Misc.

MariaDB 10.7.1 RC, and MariaDB 10.6.5, 10.5.13, 10.4.22, 10.3.32 and 10.2.41 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.7.1, the first release candidate in the MariaDB 10.7 series, as well as MariaDB 10.6.5, MariaDB 10.5.13, MariaDB 10.4.22, MariaDB 10.3.32 and MariaDB 10.2.41, the latest stable releases in their respective series.

See the release notes and changelogs for details.

Download MariaDB 10.7.1

Release Notes Changelog What is MariaDB 10.7?


Download MariaDB 10.6.5

Release Notes Changelog What is MariaDB 10.6?

10.7 preview feature JSON Histograms

MariaDB has had support for histograms as part of Engine Independent Table Statistics since 10.0. As part of Google Summer of Code (MDEV-21130), Michael Okoko, together with his mentor Sergey Petrunia, have implemented a new format (using JSON) for histograms that significantly improves the accuracy and flexibility of histograms. For those just interested in the feature details, you can skip to the “New format”, however if one is unfamiliar with the purpose of histograms, read on.

Why statistics are needed

Histograms are important for queries where the WHERE clause uses columns that are not indexed.

10.7 preview feature: Compression Provider Plugins

MariaDB has been using a pluggable storage engine architecture for a long time and whilst this means great flexibility in choosing and managing the right storage engines for specific use cases, it also means they are easier to develop and therefore there’s an expectation that more engines will be created.

More storage engines means the MariaDB Server itself needs to be as flexible as possible to accommodate all sorts of functionalities that storage engines may need. One area where the MariaDB Server proved to be not that welcoming was in making available all the compression libraries needed by storage engines.

10.7 preview feature: Natural sort

Natural sort order is the ordering of strings in alphabetical order, while numbers are treated as numbers. This understanding of sorting is closer to human comprehension than to a machine. You can find an example of this feature in the Windows file manager. There the files are sorted in natural order. Try to create four folders “b1”, “a11”, “a2”, “a1”.

There are several programming languages which have natural sort. In PHP it is built-in function natsort, while as an third-party module in Python it is natsort, in Perl it is Sort::Naturally and in Matlab it is sort_nat.

10.7 preview feature: UUID Data Type

Universally unique identifiers (UUIDs) have a common place in computing already. A 128-bit value with a text representational value and the prescription of a number of version types to ensure a uniqueness makes it an ideal data type.

After many years of the UUID datatype existing only as a feature request in MDEV-4958, slowly accumulating votes and watchers, we are pleased to announce a preview of the UUID data type. Like the INET6 data type, this uses the datatype plugin API from MariaDB 10.5.

What does the UUID data type look like?