Home News MariaDB Radically Enhances Distributed SQL Product Xpand
Our website publishes news, press releases, opinion and advertorials on various financial organizations, products and services which are commissioned from various Companies, Organizations, PR agencies, Bloggers etc. These commissioned articles are commercial in nature. This is not to be considered as financial advice and should be considered only for information purposes. It does not reflect the views or opinion of our website and is not to be considered an endorsement or a recommendation. We cannot guarantee the accuracy or applicability of any information provided with respect to your individual or personal circumstances. Please seek Professional advice from a qualified professional before making any financial decisions. We link to various third-party websites, affiliate sales networks, and to our advertising partners websites. When you view or click on certain links available on our articles, our partners may compensate us for displaying the content to you or make a purchase or fill a form. This will not incur any additional charges to you. To make things simpler for you to identity or distinguish advertised or sponsored articles or links, you may consider all articles or links hosted on our site as a commercial article placement. We will not be responsible for any loss you may suffer as a result of any omission or inaccuracy on the website.

MariaDB Radically Enhances Distributed SQL Product Xpand

by wrich

Xpand gets smarter and goes global

London   March 11, 2022  MariaDB® Corporation today announced the release of Xpand 6 with significant new features, all in the pursuit of maximizing performance. With fast operational analytics, Xpand now has the smarts to eliminate the need and inconsistencies of loading data to operational data warehouses. Faster parallel data replication across global regions is putting global deployments in everyone’s 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 strict data consistency and availability. MariaDB Xpand is a fully distributed SQL database with a shared nothing architecture. Unlike AWS Aurora’s storage replication or Postgres’ read replication, Xpand is a true multi-writer, any node can be written to and adds scale for reads and writes.

Columnar Perspective

Columnar data models are popular for ad hoc analytics and perform well on large amounts of data. Xpand is the first modern distributed SQL database supporting 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 enables companies to run ad hoc queries in Xpand with speeds up to 50x faster. Best performance is guaranteed as the fully cost based optimizer will determine the faster path, columnar or not. Applications immediately benefit from the new feature without any changes after columnar indexes have been activated.  

Developers can leverage this new feature to provide smarter applications, better user experiences and personal analytics giving their application users the latest status and insights on all data changes that may impact them.

Parallel Replication

With parallel replication, Xpand implements the equivalent of a multi-lane highway for asynchronous replication of data across geo-locations. The data replication is done independently by each node in the cluster, which increases throughput at lower latency. Xpand provides transactional consistency by maintaining the order of transaction during replication. Powered by Xpand 6, customers can deploy their global applications across regions and cloud vendors to survive any hyperscaler outages.

“With these key new features in Xpand, developers get to broaden their use of analytics in applications without having to worry about performance, at the same time supporting the capability is literally effortless for the database administrators,” said Robbie Mihalyi, senior vice president of engineering at MariaDB Corporation. “The parallel replication capabilities have been shaped by our customers and their business needs, giving them maximum data transfer speeds at minimal latency and control over their data flows.”

Availability

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 get started use Xpand in the cloud, go to https://mariadb.com/skyview.

Additional Resources

  • Visit mariadb.com
  • Follow @mariadbon Twitter
  • Read MariaDB’s blog
  • Earlier this year MariaDB announced the intent to become a publicly traded company via combination with Angel Pond Holdings Corporation (NYSE:POND). To learn more, go to https://mariadb.com/IPO.

 

About MariaDB Corporation

MariaDB frees companies from the costs, cloud lock-in, constraints, and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing applications. MariaDB uses pluggable, purpose-built storage engines to support workloads that previously required a variety of specialized databases. With complexity and constraints eliminated, enterprises can now depend on a single complete database for their needs, whether on commodity hardware or their cloud of choice. Deployed in minutes for transactional, analytical, or hybrid use cases, MariaDB delivers unmatched operational agility without sacrificing key enterprise features, including real ACID compliance and full SQL. Trusted by organizations such as Bandwidth, DigiCert, InfoArmor, Oppenheimer, Samsung, SelectQuote, SpendHQ – MariaDB meets the same core requirements as proprietary databases at a fraction of the cost. No wonder it’s one of the fastest-growing database management systems companies. Real business relies on MariaDB™.

You may also like