MariaDB Enterprise Server

Vendor Support

MariaDB Enterprise Server is an Open Source database managed through an Enterprise Lifecycle.

MariaDB Enterprise Server extends the capabilities of the widely-deployed MariaDB Community Server with enterprise-focused advanced features, optimized builds, and vendor support by MariaDB Corporation.

Reliability and Scaling

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

• ACID-compliant transactions

• Consistent schema change behavior via Instant ALTER

High Availability

MariaDB Enterprise Server provides high availability (HA) solutions:

• It supports asynchronous and semi-synchronous replication using MariaDB Replication.

• It supports certification-based replication using Galera Cluster.

• MariaDB MaxScale can provide automatic failover.

Load Balancing

MariaDB Enterprise Server provides load balancing solutions:

• MariaDB MaxScale can provide query-based load balancing.

• MariaDB MaxScale can provide connection-based load balancing.

Pluggable Storage Engines

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

• Traditional transactional workloads that require consistency and high performance can use the InnoDB storage engine

• Analytical workloads that require high performance can use the ColumnStore storage engine

• Non-transactional workloads that require high read performance can use the Aria storage engine

• Workloads that need to archive data in the cloud can use the S3 storage engine

• Workloads that require sharding can use the Spider storage engine

• Workloads that must be write-optimized can use the MyRocks storage engine

• Workloads that require high availability, elasticity and scaling can be use the Xpand storage engine.

Backup and Restore

MariaDB Enterprise Server includes MariaDB Enterprise Backup, which supports:

• Non-blocking-backups

• Full backups

• Incremental backups

• Partial backups

• Point-in-time recovery

Analytics

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

• Columnar storage engine

• Supports storing data in S3-compatible storage

• MariaDB Enterprise Server 10.5 includes MariaDB Enterprise ColumnStore 5.4 as a plugin.

• MariaDB Enterprise Server 10.4 includes MariaDB Enterprise ColumnStore 1.4 as a plugin.

Security

MariaDB Enterprise 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

• Enhanced defaults for security parameters and enabled plugins

Modern SQL Features

MariaDB Enterprise 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 Enterprise 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 Enterprise Server.