The open source database you’ve been waiting for
MariaDB Server is one of the most popular open source databases in the world. It is the default database in leading Linux distributions – Arch Linux, CentOS, Debian, Fedora, Manjaro, openSUSE, Red Hat Enterprise Linux and SUSE Linux Enterprise, to name a few.
Now, with the release of MariaDB Server 10.3, it is the leading open source database. It is the first open source database with built-in Oracle Database compatibility, temporal tables and queries, and multiple purpose-built storage engines supporting a variety of workloads.
It's the open source database you want with the enterprise features you need.
Featured storage engines
- InnoDB for mixed and read-intensive workloads
- MyRocks for write-intensive workloads on solid-state drives (SSDs)
- Spider for workloads requiring high scalability and concurrency
- ColumnStore for analytical workloads (available in MariaDB AX)
MariaDB Server includes MyRocks, a storage engine developed by Facebook to support workloads requiring high write performance and storage efficiency with solid-state drives (SSDs).
MariaDB Server includes Spider, a distributed storage engine to scale out reads, writes and/or storage with multiple database nodes for workloads requiring the highest scalability and/or concurrency.
MariaDB Server has built-in system-versioned tables and standard temporal query syntax for point-in-time queries, enabling data to be queried as it was at a previous point in time.
MariaDB Server supports common table expressions (CTEs), window functions, user-defined aggregate functions, built-in ordered-set aggregate functions and INTERSECT/EXCEPT.
MariaDB Server includes a comprehensive set of functions for reading, writing and validating JSON documents with SQL, or returning relational data as JSON documents and vice versa.
Oracle compatibility (NEW)
MariaDB Server supports Oracle Database syntax for prepared statements, sequences and data types as well as stored procedures and functions written in Oracle PL/SQL – packages too.
MariaDB Server features pluggable authentication, password strength validation, roles, transparent data encryption (TDE) with or without external key management, encrypted temporary files and auditing.
MariaDB Server supports check constraints, invisible columns, compressed columns and the ability to add a column in real time and on demand, without triggering a table rebuild.
MariaDB Server includes tools for logical/physical backups and point-in-time rollback (restoring data by rolling back recent transactions) and supports delayed replication.
Replication and clustering
MariaDB Server supports asynchronous replication for performance, semi-synchronous replication for durability and synchronous replication via clustering for high availability.