Xpand Features

UNSTOPPABLE

Never worry about availability again. Xpand redundantly stores data allowing database operations to automatically continue in the event of a failure – without manual intervention.

Fault Tolerant

Xpand slices and stores a portion of each table redundantly on different database nodes. If a node fails, Xpand uses copies stored on surviving nodes and if needed creates new copies of data to reestablish resiliency.

Zone Awareness

Xpand may be installed on nodes in different zones. Xpand intelligently and redundantly stores data in multiple availability zones within a region, ensuring cluster operations continue in the event of a zone failure.

Multi-Site Replication

Xpand uses parallel streaming replication between regions to support global deployments. With Xpand, the entire cluster is used to achieve low replication lag compared to scale-up databases that are restricted by a primary/replica configuration.

SCALE AND ELASTICITY

Whether it’s a seasonal spike or an unexpected viral moment, the ability to dynamically adjust to meet capacity demands is important for companies of any size. Xpand is a true distributed database designed to scale and harness the full compute and network capacity of the entire cluster.

Multi-Writer

Xpand delivers massive write scalability. Data is sliced and distributed across all nodes in a cluster. Every node in the cluster can perform reads and writes.

Dynamic Elasticity

As capacity needs change, simply add or remove nodes. Xpand will redistribute data and workload without any application or administrative changes.

Distribution Aware Optimizer

Xpand breaks queries into independent chunks, pushes processing and aggregation down to data supplying nodes, and uses massive concurrency to achieve fast performance.

Scalable Parallel Replication

As the Xpand cluster capacity grows, parallel replication capacity grows with it.

Scalable Backup and Restore

Xpand achieves fast backup by using the entire cluster to back up and restore data in parallel.

Xpand Distributed SQL vs. Standard Relational Database

EFFICIENCY

Xpand is engineered to balance resources across all nodes in the cluster, utilizing resources as efficiently as possible and continuously optimizing itself to maintain peak performance.

Automatic Data Distribution

When new database nodes are added, Xpand automatically moves some of the data to them in order to maintain an even distribution of data.

Automated Data Re-Slicing

When the database grows and some slices are too big, Xpand will transparently slide and redistribute the node to maintain an even distribution of data.

Workload Rebalancing

If Xpand detects instances doing more work than the others, it will automatically move the workload so all instances are doing an even amount of work.

Adaptive Load Balancing

Automatically routes queries to the servers with the most resources available.

GLOBAL DEPLOYMENT

Global applications require fast database response times. This requires bringing data from a central location to the edge, closer to application servers and end users. Xpand enables near-instantaneous access to data across the globe through Xpand’s parallel streaming replication. While scale-up databases are limited by compute and network capacity for the primary server, Xpand harnesses the power and abundant network capacity of Xpand clusters, bringing low lag replication across large distances for the most demanding write workloads.

Global deployment with MariaDB Xpand

In an active-active cross-continent benchmark between two 9-node clusters,
Xpand sustained less than a 2-second replication lag while delivering over 24K transactions per second.

HYBRID WORKLOADS

Xpand is the only distributed SQL database with a columnar index. This feature enables applications using range queries and aggregations to perform operational analytics on transactional data efficiently and with speeds up to 50x faster.

 

Row and columnar-oriented storage

divider-navy

Get Started with Xpand

divider-navy

Additional Resources

White Paper
White Paper
Distributed SQL for Dummies
White Paper
Distributed SQL for Dummies
Learn More
Datasheet
Datasheet
MariaDB Xpand: Conceptos de SQL distribuido
Datasheet
MariaDB Xpand: Conceptos de SQL distribuido
Learn More
Datasheet
Datasheet
MariaDB Xpand: A Database for the Digital Era
Datasheet
MariaDB Xpand: A Database for the Digital Era
Learn More