Author: Sergei
-
MariaDB 12.1 preview available
We are pleased to announce the availability of a preview of the MariaDB 12.1 series. MariaDB 12.1 will be a rolling release.
MariaDB 12.1 introduces numerous new features, in particular
Performance improvements
Compatibility features
Miscellaneous
Download MariaDB 12.1 preview
Thanks, and enjoy MariaDB!
-
Always use the right UUID in MariaDB
The following post was written by Stefano Petrilli, who contributed UUIDv4 and UUIDv7 implementations to MariaDB. Thank you, Stefano!
The original version of the Universal Unique IDentifiers (UUID), which is now known as UUIDv1, made his first appearance in the 1980s. The most interesting guarantee that they provide is the generation of IDs that are always unique across space and time.
To comply with this promise, it uses a combination of three elements:
Plus, it sets 6 bits to a […]
-
Mission Impossible: Zero-Configuration SSL
SSL (let’s call it that, even though SSL 2.0 and SSL 3.0 were long replaced by TLS 1.0–1.3 protocols) support was implemented in MySQL in 2001, so MariaDB (born in 2009) always had it. But over more than twenty years of SSL support there was one huge problem with it. It required tedious manual configuration, so most users never bothered and accepted the fact that their queries and data were sent unprotected. Which might have been slightly risky in 2001, […]
-
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. But if you check the manual (any manual) or search the web, you will see that almost the only use case of it is converting a partition to a standalone non-partitoned table, or converting a standalone non-partitoned table into a partition.
And the usage was designed back then to be anything but […]
-
Emergency Release of MariaDB 10.5.8, 10.4.17, 10.3.27, and 10.2.36 is now available
Why do we release MariaDB again only a week after the 10.5.7, 10.4.16, etc? What’s the emergency?
-
Authentication in MariaDB 10.4 — Understanding the Changes
MariaDB Server 10.4 came with a whole lot of Security related changes. Some of them are merely optimizations (like MDEV-15649), some improve existing features to be more robust (MDEV-15473, MDEV-7598) or convenient (MDEV-12835, MDEV-16266). Some are MySQL compatibility features, requested by our users (MDEV-7597, MDEV-13095).
But the first thing any MariaDB Server user, whether an experienced veteran or a newbie, does — before even issuing the first SQL statement — is logging in. Authenticating to the database server. And 10.4 […]
-
Duel: gdb vs. linked lists, trees, and hash tables
My first encounter with the gdb command duel was on some old IRIX about 15 years ago. I immediately loved how convenient it was for displaying various data structures during MySQL debugging, and I wished Linux had something similar. Later I found out that Duel was not something IRIX specific, but a public domain patch for gdb 4.6 written in ’93 by Michael Golan. Unfortunately, it never got into gdb (for licensing reasons, so I’ve heard). Now the gdb 8 […]