MariaDB Energizes the Data Warehouse with Open Source Analytics Solution

MariaDB AX unleashes fast, scalable analytics with platform mobility and better price performance than proprietary offerings, eliminating the need for traditional data warehouses

MENLO PARK, Calif. and HELSINKI – November 21, 2017 – MariaDB® Corporation, the company behind the fastest growing open source database, today announced new product enhancements to MariaDB AX, delivering a modern approach to data warehousing that enables customers to easily perform fast and scalable analytics with better price performance over proprietary solutions. MariaDB AX expands the highly successful MariaDB Server, creating a solution that enables high performance analytics with distributed storage and parallel processing, and that scales with existing commodity hardware on premises or across any cloud platform. With MariaDB AX, data across every facet of the business is transformed into meaningful and actionable results.

Tweet this: #MariaDB energizes #data warehousing with MariaDB AX, #opensource #analytics for #cloud and on-prem deployments.

“MariaDB AX is a powerful, open source solution for performing custom and complex analytics,” said David Thompson, VP of Engineering at MariaDB Corporation. “In order to fully realize the power of big data, our customers need the ability to gather insights in near real time, regardless of where the data is coming from. With MariaDB AX, it’s easier than ever to ingest and analyze streaming data from disparate sources, while ensuring the highest level of reliability through new high availability and backup capabilities.”

Data warehouses are traditionally expensive and complex to operate. Driven by the need for more meaningful and timely analytics that meet hardware and cost pressures, companies are reassessing their data warehouse and analytics strategy. Built for performance and scalability, MariaDB AX uses a distributed and columnar open source storage engine with parallel query processing that allows customers to store more data and analyze it faster. MariaDB AX supports a wide range of advanced analytic use cases across every industry, for example, identifying health trends to inform healthcare programs and policy, behavioral analysis to inform customer service and sales strategies, and analysis of financial anomalies to inform fraud programs.

MariaDB AX includes new features that enable easy, high performance data analytics, such as:

  • Simpler and Streamlined Data Ingestion: Make data available for analysis quickly and easily. MariaDB AX, with the introduction of data adapters and direct access to the underlying storage engine, removes the need for complex, time-consuming batch processes to import data. By reducing the time it takes to make data available for analysis, organizations can realize a faster time-to-insight and the competitive advantages it brings. New data adapters include:
    • Bulk Data Adapters: Develop applications and services to continuously collect and write large amounts of data to MariaDB AX for analysis, or publish machine learning results to MariaDB AX for data scientists and others to view or further analyze via SQL.
    • Streaming Data Adapter for MariaDB MaxScale: Analyze operational data in near real time, within seconds of being created. When MariaDB TX is deployed for operational workloads, the data adapter uses MariaDB MaxScale and change-data-capture streams to replicate data from the operational environment to MariaDB AX automatically and continuously.
    • Streaming Data Adapter for Apache Kafka: Combine and analyze data from multiple sources by aggregating data from web, mobile and Internet of Things applications. The data adapter, currently in beta, consumes messages published to Apache Kafka topics and writes the data to MariaDB AX, enabling data scientists to analyze related data from multiple sources.
  • More Powerful, Custom Analytics: Extend the analytical capabilities of MariaDB AX by creating custom analytical functions for relational and non-relational data such as JSON. The introduction of an API for creating user-defined aggregate and window functions, combined with support for text and binary data, enables data scientists to analyze structured, semi-structured and unstructured data using custom analytical functions.
  • Improved High Availability and Disaster Recovery: Ensure data is always available for analysis and simplify the process of backing up and restoring data. MariaDB AX adds support for GlusterFS to provide data high availability without the need for an expensive SAN, while a new tool automatically uses multiple, concurrent connections to backup and restore distributed data on multiple servers from a single location.
  • “Like so many organizations today, for us, data is the lifeblood of our operations,” said Patrice Linel, Head of Scientific Computing at Genus plc, parent company of ABS Global and PIC, helping farmers produce better quality meat and milk more efficiently and sustainably. “With the new data ingestion capabilities in MariaDB AX, we are freed from the manual, time-consuming practice of moving massive amounts of genetic data from its source format for analysis. Now with MariaDB AX, we can queue and instantly move data directly from Python into MariaDB where real-time analytics happens. The effort saved is substantial and the data is always the most current.”

MariaDB AX is available for download now.


Additional Resources


About MariaDB Corporation

MariaDB Corporation is the company behind MariaDB, the fastest growing Open Source database. MariaDB, with a strong history of community innovation and enterprise adoption, provides the most functionally complete open source database. MariaDB powers applications at companies including Google, Wikipedia, Tencent, Verizon, DBS Bank, Deutsche Bank, Telefónica, Huatai Securities and more.

MariaDB solutions are engineered to run on any infrastructure – bare metal servers, virtual machines, containers, public and private clouds – and is available in all leading Linux distributions, including Ubuntu, and is the default database in openSUSE, Manjaro, Red Hat Enterprise Linux (RHEL) / CentOS / Fedora, Arch Linux, SUSE Linux Enterprise and Debian, with a reach of more than 60 million developers worldwide.