MariaDB already allows developers to add new Pluggable Data Types and scalar Plugin Functions. One missing piece has been Pluggable Aggregate Functions operating on PDTs. That matters for functionality such as HyperLogLog, where an extension needs to aggregate values into a custom statistical sketch while preserving its native SQL type.
MDEV-40672 closes that architectural gap. Aggregate functions can now participate in MariaDB’s native aggregation infrastructure, including DISTINCT, window execution, prepared statements and Pluggable Data Types.
MariaDB already supports MariaDB_FUNCTION_PLUGIN, a mechanism for registering SQL functions that create regular server Item objects and can behave almost like built-in functions.
…
Overview
While validating MariaDB RSS stability under stored procedure workloads, I ran into unexpected memory growth. The goal was straightforward: confirm that MariaDB was not leaking memory when running TPROC-C stored procedure workloads. To do this, I used HammerDB TPROC-C SP and added improved RSS monitoring so I could watch memory usage over long-duration runs.
The results were clear. MariaDB RSS stayed stable. HammerDB 5.0 kept growing, and growing.
This led to a deeper investigation into HammerDB itself, and ultimately to an update in TAF to support HammerDB 6.0 and a new RSS logging script.
…
Continue reading “MariaDB Foundation Advances TAF with HammerDB 6.0 and xt_reservoir Integration”
JSON support in MariaDB has improved significantly over the years.
We have functions to create JSON documents, extract values, modify objects, inspect arrays, compare documents, and even transform JSON into relational rows using JSON_TABLE().
But sometimes, a very small piece of syntax can make a surprisingly large difference.
With MariaDB 13.1, we can finally write:
document->’$.customer.name’
and:
document->>’$.customer.name’
Yes, the JSON arrow operators have arrived in MariaDB!!
And MariaDB 13.1 also improves JSON_TABLE() with support for formatted JSON columns, allowing complete JSON objects and arrays to be returned without converting them into scalar SQL values.
…
Continue reading “MariaDB 13.1 Feature in Focus: JSON Operators and JSON_TABLE Improvements”
Auree is building a cloud-independent platform for deploying and operating highly available open source databases, including MariaDB, inside customers’ own cloud accounts. Its Bring Your Own Cloud model allows organisations to choose their cloud provider, region, infrastructure size, and security environment while Auree automates database provisioning, monitoring, backups, clustering, and failover.
This approach addresses a growing concern among organisations adopting managed database services: how to gain the operational benefits of the cloud without surrendering control of their data, infrastructure, or future deployment choices.
Auree’s platform uses a lightweight 2+1 architecture, consisting of two database nodes and a smaller witness node responsible for quorum.
…
Continue reading “MariaDB Foundation is pleased to welcome Auree as a Silver Sponsor.”
Be it known: MariaDB Server now has a clearer, publicly documented governance framework covering technical roles, subsystem ownership, decision-making, response expectations and continuity.
Open source begins with access to the code. Yet for infrastructure expected to remain dependable for many years, openness must also extend to how responsibility is assigned, how decisions are made, and what happens when people disagree or move on.
The framework formalises much of how the project has long worked, while making its responsibilities, decision paths and commitments clearer and easier to inspect.
The central principle is simple: authority should be visible, earned and connected to responsibility.
…
Continue reading “Hear Ye, Hear Ye: A Guide to MariaDB’s Governance Model”
We are pleased to welcome Wirekite as a new Silver Sponsor of MariaDB Foundation.
Wirekite is an enterprise data movement platform focused on high-performance extract, load, migration, and replication workflows. Its technology helps organisations move data across database systems and keep data fresh between operational systems, analytics platforms, and application environments.
For MariaDB users, this matters because data movement is often part of real-world database adoption. Organisations do not choose databases in isolation. They need practical ways to migrate, replicate, modernise, integrate, and operate across mixed environments. Wirekite supports MariaDB as both a source and target database, helping make MariaDB easier to include in broader data architectures.
…
Continue reading “Wirekite becomes Silver Sponsor of MariaDB Foundation”
When we talk about open source contributions, we often focus immediately on the code.
How many lines were changed?
What feature was added?
What do the benchmarks show?
But sometimes, the most interesting part is not the feature itself. It is the journey that transforms a production problem inside one company into an improvement available to an entire community.
This is exactly what happened with Headout, Arcadiy Ivanov (Karellen, Inc), and MariaDB Server.
The technical result is support for BLOB values in in-memory internal temporary tables.
…
Continue reading “From a Production Problem to MariaDB: Headout’s Open-Source Contribution Journey”
Sometimes a change happens progressively, one compatibility matrix at a time, until somebody finally writes down what has already become obvious.
This time, Adobe wrote it down.
In its database compatibility guidance for Adobe Commerce, Adobe now describes MariaDB as the default and recommended database platform going forward.
This is the future direction of Adobe Commerce, and, I must admit, this is very nice to read.
Magento, Magento Open Source and Adobe Commerce
Before going further, it is useful to clarify the names, because Magento and Adobe Commerce are often used interchangeably, even though they do not refer to exactly the same product.
…
Continue reading “Adobe Commerce Chooses MariaDB as Its Default Database Platform”