Installing MariaDB ColumnStore (single node) on Ubuntu 22.04

First, go the the following URL:

https://mariadb.org/download/

Choose MariaDB Server Repositories, and install MariaDB by following the instructions provided by that page.

Verify that MariaDB is correctly installed, and run the following commands:

  apt-get update -y
  apt-get install -y mariadb-plugin-columnstore

jemalloc is an alternative malloc implementation. It is recommended with MariaDB ColumnStore, because with the default allocator mmap-ed memory will never be released. See MCOL-2136.

With this installation procedure, MariaDB will run as a systemd service. So you will need to instruct systemd to load jemalloc instead of malloc.

In the /lib/systemd/system/mariadb.service file, locate the [Service] group and add this line:

  Environment=LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libjemalloc.so.2

Now you should reload the configuration, so that the new setting can take effect, and restart MariaDB:

  systemctl daemon-reload
  systemctl restart mariadb

For more information, see the MariaDB KB page Using MariaDB with TCMalloc or jemalloc.

To enable S3, first install MariaDB S3 storage engine:

  apt-get install -y mariadb-plugin-s3

Then configure the ColumnStore StorageManager:

  mcsSetConfig Installation DBRootStorageType "StorageManager"
  mcsSetConfig StorageManager Enabled "Y"
  mcsSetConfig SystemConfig DataFilePlugin "libcloudio.so"

With this minimal configuration, the StorageManager can be loaded and started by ColumnStore. For a complete configuration, see the StorageManager section.