MariaDB Platform Use Cases


MariaDB Platform is the leading enterprise open source database for transaction processing – and at any scale, from replicated or clustered deployments for read scaling and high availability to distributed SQL deployments for scalability. Oracle Database compatibility simplifies migration while temporal tables and JSON functions, along with new Node.js, Python and reactive Java connectors make modern application development easier and faster than ever.

Enterprise reliability

Advanced features such as zero-interruption failover, online disaster recovery and a powerful database firewall ensure the database is always available and its data always protected.

Easy development

The database proxy abstracts away the underlying database infrastructure so developers don’t have to worry about handling failures or changes in the topology (planned or not).

Modern SQL

JSON functions, temporal tables, window functions, common table expressions (CTEs) and user-defined aggregate functions are examples of what modern SQL developers can leverage.


MariaDB Platform can be deployed as a data warehouse or analytics database using columnar storage and massively parallel processing (MPP) to perform interactive, ad hoc queries on hundreds of billions of rows without creating indexes – and with standard SQL (including joins). Further, MariaDB Platform implements a cloud-native storage architecture, and can optionally use Amazon S3 compatible object storage to lower costs and take advantage of unlimited capacity.

  • Ad hoc analytics
    Ad hoc analytics

    Analyze massive amounts of data in new, unforeseen ways without having to create an index for every potential query.

  • Real-time visualization
    Real-time visualization

    Create interactive data visualizations and customizable or dynamic reports for real-time exploration of massive datasets.

  • Data marts for Hadoop
    Data marts for Hadoop

    Import data from Hadoop data lakes to create fresh data marts on a regular basis for iterative analysis using standard BI/reporting tools.

Smart transactions

MariaDB Platform supports smart transactions (i.e., hybrid transactional/analytical processing or HTAP) by combining row storage optimized for fast transactions with columnar storage optimized for fast analytics. With smart transactions, developers can enrich web and mobile applications with real-time analytics and historical data to create more insightful customer experiences driven by compelling opportunities – and for SaaS customers, to deliver self-service analytics.

  • Self-service analytics
    Self-service analytics

    SaaS providers can now deliver self-service analytics to customers so they can analyze the data generated by the service.

  • Access to historical data
    Access to historical data

    Provide customers (and app developers) with access to historical data that would otherwise be offloaded to a separate data warehouse.

  • Real-time insight
    Real-time insight

    Provide customers with current and relevant insight using the latest data rather than waiting for batch updates from offline analytics jobs.

When deployed for smart transactions, MariaDB Platform uses replicated and/or distributed row tables for transactions and distributed columnar tables for analytics, and can optionally replicate data from some or all row tables to columnar tables.