MariaDB AX

Modern analytics made easy

MariaDB AX is a columnar database for modern, on-demand analytics, using distributed storage and massively parallel processing (MPP) to execute interactive, ad hoc queries on 100s of terabytes of near-real-time data, with standard SQL and without creating indexes (ever). That’s not all. MariaDB AX scales on commodity hardware, on premises or in the cloud, eliminating the need to spend budget on proprietary data warehouses and appliances.

What’s New

Kafka connector

Data analysts always have access to near-real-time data when it’s streamed from Apache Kafka to MariaDB AX, automatically and continuously – bypassing the SQL layer for faster data ingestion.

Spark connector

Data scientists can publish machine learning results from Spark to MariaDB AX, on demand, so they are available for ad hoc, interactive analysis without delay, and with standard SQL.

Data adapters

Developers can build applications, services and scripts to import data into MariaDB AX as soon as it arrives, eliminating the need to transfer CSV files and wait for the next scheduled ETL job.

Background Divider Element

Why now

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

    MariaDB AX lets you scale analytic workloads when they outgrow what a traditional database like Oracle Database or MySQL is capable of.

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

    MariaDB AX allows you to analyze data in unforeseen ways without having to create query-optimized schemas and indexes.

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

    MariaDB AX can import streaming data from Apache Kafka and MariaDB TX so you’re always analyzing current data, not 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 worlds’ 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

Modern analytics

  • Scalability and performance
    Scalability and performance

    MariaDB AX scales out to 100s of 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 AX stores data by column rather than row to provide greater compression, schema flexibility and performance.

  • Kafka and Spark connectors
    Kafka and Spark connectors

    MariaDB AX has Apache 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 AX, unlike Hadoop and NoSQL databases, supports standard SQL, including JOINs and user-defined aggregate functions.

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

    MariaDB AX includes bulk data adapters for direct, high-throughput imports from C, Java and Python apps, services and scripts.

  • Open source on commodity hardware
    Open source on commodity hardware

    MariaDB AX is an enterprise open source database, and runs on bare metal, virtual machines or containers, SSDs or HDDs.

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.