We are excited to announce the technical preview of MariaDB Exa on MariaDB Cloud. This release brings high-performance Hybrid Transactional and Analytical Processing (HTAP) directly into the MariaDB environment by integrating Exasol’s massively parallel processing (MPP) engine. By removing the requirement for complex ETL pipelines, MariaDB Exa enables analytics on live transactional data at up to 800x the speed of traditional configurations.
Delivering MariaDB Exa as a managed cloud service removes the operational complexity that typically gates HTAP adoption. There are no clusters to provision, no MaxScale routing to configure, and no replication topology to maintain. Provisioning is a single workflow inside MariaDB Cloud, with MaxScale automatically handling the intelligent routing between the transactional and analytical engines. This lets you validate the HTAP value proposition against real workloads in minutes rather than days, in a single managed environment that grows with you as workloads evolve.
The same extreme analytics experience is available whether you run MariaDB Exa yourself or consume it as a Cloud-managed service. Both transactional and analytical power, on-prem or in-cloud, with no architectural compromise between the two. That’s a deployment flexibility that pure cloud-only warehouses can’t match.
Traditional data pipelines create significant operational overhead. They introduce complexity, increase cloud egress costs, and create data drift. MariaDB Exa on MariaDB Cloud removes these barriers by providing a single, unified interface for both OLTP and OLAP workloads.
The core of this architecture is MariaDB MaxScale, which acts as an intelligent backend proxy for both transactional and analytical workloads. Database connection strings and application logic remain unchanged; applications point directly to MaxScale, which handles query routing transparently.
MariaDB MaxScale with Exa Architecture
MaxScale evaluates every incoming SQL statement to optimize execution:
| Operation Type | Routing Destination | Benefit |
|---|---|---|
| Write Operations | MariaDB | Ensures strict ACID compliance and data consistency. |
| Read-after-write | MariaDB | Maintains immediate data accuracy. |
| Analytical Queries | MariaDB Exa (Exasol MPP Engine) | Processes complex scans, joins, and aggregations with massive parallelism. |
In advanced routing scenarios, MaxScale dispatches queries to both engines simultaneously. It returns the fastest successful response to the client, terminates the slower process, and caches the query metadata to optimize routing paths for future executions.
To preserve data consistency without manual intervention, MariaDB Exa utilizes a native Change Data Capture (CDC) pipeline. This pipeline monitors MariaDB binary logs and immediately streams transactional changes—inserts, updates, and deletes—directly into the synchronized Exasol replica. This background process ensures analytical queries execute against current production data without impacting the transactional engine’s throughput.
MariaDB Exa is engineered for organizations that can no longer afford the delay between transactions and insights.
Organizations in high-velocity sectors like finance, e-commerce, and logistics require immediate insights to prevent revenue loss. Powered by Exasol’s MPP engine, MariaDB Exa delivers near real-time analytic insights directly from live operational data.
AI models depend on data freshness. Training and inference on outdated datasets lead to missed patterns and erroneous predictions. With MariaDB Exa, models are trained and deployed directly against live operational data. Exasol’s integrated AI/ML execution framework enables organizations to score transactions, detect anomalies, and optimize operations in real-time.
MariaDB Exa bridges the gap between transactional reliability and analytical speed. By integrating Exasol’s MPP engine into the MariaDB Cloud platform, organizations can modernize their data architecture, reduce operational complexity, and unlock real-time insights from operational data.
The MariaDB Exa Technical Preview is open to all MariaDB Cloud users running provisioned instances. Organizations can deploy a test environment today to run complex analytical queries directly against live transactional data and evaluate performance improvements firsthand.
MariaDB Exa combines MariaDB’s transactional OLTP engine with Exasol’s MPP analytical engine in a single, managed platform. This integration allows organizations to execute hybrid transactional and analytical processing (HTAP) queries without needing complex ETL pipelines, ensuring that analytical workloads run against live production data.
MariaDB MaxScale acts as an intelligent proxy that analyzes incoming SQL statements. It automatically routes transactional writes and reads to MariaDB for ACID compliance, while complex analytical queries—such as multi-way joins and aggregations—are routed to the Exasol MPP engine, all without requiring changes to application connection strings.
MariaDB Exa uses a native Change Data Capture (CDC) pipeline. This process monitors MariaDB binary logs and streams transactional changes—such as inserts, updates, and deletes—into the Exasol replica in real-time. This ensures that analytical queries execute against current data without impacting the performance of the transactional database.
Yes. MariaDB Exa allows data scientists to train and deploy AI models directly against live operational data. Because Exasol’s engine supports high-performance analytical execution, organizations can perform real-time anomaly detection, transaction scoring, and predictive modeling without waiting for nightly batch processing or relying on outdated data extracts.
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。