MariaDB Enterprise Server
Topics on This Page:
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, predictable release behavior, 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 with auto recovery for read-intensive workloads 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 based on table partitioning 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:
Analytics
MariaDB Enterprise Server includes MariaDB Enterprise ColumnStore which provides advanced analytical capabilities, including:
Columnar storage engine
Supports storing data in S3-compatible storage
Starting with MariaDB Enterprise Server 10.4 MariaDB Enterprise ColumnStore is included 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
Data-at-Rest Encryption
MariaDB Enterprise Server supports data-at-rest encryption:
Data-in-Transit Encryption
MariaDB Enterprise Server supports data-in-transit encryption:
Supports TLS 1.3 on recent operating systems
Insecure SSL/TLS protocol versions disabled by default
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.