W3cubDocs

/MariaDB

Installing MariaDB AX / MariaDB ColumnStore from the Package Repositories - 1.2.X

Introduction

Installing MariaDB AX and MariaDB ColumnStore individual packages can be done from the yum, apt-get, and zypper Repositories based on the OS.

MariaDB AX packages which consist of:

  • MariaDB ColumnStore Platform
  • MariaDB ColumnStore API (Bulk Write SDK)
  • MariaDB ColumnStore Data-Adapters
  • MariaDB ColumnStore Tools
  • MariaDB Maxscale
  • MariaDB Connectors
    • MariaDB Maxscale CDC Connector
    • MariaDB ODBC Connector
    • MariaDB Java-client Connector jar file

You can install packages from the Repositories for Single-Server installs and for Multi-Server installs utilizing the Non-Distributed feature where the packages are installed on all the servers in the cluster before the configuration and setup is performed.

NOTE: Document shows installing the latest GA version of each package by using 'latest' in the download paths. You can also install other version by entering the specific release ID, like 1.2.2-1.

MariaDB AX Packages

This section shows how to setup and install all associated packages for MariaDB AX.

Start by doing the MariaDB Connector Packages. Go to that section and install the connectors first.

CentOS 6

Adding the MariaDB AX YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore.repo

[mariadb-columnstore]
name=MariaDB ColumnStore
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/yum/centos/6/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-tools.repo

[mariadb-columnstore-tools]
name=MariaDB ColumnStore Tools
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/yum/centos/6/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Add new file with repository information, /etc/yum.repos.d/mariadb-maxscale.repo

[mariadb-maxscale]
name=MariaDB MaxScale
baseurl=https://downloads.mariadb.com/MaxScale/latest/centos/6/x86_64
gpgkey=https://downloads.mariadb.com/MaxScale/MariaDB-MaxScale-GPG-KEY
gpgcheck=1

Installing MariaDB AX

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum groups mark remove "MariaDB ColumnStore"
sudo yum groupinstall "MariaDB ColumnStore"
sudo yum --enablerepo=mariadb-columnstore-tools clean metadata
sudo yum install mariadb-columnstore-tools
sudo yum --enablerepo=mariadb-maxscale clean metadata
sudo yum install maxscale maxscale-cdc-connector

CentOS 7

Adding the MariaDB AX YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore.repo

[mariadb-columnstore]
name=MariaDB ColumnStore
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-api.repo

[mariadb-columnstore-api]
name=MariaDB ColumnStore API
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Adding the MariaDB ColumnStore Tools YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-tools.repo

[mariadb-columnstore-tools]
name=MariaDB ColumnStore Tools
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Add new file with repository information, /etc/yum.repos.d/mariadb-maxscale.repo

[mariadb-maxscale]
name=MariaDB MaxScale
baseurl=https://downloads.mariadb.com/MaxScale/latest/centos/7/x86_64
gpgkey=https://downloads.mariadb.com/MaxScale/MariaDB-MaxScale-GPG-KEY
gpgcheck=1

Adding the MariaDB ColumnStore Data Adapters YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-data-adapters.repo

[mariadb-columnstore-data-adapters]
name=MariaDB ColumnStore Data Adapters
baseurl=https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Installing MariaDB AX

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum groups mark remove "MariaDB ColumnStore"
sudo yum groupinstall "MariaDB ColumnStore"
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install epel-release
sudo yum install mariadb-columnstore-api*
sudo yum --enablerepo=mariadb-columnstore-tools clean metadata
sudo yum install mariadb-columnstore-tools
sudo yum --enablerepo=mariadb-maxscale clean metadata
sudo yum install maxscale maxscale-cdc-connector
sudo yum --enablerepo=mariadb-columnstore-data-adapters clean metadata
sudo yum install mariadb-columnstore-data-adapters-maxscale-cdc-adapter
sudo yum install mariadb-columnstore-data-adapters-avro-kafka-adapter

SUSE 12

Adding the MariaDB ColumnStore ZYPPER repository

Add new file with repository information, /etc/zypp/repos.d/mariadb-columnstore.repo

[mariadb-columnstore]
name=mariadb-columnstore
enabled=1
autorefresh=0
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/yum/sles/12/x86_64
type=rpm-md

