MariaDB Enterprise ColumnStore Deployment Requirements

MariaDB Enterprise ColumnStore requires certain hardware specifications, node counts, and storage configurations to function properly and provide high availability.

Hardware Requirements

The minimum and recommended hardware requirements are listed below.

Minimum Hardware Requirements

MariaDB Enterprise ColumnStore's minimum hardware requirements are not intended for production environments, but the minimum hardware requirements can be appropriate for development and test environments. For production environments, see the recommended hardware requirements instead.

The minimum hardware requirements are:

Component

CPU

Memory

MaxScale node

4+ cores

4+ GB

Enterprise ColumnStore node

4+ cores

16+ GB

MariaDB Enterprise ColumnStore will refuse to start if the system has less than 3 GB of memory.

If Enterprise ColumnStore is started on a system with less memory, the following error message will be written to the ColumnStore system log called crit.log:

Apr 30 21:54:35 a1ebc96a2519 PrimProc[1004]: 35.668435 |0|0|0| C 28 CAL0000: Error total memory available is less than 3GB.

And the following error message will be raised to the client:

ERROR 1815 (HY000): Internal error: System is not ready yet. Please try again.

ColumnStore Node Count Requirements

Each ColumnStore node runs MariaDB Enterprise Server and has the ColumnStore storage engine installed.

MariaDB Enterprise ColumnStore supports single-node deployments.

MariaDB Enterprise ColumnStore supports multi-node deployments for high availability and load balancing. Multi-node Enterprise ColumnStore requires an odd number of ColumnStore nodes with a minimum of 3.

CMAPI Requirements

The Cluster Management API (CMAPI) server provides a REST API that can be used to configure and manage Enterprise ColumnStore.

Single-node MariaDB Enterprise ColumnStore does not require CMAPI.

Multi-node MariaDB Enterprise ColumnStore requires CMAPI to be running on every ColumnStore node.

MaxScale Requirements

MariaDB Enterprise ColumnStore leverages MariaDB MaxScale.

Single-node MariaDB Enterprise ColumnStore does not require MaxScale.

Multi-node MariaDB Enterprise ColumnStore requires MaxScale for high availability and load balancing. Multi-node Enterprise ColumnStore requires at least one MaxScale node. For highly available load balancing, multiple MaxScale nodes can be used by configuring cooperative locking.

Storage Requirements

MariaDB Enterprise ColumnStore has specific storage requirements.

See Enterprise ColumnStore Storage Requirements for more information.