What's New in MariaDB ColumnStore 1.5??

MariaDB ColumnStore 1.5 introduces the following new features:

MariaDB Server Convergence?

MariaDB ColumnStore 1.5 converges with MariaDB Server even further:

  • It uses a simplified installation procedure, which is similar to other MariaDB Server storage engines.

  • It supports even more queries and other features that are supported by MariaDB Server.


MariaDB ColumnStore 1.5 is included with MariaDB Enterprise Server 10.5:


MariaDB ColumnStore 1.5 is included with MariaDB Community Server 10.5:

Simplified Installation?

MariaDB ColumnStore 1.5 simplifies the installation process:

OAM Replacement?

MariaDB ColumnStore 1.5 replaces the OAM:

  • mcsadmin has been removed.

  • In MariaDB Community Server, ColumnStore 1.5 uses systemd for administration.

  • In MariaDB Enterprise Server, Enterprise ColumnStore 1.5 uses systemd for administration of single-node and multi-node deployments, and it also adds a new REST API for administration of multi-node deployments.

  • The new systemd service called mariadb-columnstore is used to manage ColumnStore's processes. This systemd service replaces the following mcsadmin commands:

    Old mcsadmin Command

    Replacement systemd Command

    sudo mcsadmin startSystem

    sudo systemctl start mariadb-columnstore

    sudo mcsadmin stopSystem

    sudo systemctl stop mariadb-columnstore

    sudo mcsadmin shutdownSystem

    sudo systemctl stop mariadb-columnstore

    sudo mcsadmin restartSystem

    sudo systemctl restart mariadb-columnstore

  • The new REST API provides simplified administration for multi-node Enterprise ColumnStore deployments by:

    • Removing the need to configure SSH between nodes in a multi-node Enterprise ColumnStore deployment.

    • Providing an interface for MariaDB MaxScale 2.5 to orchestrate the multi-node Enterprise ColumnStore deployment.

    • This REST API replaces the following mcsadmin commands for multi-node ColumnStore deployments:

    Old mcsadmin Command

    Replacement REST API Command

    sudo mcsadmin getSystemStatus


    sudo mcsadmin startSystem


    sudo mcsadmin shutdownSystem


    sudo mcsadmin addModule


    sudo mcsadmin removeModule


Character Sets and Collations?

MariaDB ColumnStore 1.5 adds support for more character sets and collations in more scenarios:

  • It uses a column's defined collation to sort the column for ORDER BY operations, rather than always sorting with latin1_general_cs.

  • It adds support for the COLLATE clause in CREATE TABLE and ALTER TABLE statements.

  • It adds support for the COLLATE clause in ORDER BY clauses.


Currently, it is still recommended to create MariaDB ColumnStore tables with the utf8 character set. To ensure that all MariaDB ColumnStore tables use the proper character set, MariaDB ColumnStore's installation and upgrade procedures in the Deployment Guide say that the character_set_server system variable should be set to utf8.

S3-Compatible Object Storage?

MariaDB ColumnStore 1.5 adds further enhancements to its capabilities with S3-compatible object storage:

  • It ensures that Storage Manager shuts down properly when a fatal error occurs.

  • It adds support to cpimport for multi-node ColumnStore deployments that use S3-compatible object storage.

Query Compatibility?

Improved Support for DDL?

MariaDB ColumnStore 1.5 adds support for additional Data Definition Language (DDL) statements:

Improved Support for DML?

MariaDB ColumnStore 1.5 adds support for additional Data Manipulation Language (DML) statements:

  • It improves support for using the LOAD DATA INFILE statement within a transaction.

  • It adds support for microseconds to the FROM_UNIXTIME() function.

  • It improves support for the EXPLAIN statement.

Improved Support for Window Functions?

MariaDB ColumnStore 1.5 adds support for additional queries that use window functions:

  • It adds support for using an IN() in a WHERE clause when the query uses a window function.

  • It adds support for COUNT(NULL) OVER().

For a complete list of changes, see MariaDB ColumnStore 1.5.2 release notes.