MariaDB Platform¶
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 as components:
MariaDB Enterprise Server, a 100% Open Source modern SQL database
MariaDB ColumnStore, distributed, columnar storage for scalable analytical processing
MariaDB MaxScale, an advanced database proxy, firewall, and query router
MariaDB Connectors, lightweight, advanced connectors for high-performance data access
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 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¶
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.
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.
Columnar Data Store¶
MariaDB Platform incorporates MariaDB 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 (e.g., 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 includes a pluggable storage engine. The pluggable storage engine allows table-level switching from the general purpose InnoDB storage engine to:
MyRocks storage engine, optimized for Write-intensive workloads
Spider storage engine, optimized for sharding
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:
Data-at-rest Encryption and Data-in-transit Encryption
Advanced authentication and authorization