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.
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.
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.
Get Started with Xpand
Additional Resources
White Paper
Distributed SQL for Dummies
Distributed SQL for Dummies
Learn More
Datasheet
MariaDB Xpand: Conceptos de SQL distribuido
MariaDB Xpand: Conceptos de SQL distribuido
Learn More
Datasheet
MariaDB Xpand: A Database for the Digital Era