Add new file with repository information, /etc/zypp/repos.d/mariadb-columnstore-tools.repo

[mariadb-columnstore-tools]
name=mariadb-columnstore-tools
enabled=1
autorefresh=0
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/yum/sles/12/x86_64
type=rpm-md

Add new file with repository information, /etc/zypp/repos.d/mariadb-maxscale.repo

[mariadb-maxscale]
name=mariadb-maxscale
enabled=1
autorefresh=0
baseurl=https://downloads.mariadb.com/MaxScale/latest/sles/12/x86_64
type=rpm-md

Download the MariaDB ColumnStore and MaxScale keys

rpm --import https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key
rpm --import https://downloads.mariadb.com/MaxScale/MariaDB-MaxScale-GPG-KEY

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo zypper refresh
sudo zypper install mariadb-columnstore*
sudo zypper install mariadb-columnstore-tools
sudo zypper install maxscale maxscale-cdc-connector

Debian 8

Adding the MariaDB ColumnStore APT-GET repository

Install package:

sudo apt-get install apt-transport-https

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/debian8 jessie main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-api.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/debian8 jessie main

Add new file with repository information, /etc/apt/sources.list.d/debian-backports.list

deb http://httpredir.debian.org/debian jessie-backports main contrib non-free

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/debian8 jessie main

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/debian jessie main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-data-adapters.list

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/debian8 jessie main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Download the MariaDB MaxScale key

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore*
sudo apt-get install mariadb-columnstore-api*
sudo apt-get install mariadb-columnstore-tools
sudo apt-get install maxscale maxscale-cdc-connector
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters
sudo apt-get install mariadb-columnstore-kafka-avro-adapters

Debian 9

Adding the MariaDB ColumnStore APT-GET repository

Install package:

sudo apt-get install apt-transport-https dirmngr

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/debian9 stretch main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-api.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/debian9 stretch main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/debian9 stretch main

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/debian stretch main

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/debian9 stretch main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Download the MariaDB MaxScale key

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore*
sudo apt-get install mariadb-columnstore-api*
sudo apt-get install mariadb-columnstore-tools
sudo apt-get install maxscale maxscale-cdc-connector
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters
sudo apt-get install mariadb-columnstore-kafka-avro-adapters

Ubuntu 16

Adding the MariaDB ColumnStore APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/ubuntu16 xenial main

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/ubuntu16 xenial main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/ubuntu16 xenial main

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/ubuntu xenial main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-data-adapters.list

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/ubuntu16 xenial main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Download the MariaDB MaxScale key

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore*
sudo apt-get install mariadb-columnstore-api*
sudo apt-get install mariadb-columnstore-tools
sudo apt-get install maxscale maxscale-cdc-connector
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters
sudo apt-get install mariadb-columnstore-kafka-avro-adapters

Ubuntu 18

Adding the MariaDB ColumnStore APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/ubuntu18 bionic main

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/ubuntu18 bionic main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/ubuntu18 bionic main

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/ubuntu bionic main

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-data-adapters.list

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/ubuntu18 bionic main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Download the MariaDB MaxScale key

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo add-apt-repository universe
sudo apt-get install mariadb-columnstore*
sudo apt-get install mariadb-columnstore-api*
sudo apt-get install mariadb-columnstore-tools
sudo apt-get install maxscale maxscale-cdc-connector
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters
sudo apt-get install mariadb-columnstore-kafka-avro-adapters

MariaDB ColumnStore Packages

Before install, make sure you go through the preparation guide to complete the system setup before installs the packages

https://mariadb.com/kb/en/library/preparing-for-columnstore-installation-11x/

CentOS 6

Adding the MariaDB ColumnStore YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore.repo

[mariadb-columnstore]
name=MariaDB ColumnStore
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/yum/centos/6/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum groups mark remove "MariaDB ColumnStore"
sudo yum groupinstall "MariaDB ColumnStore"

You can also install this way:

sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum install mariadb-columnstore*

CentOS 7

Adding the MariaDB ColumnStore YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore.repo

[mariadb-columnstore]
name=MariaDB ColumnStore
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum groups mark remove "MariaDB ColumnStore"
sudo yum groupinstall "MariaDB ColumnStore"

You can also install this way:

sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum install mariadb-columnstore*

