Total 281 words used.
MariaDB Xpand is a distributed SQL database for OLTP (systems of record) workloads. Distributed SQL is the core basis of geo-distributed workloads, meaning applications that support real time interactions across the globe simultaneously.
Xpand also has support for faster analytical queries through columnar indexing that deliver up to 50x speed for analytical and range queries. Xpand gives developers an easy way to build a small departmental application that can appropriately grow to global proportions without any changes in the application, unlike with many other database approaches. Furthermore, Xpand has the ability to have uninterrupted scale out when adding nodes.
Xpand offers high standards and varying network topologies in regard to high availability and zero data loss, even during an extreme catastrophic event. First, Xpand automatically distributes redundant copies of data. Second, it is designed based on a “shared-nothing architecture,” in which the individual nodes of the distributed system are independent and self-sufficient, eliminating the risk of catastrophic failures from single points of failure. With Xpand, a cluster can span zones, regions and even private data centers, giving organizations rich flexibility to ensure high availability. In fact, a single application can span multiple public clouds, for example, across Amazon and Google clouds.
Any Xpand database node can accept transactions that allow it to reach high levels of “concurrency” (i.e., number of simultaneous users and transactions). Traditional database architectures, for example, that use primary-replica architecture—MySQL, AWS Aurora, Google CloudSQL—are limited to a single write node. Because both reads and writes are evenly distributed across the cluster Xpand supports both read and write scale with superior performance. Additional systems can be added at any point in time to increase capacity and scale.