MariaDB ColumnStore is a columnar storage engine that utilizes a massively parallel distributed data architecture. It was built by porting InfiniDB to MariaDB and has been released under the GPL license.

MariaDB ColumnStore is designed for big data scaling to process petabytes of data, linear scalability and exceptional performance with real-time response to analytical queries. It leverages the I/O benefits of columnar storage, compression, just-in-time projection, and horizontal and vertical partitioning to deliver tremendous performance when analyzing large data sets.

Please install the following software packages before you begin.

• Docker

docker run -d -p 3307:3306 --shm-size=512m -e PM1=mcs1 --hostname=mcs1 --name mcs1 mariadb/columnstore

docker exec -it mcs1 provision mcs1

Waiting for PM1 To Be Initialized .. done
Adding PM(s) To Cluster ... done
Restarting Cluster ... done
Validating ColumnStore Engine ... done

git clone https://github.com/mariadb-corporation/mariadb-columnstore-docker

cd mariadb-columnstore-docker

cp .env_example .env

• Edit .env with your custom settings

docker compose up -d

docker exec -it mcs1 provision mcs1 mcs2 mcs3

Waiting for PM1 To Be Initialized .... done
Adding PM(s) To Cluster ... done
Restarting Cluster ... done
Validating ColumnStore Engine ... done

git clone https://github.com/mariadb-corporation/mariadb-columnstore-docker

cd mariadb-columnstore-docker

cp .env_example .env

cp .secrets_example .secrets

• Edit .env with your custom settings
• Edit .secrets with your Enterprise Token

./build

mysql -h 127.0.0.1 -P 3307 -u admin -p

The default password is: C0lumnStore!

• URL: http://127.0.0.1:8989
• username: admin
• password: mariadb

• URL: http://127.0.0.1:8990
• username: admin
• password: mariadb

• PM: Performance Module
• PM1: Primary Database Node
• PM2: Secondary Database Node
• PM3: Tertiary Database Node
• MX1: Primary MaxScale Node
• MX2: Secondary MaxScale Node

mcs cluster set api-key --key <api_key>

mcs cluster status

mcs cluster start

mcs cluster stop

mcs cluster node add --node <node>

mcs cluster node remove --node <node>

mcs cluster set mode --mode readonly

mcs cluster set mode --mode readwrite

Logs are stored in /var/log/mariadb/columnstore

They are also available via the following command:

docker logs mcs1