SUSE 12

Adding the MariaDB ColumnStore ZYPPER repository

Add new file with repository information, /etc/zypp/repos.d/mariadb-columnstore.repo

[mariadb-columnstore]
name=mariadb-columnstore
enabled=1
autorefresh=0
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/yum/sles/12/x86_64
type=rpm-md

Download the MariaDB ColumnStore key

rpm --import https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo zypper refresh
sudo zypper install mariadb-columnstore*

Debian 8

Adding the MariaDB ColumnStore APT-GET repository

Install package:

sudo apt-get install apt-transport-https

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/debian8 jessie main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore*

Debian 9

Adding the MariaDB ColumnStore APT-GET repository

Install package:

sudo apt-get install apt-transport-https dirmngr

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/debian9 stretch main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore*

Ubuntu 16

Adding the MariaDB ColumnStore APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/ubuntu16 xenial main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore*

Ubuntu 18

Adding the MariaDB ColumnStore APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore/latest/repo/ubuntu18 bionic main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo apt-get update
sudo add-apt-repository universe
sudo apt-get install mariadb-columnstore*

After installation

After the installation completes, follow the configuration and startup steps in the Single-Node and Multi-Node Installation guides using the Non-Distributed Install feature.

MariaDB ColumnStore API (Bulk Write SDK) Package

Additional information on the ColumnStore API (Bulk Write SDK):

https://mariadb.com/kb/en/library/columnstore-bulk-write-sdk/

CentOS 7

Adding the MariaDB ColumnStore API YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-api.repo

[mariadb-columnstore-api]
name=MariaDB ColumnStore API
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Installing MariaDB ColumnStore API

With the repo file in place you can now install MariaDB ColumnStore API like so:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api*

MariaDB ColumnStore API C++

To install only the C++ part of the API use:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-cpp
sudo yum install mariadb-columnstore-api-cpp-devel

MariaDB ColumnStore API Java

To install only the Java part of the API use:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-java

MariaDB ColumnStore API Python 2

To install only the Python 2 part of the API use:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-python

MariaDB ColumnStore API Python 3

To install only the Python 3 part of the API use:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-python3

MariaDB ColumnStore API Spark

To install only the Spark part of the API, and the Scala ColumnStore Exporter library use:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-spark

MariaDB ColumnStore API PySpark

To install only the PySpark part of the API the Python ColumnStore exporter use:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-pyspark

MariaDB ColumnStore API PySpark 3

To install only the PySpark 3 part of the API the Python 3 ColumnStore exporter use:

sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-pyspark3

Debian 8

Adding the MariaDB ColumnStore API APT-GET repository

Install package:

sudo apt-get install apt-transport-https

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-api.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/debian8 jessie main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Add new file with repository information, /etc/apt/sources.list.d/debian-backports.list

deb http://httpredir.debian.org/debian jessie-backports main contrib non-free

Installing MariaDB ColumnStore API

With the repo file in place you can now install MariaDB ColumnStore API like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api*

MariaDB ColumnStore API C++

To install only the C++ part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-cpp
sudo apt-get install mariadb-columnstore-api-cpp-devel

MariaDB ColumnStore API Java

To install only the Java part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-java

MariaDB ColumnStore API Python 2

To install only the Python 2 part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python

MariaDB ColumnStore API Python 3

To install only the Python 3 part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python3

MariaDB ColumnStore API Spark

To install only the Spark part of the API, and the Scala ColumnStore Exporter library use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-spark

MariaDB ColumnStore API PySpark

To install only the PySpark part of the API the Python ColumnStore exporter use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark

MariaDB ColumnStore API PySpark 3

To install only the PySpark 3 part of the API the Python 3 ColumnStore exporter use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark3

Debian 9

Adding the MariaDB ColumnStore API APT-GET repository

Install package:

sudo apt-get install apt-transport-https dirmngr

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-api.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/debian9 stretch main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore API

With the repo file in place you can now install MariaDB ColumnStore API like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api*

MariaDB ColumnStore API C++

To install only the C++ part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-cpp
sudo apt-get install mariadb-columnstore-api-cpp-devel

MariaDB ColumnStore API Java

To install only the Java part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-java

MariaDB ColumnStore API Python 2

To install only the Python 2 part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python

