MariaDB

What Is MariaDB?

In 2009, Michael "Monty" Widenius did something drastic. After Oracle acquired Sun Microsystems — and with it, MySQL — he forked the world's most popular open-source database and started over. The result was MariaDB, named after his younger daughter, built from the same codebase but governed by a promise: it would remain open-source forever.

That promise has held. Seventeen years later, MariaDB ships as the default database in Debian, Ubuntu, Red Hat Enterprise Linux, and SUSE. Over a billion devices run it through Linux distribution packages alone. The MariaDB Foundation, a non-profit based in Espoo, Finland, stewards the community server, while MariaDB Corporation Ab (also Finnish-registered) handles the commercial enterprise product and SkySQL, the company's managed cloud database service.

The corporate story has taken turns. MariaDB went public on the NYSE in 2022, struggled financially, and was taken private by K1 Investment Management — a California-based PE firm — in September 2024 for roughly $37 million. That US ownership adds a footnote for EU-sovereignty purists, but the Finnish legal entity, the GPLv2 licence, and the independent MariaDB Foundation remain intact. The code cannot be closed.

For European organisations already running MySQL, MariaDB remains the most straightforward path to an EU-headquartered, open-source relational database with genuine enterprise capabilities.

Key Features

MySQL Compatibility That Actually Works

MariaDB's headline feature is drop-in MySQL compatibility. The wire protocol, SQL syntax, and client libraries are interchangeable for the vast majority of applications. PHP, Python, Java, and Node.js applications built on MySQL can typically switch to MariaDB by changing nothing more than a connection string. This is not theoretical — WordPress, Drupal, and Joomla all run on MariaDB without modification.

Where it gets nuanced: MariaDB and MySQL have been diverging since 2012. Features like MySQL's Document Store and X Protocol have no MariaDB equivalent. Conversely, MariaDB has added capabilities MySQL lacks entirely. For established MySQL workloads, compatibility is excellent. For applications tightly coupled to MySQL 8.x-specific features, test before migrating.

Storage Engine Architecture

This is where MariaDB genuinely differentiates. Unlike PostgreSQL (single storage engine) or MySQL (effectively InnoDB-only in practice), MariaDB supports multiple storage engines that can be mixed within the same database — even within the same query via JOINs.

InnoDB handles standard transactional workloads. Aria is MariaDB's crash-safe replacement for MyISAM, optimised for read-heavy patterns. ColumnStore transforms MariaDB into a columnar analytics engine capable of handling OLAP, data warehousing, and hybrid transactional-analytical processing (HTAP) workloads — all without ETL to a separate system. Spider provides built-in sharding across multiple MariaDB instances using standard partitioning schemas. MyRocks (based on Facebook's RocksDB) offers space-efficient storage for write-heavy workloads.

No other single database product offers this range of engine choices within one unified SQL interface.

MaxScale: The Intelligent Proxy

MaxScale sits between your application and MariaDB, handling read/write splitting, load balancing, connection pooling, and automatic failover. In the 2026 Enterprise Platform release, MaxScale added a database firewall for granular query filtering — blocking specific query patterns before they reach the server. It is, however, an enterprise-only component. Community users need to build their own proxy layer with HAProxy or ProxySQL.

SkySQL Cloud Platform

SkySQL is MariaDB's managed cloud database-as-a-service, available on AWS, GCP, and Azure. For EU compliance, the critical detail is region selection: SkySQL offers deployment in Frankfurt, Paris, Belgium, and Finland, with data guaranteed to stay in the chosen region.

Pricing is consumption-based, starting at $0.45 per vCPU-hour for the Foundation tier. The Power tier adds high-availability topology and 24/7 SLA support. Annual commitments unlock 15-30% discounts. It is not cheap compared to self-managed MariaDB, but competitive with Amazon RDS and Google Cloud SQL when you factor in the EU data residency guarantees.

Galera Cluster

For high availability without MaxScale, Galera Cluster provides synchronous multi-master replication. Every node is a primary — reads and writes go to any node, with automatic conflict resolution. This is a mature, battle-tested technology used in production by major telecoms and financial institutions across Europe.

Pricing

MariaDB's pricing splits into three distinct tracks.

Community Server is free. GPLv2-licensed, unlimited deployment, all core storage engines included. There is no artificial feature gating on the community edition — ColumnStore, Spider, and Galera are all available. This is genuinely one of the most capable free databases available.

Enterprise Server subscriptions are priced per-server (on-premises) or per-vCPU (cloud), with custom quotes based on deployment size. Enterprise adds MaxScale, the audit plugin, enterprise backup tools, optimised builds, priority bug fixes, and support SLAs. Small-business tiers (under 150 employees) offer reduced pricing with 24-hour first-response SLAs. Full enterprise tiers provide 24/7 support from MariaDB's database engineers.

