MariaDB Platform for Analytics

Modern analytics made easy

MariaDB Platform can be deployed as a columnar database for modern, on-demand analytics, using distributed storage and massively parallel processing to execute interactive, ad hoc queries on hundreds of billions of rows with standard SQL – but without the need to create indexes first. Further, MariaDB Platform scales out on commodity hardware, on premises or in the cloud, removing the need for expensive servers or data warehouse appliances.

What’s New

Regression functions

Data scientists get out-of-the-box statistical functions for linear regression, correlation and covarience – and multi-parameter, user-defined functions for implementing other algorithms.

Kafka connector

Data analysts get near real-time data with an Apache Kafka connector for ingesting streaming data, bypassing the SQL layer entirely and writing directly to storage for higher throughput.

Spark connector

Data scientists get to persist machine learning results with an Apache Spark connector, making them available for further ad hoc analysis using a columnar database and standard SQL.

Background Divider Element

Why now

Business today is undeniably data-centric. Near-real-time insights from MariaDB’s efficient, flexible and infinitely scalable analytics give you a competitive advantage.

  • Store a lot more data and analyze it faster
    Store a lot more data and analyze it faster

    MariaDB Platform lets you scale analytic workloads when they’ve outgrown traditional databases like Oracle Database and MySQL.

  • Run interactive, ad hoc queries on demand
    Run interactive, ad hoc queries on demand

    MariaDB Platform allows you to analyze data in unlimited, unforeseen ways because it doesn’t need indexes to improve query performance.

    Learn More
  • Move faster with access to near-real-time data
    Move faster with access to near-real-time data

    MariaDB Platform can import streaming data from Apache Kafka so you’re always analyzing the latest data, not some week-old data.

Background Divider Element

Components

MariaDB Server

The only open source database with Oracle Database compatibility (i.e., PL/SQL), temporal tables and transparent data encryption.

MariaDB ColumnStore

A storage engine optimized for analytical workloads – the data is distributed for scalability and stored by column for performance.

MariaDB MaxScale

The world’s most advanced database proxy: intelligent routing, automatic failover, dynamic data masking and a powerful database firewall.

Kafka connector

A streaming data adapter for automatically and continuously consuming Apache Kafka messages and writing them directly to storage.

Spark connector

A bulk data adapter for publishing machine learning results from Apache Spark for ad hoc, interactive analysis with standard SQL.

App data adapters

C, Java and Python bulk data adapters for writing data directly to storage (bypassing the SQL layer) from remote applications, services and scripts.

Architecture

MariaDB Server and MaxScale Diagram

Modern analytics

  • Scalability and performance
    Scalability and performance

    MariaDB Platform scales out to billions of rows and uses massively parallel processing to analyze the data in a matter of seconds.

  • Columnar storage and compression
    Columnar storage and compression

    MariaDB Platform can store data by column to provide greater compression, schema flexibility and query performance.

  • Kafka and Spark connectors
    Kafka and Spark connectors

    MariaDB Platform has Kafka and Spark connectors for ingesting streaming data and publishing machine learning results.

  • Standard ANSI SQL with no limitations
    Standard ANSI SQL with no limitations

    MariaDB Platform, unlike Hadoop and NoSQL databases, supports analytics on hundreds of terabytes of data with standard SQL.

  • Direct, on-demand imports from the source
    Direct, on-demand imports from the source

    MariaDB Platform includes connectors for importing bulk data from C, Java and Python applications, services and scripts.

  • Open source on commodity hardware
    Open source on commodity hardware

    MariaDB Platform is enterprise open source, runs on premises or in the cloud, on servers or containers, and with HDDs or SSDs.

Helpful resources

Background Divider Element

Services and support

In addition to world-class, 24×7 technical support, MariaDB subscriptions include consultative support to provide customers with recommendations and advice based on decades of experience. If that’s enough, a dedicated team of remote DBAs, enterprise architects and migration managers is available to ensure customers succeed – whether it’s migrating from a legacy data warehouse or integrating with Apache Spark, Apache Kafka and Apache Hadoop.