MariaDB ColumnStore API Python 3

To install only the Python 3 part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python3

MariaDB ColumnStore API Spark

To install only the Spark part of the API, and the Scala ColumnStore Exporter library use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-spark

MariaDB ColumnStore API PySpark

To install only the PySpark part of the API the Python ColumnStore exporter use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark

MariaDB ColumnStore API PySpark 3

To install only the PySpark 3 part of the API the Python 3 ColumnStore exporter use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark3

Ubuntu 16

Adding the MariaDB ColumnStore API APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-api.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/ubuntu16 xenial main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Ubuntu 18

Adding the MariaDB ColumnStore API APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-api.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/repo/ubuntu18 bionic main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore API

With the repo file in place you can now install MariaDB ColumnStore API like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api*

MariaDB ColumnStore API C++

To install only the C++ part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-cpp
sudo apt-get install mariadb-columnstore-api-cpp-devel

MariaDB ColumnStore API Java

To install only the Java part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-java

MariaDB ColumnStore API Python 2

To install only the Python 2 part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python

MariaDB ColumnStore API Python 3

To install only the Python 3 part of the API use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python3

MariaDB ColumnStore API Spark

To install only the Spark part of the API, and the Scala ColumnStore Exporter library use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-spark

MariaDB ColumnStore API PySpark

To install only the PySpark part of the API the Python ColumnStore exporter use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark

MariaDB ColumnStore API PySpark 3

To install only the PySpark 3 part of the API the Python 3 ColumnStore exporter use:

sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark3

Windows 10

Install via MSI (Windows Installer)

http://downloads.mariadb.com/MariaDB/mariadb-columnstore-api/latest/winx64-packages/

MariaDB ColumnStore Tools Package

Additional information on the Backup and Restore Tool:

https://mariadb.com/kb/en/library/backup-and-restore-for-mariadb-columnstore-110-onwards/

Additional information on mcsimport:

https://mariadb.com/kb/en/library/columnstore-remote-bulk-data-import-mcsimport/

CentOS 6

Adding the MariaDB ColumnStore Tools YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-tools.repo

[mariadb-columnstore-tools]
name=MariaDB ColumnStore Tools
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/yum/centos/6/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Note: The CentOS 6 package of mariadb-columnstore-tools doesn't include mcsimport.

Installing MariaDB ColumnStore Tools

With the repo file in place you can now install MariaDB ColumnStore Tools like so:

sudo yum --enablerepo=mariadb-columnstore-tools clean metadata
sudo yum install mariadb-columnstore-tools

CentOS 7

Adding the MariaDB ColumnStore Tools YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-tools.repo

[mariadb-columnstore-tools]
name=MariaDB ColumnStore Tools
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Installing MariaDB ColumnStore Tools

With the repo file in place you can now install MariaDB ColumnStore Tools like so:

sudo yum --enablerepo=mariadb-columnstore-tools clean metadata
sudo yum install mariadb-columnstore-tools

Note: The CentOS 7 package of mariadb-columnstore-tools includes mcsimport which requires mariadb-columnstore-api-cpp and its repository.

SUSE 12

Adding the MariaDB ColumnStore Tools ZYPPER repository

Add new file with repository information, /etc/zypp/repos.d/mariadb-columnstore-tools.repo

[mariadb-columnstore-tools]
name=mariadb-columnstore-tools
enabled=1
autorefresh=0
baseurl=https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/yum/sles/12/x86_64
type=rpm-md

Download the MariaDB ColumnStore key

rpm --import https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key

Installing MariaDB ColumnStore

With the repo file in place you can now install MariaDB ColumnStore like so:

sudo zypper refresh
sudo zypper install mariadb-columnstore-tools

Note: The SUSE 12 package of mariadb-columnstore-tools doesn't include mcsimport.

Debian 8

Adding the MariaDB ColumnStore Tools APT-GET repository

Install package:

sudo apt-get install apt-transport-https

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/debian8 jessie main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore Tools

With the repo file in place you can now install MariaDB ColumnStore Tools like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-tools

Note: The Debian 8 package of mariadb-columnstore-tools includes mcsimport which requires mariadb-columnstore-api-cpp and its repository.

Debian 9

Adding the MariaDB ColumnStore Tools APT-GET repository

