What's New in MariaDB Enterprise ColumnStore 1.5?

MariaDB Enterprise ColumnStore 1.5 introduces the following new features:

MariaDB Enterprise Server Convergence

MariaDB Enterprise ColumnStore 1.5 converges with MariaDB Enterprise Server even further:

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

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

Enterprise

MariaDB Enterprise ColumnStore 1.5 is included with MariaDB Enterprise Server 10.5:

Installation

MariaDB Enterprise ColumnStore 1.5 simplifies the installation process:

Note

MariaDB Enterprise ColumnStore 1.5 has been superseded by MariaDB Enterprise ColumnStore 5.4. To install this version, see Deploy MariaDB Enterprise ColumnStore 5.4.

OAM Replacement

MariaDB Enterprise ColumnStore 1.5 replaces the OAM:

  • mcsadmin has been removed.

  • 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

  • Multi-node Enterprise ColumnStore 1.5 uses CMAPI (Cluster Management API) for cluster management. CMAPI is a REST API.

  • 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 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 Enterprise 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 Enterprise ColumnStore tables with the utf8 character set. To ensure that all MariaDB Enterprise ColumnStore tables use the proper character set, MariaDB Enterprise 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 Enterprise 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 Enterprise ColumnStore 1.5 adds support for additional Data Definition Language (DDL) statements:

Improved Support for DML

MariaDB Enterprise 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 Enterprise 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 Enterprise ColumnStore 1.5.3 release notes.