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 ColumnStore which provides advanced analytical capabilities, including:

• Columnar storage engine

• Supports storing data in S3-compatible storage

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

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