SkySQL uses consumption pricing: compute ($0.45-$10.14 per vCPU-hour depending on instance size and tier), storage (per GiB-month), and data transfer. Egress charges can meaningfully increase bills — a common cloud gotcha worth budgeting for. Foundation tier includes business-hours support; Power tier adds 24/7 SLAs and HA topology.

For context: running a small production workload on SkySQL in Frankfurt costs roughly $150-300/month. Self-hosting Community Server on a 4-vCPU VM costs $20-40/month in infrastructure alone, but you handle patching, backups, and failover yourself.

EU Compliance & Privacy

MariaDB Corporation Ab is registered in Espoo, Finland — an EU member state. The MariaDB Foundation, which stewards the open-source codebase, is also Finnish. This gives MariaDB a structural EU foundation that Oracle's MySQL and MongoDB lack.

The K1 Investment Management acquisition in 2024 complicates the sovereignty picture. The parent company is American, which means corporate decisions ultimately flow through a US entity. However, the GPLv2 licence is irrevocable — the open-source community server cannot be closed or restricted regardless of corporate ownership changes.

For cloud deployments, SkySQL's EU region options (Frankfurt, Paris, Belgium, Finland) keep data within EU borders. MariaDB's Data Processing Addendum follows GDPR Article 28 requirements and includes EU Standard Contractual Clauses for any cross-border data flows. The enterprise audit plugin provides the regulatory logging that compliance teams in banking and healthcare require.

Self-hosted MariaDB gives the strongest compliance posture: no data leaves your infrastructure, no sub-processors involved, full audit trail under your control.

Who It's Best For

MySQL migration projects where organisations want an EU-headquartered alternative without rewriting application code. The compatibility layer makes MariaDB the lowest-friction option.

European public-sector and regulated industries needing an open-source database with EU data residency guarantees — either self-hosted or via SkySQL's EU regions.

Analytics-heavy teams that want HTAP capabilities without maintaining separate OLTP and OLAP systems. ColumnStore handles analytical workloads alongside transactional tables in one database.

Cost-conscious organisations running the free Community Server at scale. MariaDB's GPLv2 licence means zero licensing costs regardless of deployment size, with enterprise support available as an opt-in.

The Verdict

MariaDB occupies a specific and defensible niche: the best MySQL-compatible open-source database with genuine European roots. Its storage engine diversity is unmatched, the community edition is legitimately full-featured, and SkySQL provides a credible managed cloud option with EU data residency.

The honest concerns are market share (2.4% versus PostgreSQL's 18% and MySQL's 39%), the K1 acquisition's impact on long-term direction, and the enterprise paywall around MaxScale. For new projects without MySQL compatibility requirements, PostgreSQL is the stronger default choice. But for MySQL shops, EU compliance requirements, and organisations that value storage engine flexibility, MariaDB remains a compelling European database.

Frequently Asked Questions

Is MariaDB truly open-source?

Yes. MariaDB Community Server is licensed under GPLv2, which legally prevents it from being closed-source. The MariaDB Foundation, a Finnish non-profit, independently stewards the project. Even after the K1 Investment Management acquisition, the licence is irrevocable — anyone can fork and continue development.

How compatible is MariaDB with MySQL?

Highly compatible for most workloads. The wire protocol, SQL syntax, and standard client libraries are interchangeable. Applications built on MySQL 5.x typically work without modification. MySQL 8.x-specific features like Document Store are not supported. MariaDB adds features MySQL lacks (ColumnStore, Spider, Oracle compatibility mode), creating bidirectional divergence.

Can I run MariaDB in EU data centres?

Yes, through multiple paths. Self-host on any EU infrastructure provider (Hetzner, OVHcloud, Scaleway, or major cloud EU regions). Use SkySQL with an EU region — Frankfurt, Paris, Belgium, or Finland. MariaDB's Data Processing Addendum includes GDPR-aligned terms with EU Standard Contractual Clauses.

What happened with the K1 acquisition?

K1 Investment Management, a California-based private equity firm, acquired MariaDB plc in September 2024 for approximately $37 million, taking it private from the NYSE. A new CEO (Rohit de Souza) was appointed. The Finnish legal entity (MariaDB Corporation Ab) and the independent MariaDB Foundation remain intact.

Should I choose MariaDB or PostgreSQL for a new project?

For new greenfield projects, PostgreSQL is generally the stronger choice — it has a larger ecosystem, better JSON support, more advanced query optimisation, and 18% market share. Choose MariaDB if you need MySQL compatibility, want ColumnStore HTAP capabilities, need the Spider sharding engine, or specifically require an EU-headquartered database vendor with open-source guarantees.