Chris standing up holding his daughter Elva

MariaDB Exa

DATASHEET

01
Introduction

Advanced, High-Speed, Multi-Node Analytics

MariaDB, in partnership with Exasol, provides a near real-time analytics platform capable of handling high concurrency across large data volumes. MariaDB Exa leverages Exasol’s massively parallel processing (MPP) and in-memory engine to eliminate data latency and complex extract, transform, load (ETL), unlocking near real-time insights for your most demanding analytics and AI/ML workloads.

Exasol

Exasol Analytics Engine is a high-performance, in-memory engine designed for near real-time analytics, data warehousing and AI/ML workloads. It leverages MPP architecture to execute complex queries with unmatched speed and price/performance ratio. Exasol Analytics Engine transforms complex industry data into instant insights so you can act faster, control costs and confidently navigate challenges.

02
MariaDB Exa

As an optional component of MariaDB Enterprise Platform, MariaDB Exa erases the barrier between live operational data and high-speed analytics. Tight integration with MariaDB Server means you do not have to wonder if your analytical queries are running against the most current data. Exa provides near real-time access to your essential data.

Leverage MariaDB Exa for massively parallel, in-memory processing to analyze business events as they happen in your MariaDB applications – delivering query performance that’s 10 to 1,000 times faster. Maintain complete control over your data strategy. Exa supports any deployment model, whether on premises, in the cloud or as part of a hybrid cloud strategy.

MariaDB Exa creates a seamless connection between your MariaDB transactional data and Exa’s integrated AI/ML execution, allowing you to train and run models on live information. Using Exa’s Virtual Schema framework eliminates the need for separate ETL processes and intermediate staging areas, radically simplifying your architecture and lowering TCO.

03
MariaDB Enterprise Cluster with MariaDB Exa Architecture

04
Traffic Routing with
MariaDB Exa

Write Request

MariaDB MaxScale routes all write requests to a MariaDB server. That server uses binlog replication to copy the information to all other MariaDB servers. Additionally, binlog replication provides the data to the change-data-capture (CDC) process, which sends compacted data to one of the Exasol servers. That Exasol server processes the CDC data and makes it available to all Exasol nodes. CDC is continuous, to keep your data as near real time as possible.

Read Request

The MaxScale parser first determines if the query is transactional or analytic. For a transactional read request, MaxScale routes the query to one of the MariaDB servers for processing. For an analytical query, determined by using a Window function or heavy aggregation, MaxScale initially routes the query to both a MariaDB server and an Exasol server for processing. Exasol is an MPP engine, while MariaDB processes the query on a single server. The first to respond submits the results to the user. MaxScale also stores metadata on the query format to route similar queries in the future, reducing overhead more intelligently.

High-Performance, Multi-Node Analytics

Process large workloads with leading benchmark performance on TPC-H workloads with MariaDB Exa. It supports multi-node architecture with read/write standby nodes for stability and can handle high-concurrency usage on massive data volumes. Through massively parallel processing, your queries return results 10 to 1,000 times faster than before.

Seamless Analytical Queries Cross Cluster

MariaDB Exa simplifies your deployments down to just one connection for your applications. You transparently get the best of both database solutions: MariaDB Server for speedy transaction processing and MariaDB Exa for blazing-fast complex analytics.

CDC Solution for Most Common Data Types

MariaDB Exa keeps your data in sync, enabling near real time queries for valuable insights and up-to-date reporting. This saves time by eliminating the need to build and deploy your own custom data pipelines from MariaDB into Exasol. It also removes concerns about ETL processing, which may cause unexpected errors. Your focus is on querying the data rather than wondering if the data is up to date.

05
About MariaDB

MariaDB seeks to eliminate the constraints and complexity of proprietary databases, enabling organizations to reinvest in what matters most – rapidly developing innovative, customer-facing applications. Enterprises can depend on a single complete database for all their needs, that can be deployed in minutes for transactional, analytical and hybrid use cases. Trusted by organizations such as Deutsche Bank, DBS Bank, ServiceNow and Samsung – MariaDB delivers customer value without the financial burden of legacy database providers. For more information, please visit mariadb.com.