ColumnStore Storage Engine
MariaDB Enterprise ColumnStore integrates with MariaDB Enterprise Server using the ColumnStore storage engine plugin. The ColumnStore storage engine plugin enables MariaDB Enterprise Server to interact with ColumnStore tables.
Latest Software Releases
Latest Release Date
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
Enterprise ColumnStore Version
(ES 10.5.6-4 and later)
(ES 10.5.5-3 and before)
MariaDB Enterprise ColumnStore is available on select platforms:
Red Hat Enterprise Linux 8
Red Hat Enterprise Linux 7
SUSE Linux Enterprise Server 15
SUSE Linux Enterprise Server 12
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:
Enterprise ColumnStore with Object Storage
Enterprise ColumnStore with Shared Local Storage
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.
MariaDB Enterprise ColumnStore 5 has the following features:
ES 10.4+, CS 10.5+
OLAP and Hybrid
High Availability (HA)
Main Memory Caching
Online Schema changes
Creating a ColumnStore Table
To create a ColumnStore table, use the CREATE TABLE statement with the
CREATE DATABASE columnstore_db; CREATE TABLE columnstore_db.analytics_test ( id INT, str VARCHAR(50) ) ENGINE = ColumnStore;
Configure the Mandatory Utility User Account
To configure the mandatory utility user account, use the mcsSetConfig command:
$ sudo mcsSetConfig CrossEngineSupport Host 127.0.0.1 $ sudo mcsSetConfig CrossEngineSupport Port 3306 $ sudo mcsSetConfig CrossEngineSupport User cross_engine $ sudo mcsSetConfig CrossEngineSupport Password cross_engine_passwd
How many nodes should my multi-node Enterprise ColumnStore deployment have?
If high availability is required, the MariaDB Enterprise ColumnStore deployment must meet some node count requirements:
It should have 3 or more nodes.
It should have an odd number of nodes.
These criteria help to avoid a split-brain scenario.
See Deployment Requirements for Enterprise ColumnStore for more information.
Is MaxScale a required component of multi-node Enterprise ColumnStore?
If high availability is required, a multi-node Enterprise ColumnStore deployment must have at least one MaxScale instance.
If high availability is required for the MaxScale instance too, a multi-node Enterprise ColumnStore deployment must have more than one MaxScale instance. In that case, the MaxScale instances should also be configured to use cooperative locking.