MariaDB Enterprise Server¶
MariaDB Enterprise Server is a 100% Open Source modern SQL database.
MariaDB Enterprise Server is a component of MariaDB Platform.
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:
Consistent schema change behavior via Instant ALTER
MariaDB Enterprise Server provides high availability (HA) solutions:
MariaDB Enterprise Server provides load balancing solutions:
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 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:
MariaDB Enterprise Server includes MariaDB ColumnStore which provides advanced analytical capabilities, including:
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
MariaDB Enterprise Server supports data-at-rest encryption:
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
A Data Type API for plugins
MariaDB Enterprise Server supports Temporal Data Tables, including:
Application-time period tables