MariaDB ColumnStore

MariaDB ColumnStore is a columnar storage engine for online analytical processing (OLAP), data warehousing, business intelligence, and hybrid transactional-analytical processing (HTAP). MariaDB ColumnStore is included with MariaDB Community Server.

MariaDB Enterprise ColumnStore supports MaxScale, multi-node deployments, and high availability for MariaDB Enterprise Server.

Latest Software Releases

  • 2021-05-07 MariaDB ColumnStore 5.5.2

Benefits

  • Columnar storage engine that enables MariaDB Community Server to perform new workloads

  • Optimized for online analytical process (OLAP) workloads including data warehousing, decision support systems, and business intelligence

  • Single-stack solution for hybrid transactional-analytical workloads to eliminate barriers and prevent data silos

  • Implements cross-engine JOINs to join ColumnStore tables with tables using row-based storage engines, such as InnoDB

  • Smart storage engine that plans and optimizes its own queries using a custom select handler

  • S3-compatible object storage can be used for highly available, low-cost, multi-regional, resilient, scalable, secure, and virtually limitless data storage

  • Connectors for popular BI platforms such as Microsoft Power BI and Tableau

  • High-speed bulk data loading that bypasses the SQL layer and does not block concurrent read-only queries

Deploy

  • Available in the cloud on MariaDB SkySQL DBaaS

  • Available for production on-premises deployments, with deployment instructions provided.

    MariaDB ColumnStore supports multiple topologies. The options described on this page are representative of basic product capabilities.

    MariaDB products can be deployed to form other topologies that leverage advanced product capabilities and combine the capabilities of multiple topologies.

Available Versions

The version of MariaDB ColumnStore depends on the version of MariaDB Community Server being used:

Community Server

ColumnStore

CS10.5.7 and later

MariaDB ColumnStore 5

CS10.5.6 and before

MariaDB ColumnStore 1.5

Available Platforms

MariaDB ColumnStore is available on select platforms:

  • CentOS 8

  • CentOS 7

  • Debian 10

  • Debian 9

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

  • Ubuntu 20.04

  • Ubuntu 18.04