MariaDB Platform
Topics on This Page:
MariaDB Platform provides a comprehensive data platform for the development of modern SQL applications.
MariaDB Platform has the ability to run at small scale for development environments and global scale for production environments.
MariaDB Platform allows customers to meet regulatory requirements for encryption, operating requirements for resiliency and scaling, and challenges from complex workloads using a single stack.
How to Obtain MariaDB Platform
MariaDB Platform is available to subscription customers from MariaDB Corporation. If you are not already a subscription customer, contact us.
Components of MariaDB Platform
MariaDB Platform includes:
Component |
Description |
---|---|
100% Open Source modern SQL database with enterprise-grade enhancements |
|
Distributed, columnar storage engine for scalable analytical processing |
|
Distributed SQL, high availability, and fault tolerance for scale-out transactional workloads |
|
Advanced database proxy, firewall, and query router |
|
Lightweight, advanced connectors for high-performance data access |
Additionally, MariaDB SkySQL provides expert-maintained cloud infrastructure from MariaDB.
MariaDB Platform Use Cases
Use cases of MariaDB Platform include:
Traditional SQL database applications which require ACID-compliant transactions, High Availability (HA), load balancing, and backups.
Pluggable storage engines for workload optimization, including options for general transactional workloads (OLTP), write-intensive, read-intensive, and sharding
Scale-out of capacity to meet the needs of modern enterprise applications, including the use of replication or clustering technology, sharding or distributed SQL or write-optimization, columnar data storage for analytical workloads (OLAP), or Hybrid Transactional-Analytical Processing (HTAP).
Deployment in multi-location, cloud or cloud-hybrid, and containerized environments.
MariaDB Corporation provides commercial support and services for MariaDB Platform.
Key Features
Enterprise Lifecycle
MariaDB Enterprise Server is an Open Source database managed through an Enterprise Lifecycle that provides optimized builds, predictable release behavior, and vendor support.
ACID-Compliant SQL RDBMS
MariaDB Platform incorporates MariaDB Enterprise Server, a relational database management system (RDBMS) supporting ACID-compliant transactions, Instant ALTER for reliable and predictable schema change behavior, and non-blocking backups.
Columnar Data Store
MariaDB Platform incorporates MariaDB Enterprise ColumnStore, a columnar data store for analytical processing use cases.
Classic and Modern SQL Features
MariaDB Platform includes support for classic SQL database features including CRUD operations (INSERT, SELECT, UPDATE, DELETE), foreign keys, JOIN, UNION, INTERSECT, and EXCEPT.
MariaDB Platform includes support for modern SQL database features including:
System-Versioned, Application-Time Period, and Bitemporal temporal data tables
Common Table Expressions (CTE) and window functions
JSON for microservices and semi-structured data
GIS (Geographic Information Systems, or geospatial) functions and data types
Parts of the SQL-86 (aka SQL-87), SQL-92, SQL:1999, SQL:2003, SQL:2008, SQL:2011, and SQL:2016 standards (for example, ISO/IEC 9075-1:2016).
MariaDB SQL/PSM, based on ISO standard SQL/PSM
Support for Hybrid Transactional-Analytical Processing (HTAP)
Oracle Compatibility
MariaDB Enterprise Server includes MariaDB SQL/PL, a compatible subset of Oracle PL/SQL.
HA, Load Balancing, Failover
MariaDB Platform incorporates MariaDB MaxScale for load balancing and for advanced traffic routing such as read/write splitting.
MariaDB Platform includes replication and clustering for High Availability (HA), and MaxScale for automatic failover.
Storage Optimization
MariaDB Enterprise Server, a part of MariaDB Platform, includes pluggable storage engines to support workloads that previously required a variety of specialized databases.
In MariaDB Enterprise Server, the storage engine can be set on a per-table basis, and queries can join across multiple storage engines. Organizations can now depend on a single complete database for all their needs, whether on commodity hardware, MariaDB SkySQL DBaaS, or their cloud of choice.
Storage engines available for MariaDB Enterprise Server are:
InnoDB the default row-based transactional storage engine optimized for mixed read-write workloads
ColumnStore distributed columnar storage engine for scalable analytical processing
MariaDB Xpand distributed SQL storage engine for scale-out transactional workloads
Aria storage engine with auto recovery for read-intensive workloads
S3 storage engine for read-only queries to tables archived on S3-compatible storage
MyISAM storage engine optimized for reads
MyRocks storage engine for write-intensive workloads
Spider storage engine optimized for sharding based on table partitioning
Application Connectors
MariaDB Platform incorporates MariaDB Connectors, enabling high-performance data access by enterprise applications.
GRC and Infosec
MariaDB Platform includes features to aid the enterprise in meeting its governance, risk management, compliance (GRC), and information security (infosec) requirements. GRC and infosec features include:
Advanced authentication and authorization