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:
ACID-compliant transactions
High Availability (HA) through Replication or Clustering
Pluggable storage engine with support for sharded and write-optimized data storage
Consistent schema change behavior via Instant ALTER
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.