Install package:

sudo apt-get install apt-transport-https dirmngr

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/debian9 stretch main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore Tools

With the repo file in place you can now install MariaDB ColumnStore Tools like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-tools

Note: The Debian 9 package of mariadb-columnstore-tools includes mcsimport which requires mariadb-columnstore-api-cpp and its repository.

Ubuntu 16

Adding the MariaDB ColumnStore Tools APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/ubuntu16 xenial main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Ubuntu 18

Adding the MariaDB ColumnStore Tools APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-tools.list

deb https://downloads.mariadb.com/MariaDB/mariadb-columnstore-tools/latest/repo/ubuntu18 bionic main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore Tools

With the repo file in place you can now install MariaDB ColumnStore Tools like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-tools

Note: The Ubuntu 16 and 18 packages of mariadb-columnstore-tools include mcsimport which requires mariadb-columnstore-api-cpp and its repository.

Windows 10

Install via MSI (Windows Installer)

http://downloads.mariadb.com/ColumnStore-Tools/latest/winx64-packages/

MariaDB MaxScale Packages

CentOS 6

Adding the MariaDB MaxScale YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-maxscale.repo

[mariadb-maxscale]
name=MariaDB MaxScale
baseurl=https://downloads.mariadb.com/MaxScale/latest/centos/6/x86_64
gpgkey=https://downloads.mariadb.com/MaxScale/MariaDB-MaxScale-GPG-KEY
gpgcheck=1

Installing MariaDB MaxScale

With the repo file in place you can now install MariaDB MaxScale like so:

You can also install this way:

sudo yum --enablerepo=mariadb-maxscale clean metadata
sudo yum install maxscale maxscale-cdc-connector

CentOS 7

Adding the MariaDB MaxScale YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-maxscale.repo

[mariadb-maxscale]
name=MariaDB MaxScale
baseurl=https://downloads.mariadb.com/MaxScale/latest/centos/7/x86_64
gpgkey=https://downloads.mariadb.com/MaxScale/MariaDB-MaxScale-GPG-KEY
gpgcheck=1

Installing MariaDB MaxScale

You can also install this way:

sudo yum --enablerepo=mariadb-maxscale clean metadata
sudo yum install maxscale maxscale-cdc-connector

SUSE 12

Adding the MariaDB MaxScale ZYPPER repository

Add new file with repository information, /etc/zypp/repos.d/mariadb-maxscale.repo

[mariadb-maxscale]
name=mariadb-maxscale
enabled=1
autorefresh=0
baseurl=https://downloads.mariadb.com/MaxScale/latest/sles/12/x86_64
type=rpm-md

Download the MariaDB MaxScale key

rpm --import https://downloads.mariadb.com/MaxScale/MariaDB-MaxScale-GPG-KEY

Installing MariaDB MaxScale

With the repo file in place you can now install MariaDB MaxScale like so:

sudo zypper refresh
sudo zypper install maxscale maxscale-cdc-connector

Debian 8

Adding the MariaDB MaxScale APT-GET repository

Install package:

sudo apt-get install apt-transport-https

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/debian jessie main

Download the MariaDB MaxScale key

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Installing MariaDB MaxScale

Additional information on setting to Maxscale:

https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-14/mariadb-maxscale-installation-guide/

With the repo file in place you can now install MariaDB MaxScale like so:

sudo apt-get update
sudo apt-get install maxscale maxscale-cdc-connector

Debian 9

Adding the MariaDB MaxScale APT-GET repository

Install package:

sudo apt-get install apt-transport-https dirmngr

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/debian stretch main

Download the MariaDB MaxScale key

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Installing MariaDB MaxScale

With the repo file in place you can now install MariaDB MaxScale like so:

sudo apt-get update
sudo apt-get install maxscale maxscale-cdc-connector

Ubuntu 16

Adding the MariaDB MaxScale APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/ubuntu xenial main

Download the MariaDB MaxScale key

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Ubuntu 18

Adding the MariaDB MaxScale APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariadb-maxscale.list

deb https://downloads.mariadb.com/MaxScale/latest/ubuntu bionic main

Download the MariaDB MaxScale key

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 28C12247

Installing MariaDB MaxScale

With the repo file in place you can now install MariaDB MaxScale like so:

