What's New in MariaDB Enterprise ColumnStore 5.5?
Topics on This Page:
The following changes were introduces in MariaDB Enterprise ColumnStore, as included with MariaDB Enterprise Server 10.5:
Enterprise
MariaDB Enterprise ColumnStore 5.5 is included with MariaDB Enterprise Server 10.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.
Installation
MariaDB Enterprise ColumnStore 5.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.It supports running Enterprise ColumnStore as a non-root user.
Note
To install this version, see Deploy MariaDB Enterprise ColumnStore 5.5.
Administration
MariaDB Enterprise ColumnStore 5.5 supports simplified administration:
mcsadmin has been removed.
Enterprise ColumnStore 5.5 uses systemd to administer its service in single-node deployments.
It provides a new
systemd
service calledmariadb-columnstore
, which is used to manage Enterprise ColumnStore's service in single-node deployments. Thissystemd
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
MariaDB Enterprise ColumnStore 5.5 supports multi-node deployments, which support high availability:
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.
CMAPI
MariaDB Enterprise ColumnStore 5.5 includes CMAPI 1.2, 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.5 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 5.4
MariaDB Enterprise ColumnStore 5.5 supersedes MariaDB Enterprise ColumnStore 5.4:
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.