MariaDB Server: The open source relational database

ServerFest Two Weeks Later

Update your calendars: The MariaDB ServerFest has moved to be two weeks later, Tue-Wed 5.-6. October 2021. We hope the new dates fit your calendar! Technical reasons The postponement is due to what is usually called "technical reasons", which is an expression intended to obscure any underlying facts. In our case, we don't need to obscure, but can openly disclose the reasoning and point to a few late speaker submissions and one early newborn. YAMB = Yet Another MariaDB Baby The early newborn is my son Felix. Before we knew his gender, he went under the description "October Revolution". He decided to break out already in September, but hey, the original October Revolution happened in November 1917, so why worry about a mismatching month.…

10.7.0 Comes As Preview Releases

Now is the time to try out the new candidate features of MariaDB Server 10.7, the next release series of MariaDB! This blog describes how the new preview releases work, and where we need your help as a MariaDB user. The challenge: Making MariaDB mature quicker Remember the challenges and visions I described two weeks ago? To address them we launch an experiment with several parallel preview releases of MariaDB Server 10.7 features. This should solve two challenges mentioned in the blog: giving users early access to new functionality and making releases mature more rapidly through intensive internal testing.…

10.7.0 Comes As Preview Releases

Now is the time to try out the new candidate features of MariaDB Server 10.7, the next release series of MariaDB! This blog describes how the new preview releases work, and where we need your help as a MariaDB user. …

ServerFest Two Weeks Later

Update your calendars: The MariaDB ServerFest has moved to be two weeks later, Tue-Wed 5.-6. October 2021. We hope the new dates fit your calendar!
Technical reasons
The postponement is due to what is usually called “technical reasons”, which is an expression intended to obscure any underlying facts. …

10.7 preview feature: CONVERT PARTITION

If you are using table partitioning, you have likely heard of the ALTER TABLE … EXCHANGE PARTITION … WITH TABLE … command. It existed in MariaDB since forever. …

10.7 preview feature: Python-like string formatting

Sometimes there is a need to combine data from different columns into one string. For example,
This doesn’t look too bad, but can quickly get out of hand, if you need to do something more complex than that. …

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. …

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. …

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. …