sudo apt-get update
sudo apt-get install maxscale maxscale-cdc-connector

MariaDB Connector Packages

ODBC Connector

Additional Information on the ODBC connector:

https://mariadb.com/kb/en/library/mariadb-connector-odbc/

How to Install the ODBC Connector:

https://mariadb.com/kb/en/library/about-mariadb-connector-odbc/

Java Connector

Additional information on the Java Connector:

https://mariadb.com/kb/en/library/mariadb-connector-j/

How to Install the Java Connector:

https://mariadb.com/kb/en/library/getting-started-with-the-java-connector/

MariaDB ColumnStore Data Adapters Packages

Additional information on the Data Adapters:

https://mariadb.com/kb/en/library/columnstore-streaming-data-adapters/

NOTE: MaxScale CDC Connector requires the MariaDB MaxScale package be installed first.

The MariaDB ColumnStore Data Adapters Packages are:

  • Kafka Adapters
  • Maxscale CDC Adapters

Kafka install package dependencies:

  • N/A

Maxscale CDC install package dependencies::

  • MaxScale CDC Connector
  • MariaDB ColumnStore API
  • MariaDB MaxScale

CentOS 7

Adding the MariaDB ColumnStore Data Adapters YUM repository

Add new file with repository information, /etc/yum.repos.d/mariadb-columnstore-data-adapters.repo

[mariadb-columnstore-data-adapters]
name=MariaDB ColumnStore Data Adapters
baseurl=https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/yum/centos/7/x86_64/
gpgkey=https://downloads.mariadb.com/MariaDB/mariadb-columnstore/RPM-GPG-KEY-MariaDB-ColumnStore
gpgcheck=1

Installing MariaDB ColumnStore Data Adapters

With the repo file in place you can now install MariaDB ColumnStore Maxscale CDC Data Adapters like so:

sudo yum --enablerepo=mariadb-columnstore-data-adapters clean metadata
sudo yum install mariadb-columnstore-data-adapters-maxscale-cdc-adapter

With the repo file in place you can now install MariaDB ColumnStore Kafka Data Adapters like so:

sudo yum --enablerepo=mariadb-columnstore-data-adapters clean metadata
sudo yum install mariadb-columnstore-data-adapters-avro-kafka-adapter

Debian 8

Adding the MariaDB ColumnStore Data Adapters APT-GET repository

Install package:

sudo apt-get install apt-transport-https

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-data-adapters.list

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/debian8 jessie main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore Data Adapters

With the repo file in place you can now install MariaDB ColumnStore Maxscale CDC Data Adapters like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters

With the repo file in place you can now install MariaDB ColumnStore Kafka Data Adapters like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-kafka-avro-adapters

Debian 9

Adding the MariaDB ColumnStore Data Adapters APT-GET repository

Install package:

sudo apt-get install apt-transport-https dirmngr

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-data-adapters.list

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/debian9 stretch main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore Data Adapters

With the repo file in place you can now install MariaDB ColumnStores Maxscale CDC Data Adapters like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters

With the repo file in place you can now install MariaDB ColumnStores Kafka Data Adapters like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-kafka-avro-adapters

Ubuntu 16

Adding the MariaDB ColumnStore Data Adapters APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-data-adapters.list

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/ubuntu16 xenial main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Ubuntu 18

Adding the MariaDB ColumnStore Data Adapters APT-GET repository

Add new file with repository information, /etc/apt/sources.list.d/mariab-columnstore-data-adapters.list

deb https://downloads.mariadb.com/MariaDB/data-adapters/mariadb-streaming-data-adapters/latest/repo/ubuntu18 bionic main

Download the MariaDB ColumnStore key

wget -qO - https://downloads.mariadb.com/MariaDB/mariadb-columnstore/MariaDB-ColumnStore.gpg.key | sudo apt-key add -

Installing MariaDB ColumnStore Data Adapters

With the repo file in place you can now install MariaDB ColumnStore Maxscale CDC Data Adapters like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters

With the repo file in place you can now install MariaDB ColumnStore Kafka Data Adapters like so:

sudo apt-get update
sudo apt-get install mariadb-columnstore-kafka-avro-adapters
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/installing-mariadb-ax-mariadb-columnstore-from-the-package-repositories-12x/