MariaDB Xpand

Overview

MariaDB Xpand provides ACID-compliant distributed SQL, high availability, fault tolerance, write scaling, and horizontal scale-out for transactional workloads. MariaDB Xpand is a component of MariaDB Enterprise.

Benefits

  • ACID-compliant distributed SQL for modern web applications with massive workloads that require high performance and strong consistency, such as online transactional processing (OLTP)

  • Elastic scale-out and scale-in to adapt for changes in workload or capacity requirements

  • High Availability (HA) and fault tolerance

  • Sophisticated data distribution partitions Xpand horizontally into slices, and distributes multiple copies of the slices among nodes as replicas which are managed automatically for data protection and load rebalancing

  • Read and write scaling, with a shared-nothing architecture

  • Parallel query evaluation for efficient execution of complex queries such as JOINs and aggregate operations

  • Columnar indexes can be used in Xpand 6:

    • Columnar indexes are best suited for queries that "scan" much or all of a table. This includes queries that perform aggregations on large amounts of data, queries that select a subset of columns from large tables, and queries that perform a full table scan of a fact table. Queries tend to match this pattern in analytical, online-analytical processing (OLAP), and data warehousing workloads.

    • With composite (multi-column) Columnar indexes, filtration is not dependent on column order. If a Columnar index is defined with COLUMNAR INDEX (a, b, c), and the query filters with WHERE b = 1 AND c = 2, the Columnar index can be used to filter the results.

  • Optimized topologies:

    • Xpand Performance topology for maximum throughput and lowest latency

    • Xpand Storage Engine topology to maximize compatibility with MariaDB Enterprise Server, gaining capabilities like Window functions, CTEs, and cross-engine JOINs

Deploy

FAQ

Topology Choice

Why would I choose Xpand Performance topology vs Xpand Storage Engine topology?

Choose the topology which most closely aligns to your business objectives.

  • Both topologies deliver ACID compliance, high availability, fault tolerance, read and write scaling, and elasticity

  • Xpand Performance topology delivers maximum throughput and lowest latency

  • Xpand Storage Engine topology maximizes compatibility with MariaDB Enterprise, enabling features like window functions, CTEs, and cross-engine JOINs

  • While we demonstrate two topologies for MariaDB Xpand, MariaDB products can be deployed in many different topologies. MariaDB products can be deployed to form other topologies, leverage advanced product capabilities, or combine the capabilities of multiple topologies.