What's New in MariaDB Enterprise ColumnStore 1.5?

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:

• It is the second ColumnStore version to be released as a plugin for MariaDB Enterprise Server.

• MariaDB Enterprise ColumnStore 1.5.3 first appeared in MariaDB Enterprise Server 10.5.4-2.

• In MariaDB Enterprise Server 10.5.6-4 and later, it has been superseded by MariaDB Enterprise ColumnStore 5.

Installation

MariaDB Enterprise ColumnStore 1.5 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.

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.

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