What's New in MariaDB Enterprise ColumnStore 5.5?

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

MariaDB Enterprise ColumnStore 5.5.1 first appeared in MariaDB Enterprise Server 10.5.8-5.

MariaDB Enterprise ColumnStore 5.5 supersedes MariaDB Enterprise ColumnStore 5.4.

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.

mcsadmin has been removed.

Enterprise ColumnStore 5.5 uses systemd to administer its service in single-node deployments.

It provides a new systemd service called mariadb-columnstore, which is used to manage Enterprise ColumnStore's service in single-node deployments. 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 Enterprise ColumnStore service should not be manually started or enabled in a multi-node deployment. The Enterprise ColumnStore service will be started as-needed by the CMAPI service, so it does not need to start automatically upon reboot.

Multi-node Enterprise ColumnStore 5.5 requires MaxScale 2.5.

Multi-node Enterprise ColumnStore 5.5 requires shared storage, such as EFS, Filestore, GlusterFS, and NFS. It also optionally supports S3-compatible storage for data, but it still requires shared storage for metadata.

Multi-node Enterprise ColumnStore 5.5 uses CMAPI (Cluster Management API) for cluster management. CMAPI 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

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

It supports IAM roles.

It includes the changes in MariaDB Enterprise ColumnStore 5.4.3.

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