MariaDB Community Server

MariaDB Community Server is a 100% Open Source modern SQL database.

Reliability and Scaling

MariaDB Community Server includes features to enable cost-effective reliability for many application workloads, including:

  • ACID-compliant transactions

  • Consistent schema change behavior via Instant ALTER

High Availability

MariaDB Community Server provides high availability (HA) solutions:

Load Balancing

MariaDB Community Server provides load balancing solutions:

Pluggable Storage Engines

MariaDB Community Server includes pluggable storage engines to support different workloads, including:

Backup and Restore

MariaDB Community Server includes MariaDB Backup, which supports:

Analytics

MariaDB Community Server includes MariaDB ColumnStore which provides advanced analytical capabilities, including:

  • Columnar storage engine

  • Supports storing data in S3-compatible storage

  • MariaDB Community Server 10.5 includes MariaDB ColumnStore 1.5 as a plugin.

Security

MariaDB Community Server includes features to enable secure operation of enterprise application workloads, including:

  • Authentication, authorization, logging

  • Audit plugin for activity tracking

  • Granular global privileges, so that fewer user accounts need superuser privileges

Data-at-Rest Encryption

MariaDB Community Server supports data-at-rest encryption:

Data-in-Transit Encryption

MariaDB Community Server supports data-in-transit encryption:

Modern SQL Features

MariaDB Community Server incorporates support for classic SQL database features including CRUD operations (INSERT, SELECT, UPDATE, DELETE), Foreign Keys, JOIN, UNION, INTERSECT, and EXCEPT, with modern features including:

  • Parts of the SQL-86 (aka SQL-87), SQL-92, SQL:1999, SQL:2003, SQL:2008, SQL:2011, and SQL:2016 standards (e.g., ISO/IEC 9075-1:2016)

  • JSON for micro-services and semi-structured data

  • Common Table Expressions (CTEs) and Window Functions

  • GIS data types and functions

  • Performance Schema

  • A Data Type API for plugins

Temporal Tables

MariaDB Community Server supports Temporal Data Tables, including:

  • System-versioned tables

  • Application-time period tables

  • Bitemporal tables

Procedural Languages

  • MariaDB SQL/PSM, based on ISO standard SQL/PSM

  • MariaDB SQL/PL, a compatible subset of Oracle PL/SQL

Check out what's new in MariaDB Community Server.