What's New in MariaDB Enterprise ColumnStore 5.4?

MariaDB Enterprise ColumnStore 5.4 introduces the following new features:

MariaDB Enterprise Server Convergence

MariaDB Enterprise ColumnStore 5.4 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 5.4 is included with MariaDB Enterprise Server 10.5:

Installation

MariaDB Enterprise ColumnStore 5.4 simplifies the installation process:

  • It is a plugin for MariaDB Enterprise Server.

  • It is deployed by installing a single additional package.

  • Users no longer need to execute columnstore-post-install and postConfigure.

  • It supports running Enterprise ColumnStore as a non-root user.

Note

To install this version, see Deploy MariaDB Enterprise ColumnStore 5.4.

Clients

MariaDB Enterprise ColumnStore 5.4 adds support for new clients:

  • It adds support for PowerBI Direct Query Adapter.

Administration

MariaDB Enterprise ColumnStore 5.4 supports simplified administration:

  • mcsadmin has been removed.

  • Enterprise ColumnStore 5.4 uses systemd for administration of single-node and multi-node deployments.

  • It provides a new systemd service called mariadb-columnstore, which 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

MariaDB Enterprise ColumnStore 5.4 supports multi-node deployments, which support high availability:

CMAPI

MariaDB Enterprise ColumnStore 5.4 includes CMAPI 1.1, which is a REST API:

  • The REST API provides simplified cluster management 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 Enterprise 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

S3-Compatible Object Storage

MariaDB Enterprise ColumnStore 5.4 supports S3-compatible object storage for data:

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

  • It supports IAM roles.

Supersedes 1.5

MariaDB Enterprise ColumnStore 5.4 supersedes MariaDB Enterprise ColumnStore 1.5: