MariaDB Enterprise ColumnStore

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

Latest Software Releases

Version

Latest Release

Latest Release Date

MariaDB Enterprise ColumnStore 6

6.1.1

2021-08-26

MariaDB Enterprise ColumnStore 5

5.6.2

2021-06-30

Benefits

  • Columnar storage engine that enables MariaDB Enterprise 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 Enterprise 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

  • Scalable query execution using massively parallel processing (MPP) strategies, parallel query execution, and distributed function evaluation

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

  • High availability and automatic failover by leveraging MariaDB MaxScale

  • REST API for multi-node administration with the Cluster Management API (CMAPI) server

  • 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

Available Versions

ES Version

Enterprise ColumnStore Version

ES 10.6

MariaDB Enterprise ColumnStore 6

(ES 10.5.6-4 and later)

MariaDB Enterprise ColumnStore 5

(ES 10.5.5-3 and before)

MariaDB Enterprise ColumnStore 1.5

ES 10.4

MariaDB Enterprise ColumnStore 1.4

Available Platforms

MariaDB Enterprise ColumnStore is available on select platforms:

  • CentOS 7

  • CentOS 8

  • Debian 9

  • Debian 10

  • Red Hat Enterprise Linux 7

  • Red Hat Enterprise Linux 8

  • SUSE Linux Enterprise Server 12

  • SUSE Linux Enterprise Server 15

  • Ubuntu 18.04

  • Ubuntu 20.04

Deployment Instructions

MariaDB Enterprise ColumnStore is available for production in the cloud on MariaDB SkySQL DBaaS. For additional information, see the MariaDB SkySQL Documentation

MariaDB Enterprise ColumnStore is available for production on-premises deployments. For on-premises deployment instructions, choose a topology and version:

Software Version

Diagram

Features

ColumnStore Object Storage Topology
  • Columnar storage engine with S3-compatible object storage

  • Highly available

  • Automatic failover via MaxScale and CMAPI

  • Scales reads via MaxScale

  • Bulk data import

  • Enterprise Server 10.5, Enterprise ColumnStore 5, MaxScale 2.5

  • Enterprise Server 10.6, Enterprise ColumnStore 6, MaxScale 6.1

ColumnStore Shared Local Storage Topology
  • Columnar storage engine with shared local storage

  • Highly available

  • Automatic failover via MaxScale and CMAPI

  • Scales reads via MaxScale

  • Bulk data import

  • Enterprise Server 10.5, Enterprise ColumnStore 5, MaxScale 2.5

  • Enterprise Server 10.6, Enterprise ColumnStore 6, MaxScale 6.1

HTAP Topology
  • Single-tack hybrid transactional/analytical workloads

  • ColumnStore for analytics with scalable S3-compatible object storage

  • InnoDB for transactions

  • Cross-engine JOINs

  • Enterprise Server 10.5, Enterprise ColumnStore 5, MaxScale 2.5

  • Enterprise Server 10.6, Enterprise ColumnStore 6, MaxScale 6.1

MariaDB Enterprise 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.