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.
Latest Software Releases
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.
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
Resources for MariaDB Xpand
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.