Back in July, I wrote about a native ADBC driver for MariaDB. That was something I’d been working on to use MariaDB Server with DuckDB via Apache Arrow Database Connectivity (ADBC). The driver was working and I was already able…
Different projects. Shared roots. One M-Ecosystem. We are pleased to announce the Call for Participation (CfP) for the M-Ecosystem Devroom at FOSDEM 2027, taking place on Sunday, January 31, 2027, in Brussels, Belgium. Following the tradition of the MariaDB, MySQL…
One ecosystem, many projects, shared challenges. Join us in Brussels on Sunday, January 31, 2027, for the M-Ecosystem Devroom at FOSDEM! Building on the tradition of the MariaDB, MySQL & Friends Devroom, this new chapter expands its scope and ambition,…
A few days ago, I came across an interesting post by Hussain Patel on LinkedIn about HNSW index implementation differences in every vector databases. I was very surprised not to see MariaDB in the list. One day later, AskDBA (Alkin…
In the first part of this article, I explained how MariaDB Server can authenticate users using caching_sha2_password, and more importantly, how it is possible to migrate an existing MySQL user to MariaDB while keeping the same password. The solution works,…
As a DBA, comparing Database Server versions is an important part of preparing an upgrade. You need to know which server options were added or removed, which defaults changed, and what else is different between the versions you are running…
As a DBA, disk space has always worried me. In fact, the biggest problem for a MySQL/MariaDB DBA is the large, fragmented InnoDB Tablespaces. It was even more problematic when a single tablespace handled everything. But even with a tablespace…
MariaDB 13.1 introduces the long-awaited `->` and `->>` JSON operators, together with `FORMAT JSON` support in `JSON_TABLE()`. Discover how these improvements simplify JSON queries, preserve nested objects and arrays, and improve compatibility with MySQL applications.
When we talk about extending a database server, we usually think about features that could benefit a very large number of users. A new authentication mechanism, a storage engine, an audit plugin, a new generic data type such as UUID…
Names are important. They help us identify people, projects, products, pets, database servers, and occasionally the correct bug tracker. This may sound obvious, but the database world has spent more than fifteen years proving that it is not. MySQL and…
Reversing Transactions Directly from the Binary Log Some ideas never completely disappear. They remain somewhere in your brain, waiting for the right opportunity—or the right API—to come back. For me, recovering rows from the binary log is one of those…
Have you ever modified a MariaDB configuration file, restarted the service, and immediately regretted it? You wanted to change: but accidentally wrote: One missing letter. That is enough to turn a perfectly healthy database server into a service that refuses…