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 Platform.

Latest Software Releases

Version

Latest Release

Latest Release Date

MariaDB Enterprise ColumnStore 5

5.6.1

2021-06-14

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

  • Ubuntu 16.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:

Topology

Diagram

Features

Enterprise ColumnStore with Object Storage
Enterprise ColumnStore with Object Storage
  • Analytics with scalable S3-compatible storage

  • Highly available

  • Scales reads

  • Data protection using S3-compatible object storage

  • ES 10.5, ColumnStore 5, MaxScale 2.5

Enterprise ColumnStore with Shared Local Storage
Enterprise ColumnStore with Shared Local Storage
  • Analytics

  • Highly available

  • Scales reads

  • Data protection using shared local storage

  • ES 10.5, ColumnStore 5, MaxScale 2.5

HTAP
HTAP with Object Storage
  • Single-Stack Hybrid Transactions/Analytics

  • ColumnStore for analytics

  • InnoDB for transactions

  • Cross-engine JOINs

  • ES 10.5, ColumnStore 5, MaxScale 2.5

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.