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.

Enterprise

MariaDB ColumnStore 1.5 is included with MariaDB Enterprise Server 10.5:

Community

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

    status

    sudo mcsadmin startSystem

    start

    sudo mcsadmin shutdownSystem

    shutdown

    sudo mcsadmin addModule

    add-node

    sudo mcsadmin removeModule

    remove-node

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.

Note

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.