What's New in MariaDB ColumnStore 5?

MariaDB ColumnStore 5 is included with MariaDB Community Server 10.5.

The new features in MariaDB ColumnStore 5 are listed below.

MariaDB Enterprise ColumnStore supports MaxScale, multi-node deployments, and high availability for MariaDB Enterprise Server. For information, see "What's New in MariaDB Enterprise ColumnStore 5".

MariaDB Community Server Convergence

MariaDB has been continually improving the integration of MariaDB ColumnStore with MariaDB Community Server:

MariaDB ColumnStore 5 simplifies the installation procedure. Installing the ColumnStore storage engine is similar to installing other storage engines for Community Server.

Available Versions

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

CS Version

ColumnStore Version

CS 10.5.10

MariaDB ColumnStore 5.5.2

CS 10.5.9

MariaDB ColumnStore 5.5.1

CS 10.5.8
CS 10.5.7

MariaDB ColumnStore 5.4.1

Installation

MariaDB ColumnStore 5 simplifies the installation procedure. Installing the ColumnStore storage engine is similar to installing other storage engines for MariaDB Community Server.

For single-node ColumnStore 5 deployments, the ColumnStore storage engine, the ColumnStore command-line interfaces, and other internal ColumnStore components are deployed by installing a single package in addition to the MariaDB Community Server package.

Installing ColumnStore 5 no longer requires running columnstore-post-install or postConfigure.

ColumnStore 5 can be installed to run as a non-root user.

Note

To install this version, see Deploy MariaDB ColumnStore 5.

Clients

MariaDB ColumnStore 5 adds support for Microsoft Power BI Direct Query Adapter.

Administration

MariaDB ColumnStore 5 simplifies administration.

ColumnStore 5 no longer includes or supports mcsadmin.

For single-node ColumnStore 5 deployments, the ColumnStore 5 service is administered by systemd:

Operation

Command

Start

sudo systemctl start mariadb-columnstore

Stop

sudo systemctl stop mariadb-columnstore

Restart

sudo systemctl restart mariadb-columnstore

Enable during startup

sudo systemctl enable mariadb-columnstore

Disable during startup

sudo systemctl disable mariadb-columnstore

Status

sudo systemctl status mariadb-columnstore

S3-Compatible Object Storage

MariaDB ColumnStore 5 supports IAM roles with S3-compatible object storage.

Supersedes 1.5

MariaDB ColumnStore 5 supersedes MariaDB ColumnStore 1.5 and includes the changes in MariaDB ColumnStore 1.5.4.