MariaDB radically improves the distributed SQL product Xpand
Xpand is getting smarter and going global
REDWOOD CITY, Calif., March 10, 2022–(BUSINESS WIRE)–MariaDB® society today announced the release of Xpand 6 with important new features, all with the goal of maximizing performance. With rapid operational analytics, Xpand now has the intelligence to eliminate the need and inconsistencies of loading data into operational data warehouses. Faster parallel replication of data across regions around the world puts global deployments within reach.
As businesses around the world face unpredictable demand and change, they need a database that handles surprise increases in transactions and more diverse workloads while maintaining tight consistency and availability. Datas. MariaDB Xpand is a fully distributed SQL database with a no-share architecture. Unlike AWS Aurora’s storage replication or Postgres’ read replication, Xpand is true multi-writer, any node can be written to and adds scale for reads and writes.
Columnar data models are popular for ad hoc analysis and perform well on large amounts of data. Xpand is the first modern distributed SQL database to support this powerful feature for online transaction processing. Xpand uses columnar indexes for real-time operational analytics directly on transactional data, without losing consistency or missing the latest transactions.
The new columnar feature allows businesses to run ad hoc queries in Xpand with speeds up to 50x faster. The best performance is guaranteed because the fully cost-based optimizer will determine the fastest path, columnar or not. Applications immediately benefit from the new functionality without any changes after enabling columnar indexes.
Developers can take advantage of this new feature to deliver smarter apps, better user experiences, and personal analytics giving their app users the latest status and information about any data changes that may affect them.
With parallel replication, Xpand implements the equivalent of a multi-lane highway for asynchronous replication of geolocation data. Data replication is performed independently by each node in the cluster, increasing throughput with lower latency. Xpand provides transactional consistency by maintaining the order of transactions during replication. Powered by Xpand 6, customers can deploy their global applications across all regions and cloud providers to survive any hyperscaler outage.
“With these key new Xpand features, developers can expand their use of analytics in applications without having to worry about performance, while supporting capacity effortlessly for database administrators,” said Robbie Mihalyi, senior vice president of engineering at MariaDB Corporation. “Parallel replication capabilities have been shaped by our customers and their business needs, giving them maximum data transfer speeds with minimum latency and control over their data streams.”
Xpand 6.0 is now GA, start your trial today at https://mariadb.com/downloads/community/xpand/ or for the easiest and fastest way to start using Xpand in the cloud, visit at https://mariadb.com/view from the sky.
To follow @mariadb on Twitter
Read the MariaDB blog
Earlier this year, MariaDB announced plans to become a publicly traded company through a combination with Angel Pond Holdings Corporation (NYSE: POND). To learn more, visit https://mariadb.com/IPO.
About MariaDB Corporation
MariaDB frees businesses from the cost, cloud lock-in, constraints, and complexity of proprietary databases, allowing them to reinvest in what matters most: rapidly developing innovative, customer-focused applications. MariaDB uses pluggable and purpose-built storage engines to support workloads that previously required a variety of specialized databases. With complexity and constraints removed, businesses can now rely on a single, comprehensive database for their needs, whether it’s off-the-shelf hardware or the cloud of their choice. Deployed in minutes for transactional, analytical, or hybrid use cases, MariaDB delivers unparalleled operational agility without sacrificing key enterprise features, including true ACID compliance and full SQL. Trusted by organizations like Bandwidth, DigiCert, InfoArmor, Oppenheimer, Samsung, SelectQuote, SpendHQ – MariaDB meets the same basic requirements as proprietary databases at a fraction of the cost. No wonder it’s one of the fastest growing database management system companies. Real business relies on MariaDB™.
See the source version on businesswire.com: https://www.businesswire.com/news/home/20220310005436/en/