MariaDB ColumnStore Quick Start Guide

Posted on September 7, 2023 by

In this blog post, we will guide you through the process of setting up MariaDB Server with the ColumnStore storage engine. The following steps will get you started.

Step 1: Installing MariaDB Server and ColumnStore

To begin, open your Linux terminal and execute the following commands:

Red Hat/Rocky Example:

$ curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=11.1

$ sudo dnf -y install MariaDB MariaDB-columnstore-engine MariaDB-columnstore-cmapi

Debian/Ubuntu Example:

$ curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=11.1

$ sudo apt-get -y install mariadb-server mariadb-plugin-columnstore mariadb-columnstore-cmapi

The first command downloads and runs the MariaDB repository setup script. With this, we ensure that we’re installing the appropriate version of MariaDB for our server.

The second command installs MariaDB along with the ColumnStore engine and the ColumnStore Command API (CMAPI).

 

Step 2: Enabling and Starting MariaDB Services

After successful installation, it’s time to enable and start the MariaDB services. Issue the following commands:

$ sudo systemctl enable mariadb

$ sudo systemctl enable mariadb-columnstore-cmapi
$ sudo systemctl start mariadb

$ sudo systemctl start mariadb-columnstore-cmapi

These commands enable the MariaDB service and the ColumnStore CMAPI service to start automatically on system boot. Then, they start both services immediately as well.

 

Step 3: Configuring the MariaDB Cluster

Next, we’ll configure the MariaDB server by adding a node and setting an API key. Execute the following commands:

$ sudo mcs cluster set api-key --key somekey123
$ sudo mcs cluster node add --node 127.0.0.1

The first command sets the API key for the cluster. Replace `somekey123` with your desired API key.

The second command adds a node to the cluster, using `127.0.0.1` as the IP address for this particular node.

Congratulations! You have successfully set up your MariaDB cluster with the ColumnStore engine. You can now proceed to further configuration or experimentation with your database.

Remember to explore the official MariaDB and ColumnStore documentation for more details on advanced configurations and usage.

 

About MariaDB ColumnStore

MariaDB ColumnStore is a massively parallel analytical database that provides high scalability and performance for analytical workloads. It is designed to process large volumes of data and handle complex queries with ease. MariaDB ColumnStore is part of the popular MariaDB Server and is now offered as a simple plugin.

 

Additional Resources

We hope you found this blog post helpful. Happy coding!