MariaDB Enterprise Server

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

MariaDB Enterprise Server is a component of MariaDB Platform.

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:

Security

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

  • Encryption, for data-at-rest and data-in-transit

  • Authentication, authorization, logging

  • Audit plugin for activity tracking

  • 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

  • Temporal Data Tables, including system-versioned, application-time period, and bitemporal

  • Common Table Expressions (CTEs) and Window Functions

  • GIS data types and functions

Procedural Languages

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

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

What's New in MariaDB Enterprise Server 10.4?

MariaDB Enterprise Server 10.4 introduces the following new features:

Enterprise Lifecycle

MariaDB Enterprise Server uses an Enterprise Lifecycle that provides optimized builds, predictable release behavior, and vendor support.

InnoDB Instant ALTER

Instant ALTER enables reliable and predictable schema change behavior.

Optimizer Trace

Optimizer Trace collects trace data to aid query optimization and diagnosis of query execution issues.

Temporal Data

Temporal Data Table support has been expanded from System-Versioned Tables to also include Application-Time Period and Bitemporal tables.

Enterprise Audit Plugin

MariaDB Enterprise Audit provides support for auditing resource access to MariaDB Enterprise Server.

Enterprise Backup

MariaDB Enterprise Backup enables non-blocking backups of MariaDB Enterprise Server.

Data-at-Rest Encryption

With data-at-rest encryption, data is encrypted before writing to disk, and decrypted when read from disk. MariaDB Enterprise Server extends data-at-rest encryption support to include:

  • Encryption of Spatial indexes

  • Key rotation when encrypting the InnoDB Redo Log

  • Encryption of MariaDB Enterprise Cluster's write-set cache (GCache)

MariaDB Enterprise Cluster

MariaDB Enterprise Server includes support for MariaDB Enterprise Cluster, which incorporates Galera Cluster 4. New features include:

  • Parallel replication and improved performance when blocks of grouped transactions can be committed without conflict.

  • The Streaming replication, to eliminate transaction limitations by fragmenting huge transactions for replication.

  • Rolling upgrades to permit a smooth transition of MariaDB Cluster deployments to Galera 4 functionality by operating as a Galera 3-compatible node until all nodes are Galera 4-compatible.

Data Reliability and SQL Functionality

MariaDB Enterprise Server includes changes to improve data reliability and SQL functionality:

  • System tables use the Aria storage engine, making them crash-safe.

  • UNIQUE index support for the BLOB data type.

  • JSON data type validation.

  • Parentheses in UNION, INTERSECT, and EXCEPT operations to control order of execution.

Enhanced Credential Management

MariaDB Enterprise Server features security improvements, including:

  • Ability to reload SSL certificates without server restart.

  • SET PASSWORD option to specify authentication plugins.

  • Improved support for authentication plugins, including the ability to set multiple authentication plugins on individual users. Also supported is fallback on internal methods, such as password authentication.

  • ALTER USER option for account locking, to enable MariaDB Enterprise Server to reject all new connections for an account.

  • Account blocking based on number of failed login attempts.

  • Ability to set password expiration dates.

  • Logging of access when passwords are ignored, e.g., for passwordless authentication by UNIX socket.

What's New in MariaDB Enterprise Server 10.3?

MariaDB Enterprise Server 10.3 introduces the following new features:

Enterprise Lifecycle

MariaDB Enterprise Server uses an Enterprise Lifecycle which provides optimized builds, predictable release behavior, and vendor support.

Optimizer Trace

Optimizer Trace collects trace data to aid query optimization and diagnosis of query execution issues.

Enterprise Backup

MariaDB Enterprise Backup enables non-blocking backups of MariaDB Enterprise Server.

What's New in MariaDB Enterprise Server 10.2?

MariaDB Enterprise Server 10.2 introduces the following new features:

Enterprise Lifecycle

MariaDB Enterprise Server uses an Enterprise Lifecycle which provides optimized builds, predictable release behavior, and vendor support.

Enterprise Backup

MariaDB Enterprise Backup enables non-blocking backups of MariaDB Enterprise Server.