MariaDB ColumnStore

Powering scalable, high-performance analytics with MariaDB

MariaDB ColumnStore is a storage engine optimized for modern analytical workloads – distributed and with parallel query processing for greater scalability, and columnar storage for higher efficiency and query performance. MariaDB AX extends MariaDB Server with MariaDB ColumnStore, data adapters and tools to create an enterprise open source solution for modern analytics and data warehousing.

What's new

  • Custom analytics: user-defined aggregate and window functions
  • Semi and unstructured data: TEXT and BLOB columns
  • Simplified HA and DR: transparent GlusterFS support, parallel backup/restore

MariaDB-columnStore_v1_final.png

 

Distributed

The data is automatically partitioned and distributed to multiple storage nodes – deploy more storage nodes to store and query more data.

 

Parallel

SQL queries can be load balanced with multiple query nodes and executed on multiple partitions in parallel with multiple storage nodes.

Columnar

The data is stored by column for higher compression, reduced disk IO and lower query latency — necessary to query many, if not all, rows.

Extensible

The analytical capabilities can be extended by creating custom functions with the user-defined aggregate and window function APIs.

Flexible

TEXT and BLOB column support for analysis of semi and unstructured data, including JSON documents and binary data.

Reliable

GlusterFS support as an option for high availability and automatic failover, and backup/restore with parallel rsync and centralized management.