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

Revision: 80554
User: Jens Röwekamp
Date: 2019-02-08 06:01

<<toc title='' depth=2 layout=standalone>>

= 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

<<code>>
[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
<</code>>

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

<<code>>
[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
<</code>>

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

<<code>>
[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
<</code>>

=== Installing MariaDB AX

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

== CentOS 7

=== Adding the MariaDB AX YUM repository

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

<<code>>
[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
<</code>>

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

<<code>>
[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
<</code>>

=== Adding the MariaDB ColumnStore Tools YUM repository

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

<<code>>
[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
<</code>>

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

<<code>>
[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
<</code>>

=== Adding the MariaDB ColumnStore Data Adapters YUM repository

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

<<code>>
[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
<</code>>

=== Installing MariaDB AX

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

<<code>>
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
<</code>>

== SUSE 12

=== Adding the MariaDB ColumnStore ZYPPER repository

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

<<code>>
[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
<</code>>

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

<<code>>
[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
<</code>>

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

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

Download the MariaDB ColumnStore and MaxScale keys

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

=== Installing MariaDB ColumnStore

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

<<code>>
sudo zypper refresh
sudo zypper install mariadb-columnstore*
sudo zypper install mariadb-columnstore-tools
sudo zypper install maxscale maxscale-cdc-connector
<</code>>

== Debian 8

=== Adding the MariaDB ColumnStore APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https
<</code>>

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

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

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

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

Add new file with repository information, /etc/apt/sources.list.d/debian-backports.list
<<code>>
deb http://httpredir.debian.org/debian jessie-backports main contrib non-free
<</code>>

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

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

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

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

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

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

Download the MariaDB ColumnStore key

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

Download the MariaDB MaxScale key

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

=== Installing MariaDB ColumnStore

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

<<code>>
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
<</code>>

== Debian 9

=== Adding the MariaDB ColumnStore APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https dirmngr
<</code>>

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

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

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

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

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

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

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

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

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

Download the MariaDB ColumnStore key

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

Download the MariaDB MaxScale key

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

=== Installing MariaDB ColumnStore

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

== Ubuntu 16

=== Adding the MariaDB ColumnStore APT-GET repository

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

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

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

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

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

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

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

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

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

Download the MariaDB ColumnStore key

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

Download the MariaDB MaxScale key

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

=== Installing MariaDB ColumnStore

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

== Ubuntu 18

=== Adding the MariaDB ColumnStore APT-GET repository

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

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

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

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

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

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

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

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

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

Download the MariaDB ColumnStore key

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

Download the MariaDB MaxScale key

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

=== Installing MariaDB ColumnStore

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

<<code>>
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
<</code>>

= 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

=== Installing MariaDB ColumnStore

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

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

You can also install this way:

<<code>>
sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum install mariadb-columnstore*
<</code>>

== CentOS 7

=== Adding the MariaDB ColumnStore YUM repository

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

=== Installing MariaDB ColumnStore

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

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

You can also install this way:

<<code>>
sudo yum --enablerepo=mariadb-columnstore clean metadata
sudo yum install mariadb-columnstore*
<</code>>

== SUSE 12

=== Adding the MariaDB ColumnStore ZYPPER repository

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

<<code>>
[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
<</code>>

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore

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

<<code>>
sudo zypper refresh
sudo zypper install mariadb-columnstore*
<</code>>

== Debian 8

=== Adding the MariaDB ColumnStore APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https
<</code>>

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore*
<</code>>

== Debian 9

=== Adding the MariaDB ColumnStore APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https dirmngr
<</code>>

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore*
<</code>>

== Ubuntu 16

=== Adding the MariaDB ColumnStore APT-GET repository

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore*
<</code>>

== Ubuntu 18

=== Adding the MariaDB ColumnStore APT-GET repository

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore

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

<<code>>
sudo apt-get update
sudo add-apt-repository universe
sudo apt-get install mariadb-columnstore*
<</code>>

=== After installation

After the installation completes, follow the configuration and startup steps in the Single-Node and Multi-Node Installation guides using the [[https://mariadb.com/kb/en/library/installing-and-configuring-a-multi-server-columnstore-system-11x/#non-distributed-install|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

=== Installing MariaDB ColumnStore API

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

<<code>>
sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api*
<</code>>

==== MariaDB ColumnStore API C++

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

<<code>>
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
<</code>>

==== MariaDB ColumnStore API Java

To install only the Java part of the API use:

<<code>>
sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-java
<</code>>

==== MariaDB ColumnStore API Python 2

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

<<code>>
sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-python
<</code>>

==== MariaDB ColumnStore API Python 3

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

<<code>>
sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-python3
<</code>>

==== MariaDB ColumnStore API Spark

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

<<code>>
sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-spark
<</code>>

==== MariaDB ColumnStore API PySpark

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

<<code>>
sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-pyspark
<</code>>

==== MariaDB ColumnStore API PySpark 3

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

<<code>>
sudo yum install epel-release
sudo yum --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api-pyspark3
<</code>>

== Debian 8

=== Adding the MariaDB ColumnStore API APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https
<</code>>

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

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

Download the MariaDB ColumnStore key

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

Add new file with repository information, /etc/apt/sources.list.d/debian-backports.list
<<code>>
deb http://httpredir.debian.org/debian jessie-backports main contrib non-free
<</code>>

=== Installing MariaDB ColumnStore API

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api*
<</code>>

==== MariaDB ColumnStore API C++

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-cpp
sudo apt-get install mariadb-columnstore-api-cpp-devel
<</code>>

==== MariaDB ColumnStore API Java

To install only the Java part of the API use:

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-java
<</code>>

==== MariaDB ColumnStore API Python 2

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python
<</code>>

==== MariaDB ColumnStore API Python 3

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python3
<</code>>

==== MariaDB ColumnStore API Spark

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-spark
<</code>>

==== MariaDB ColumnStore API PySpark

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark
<</code>>

==== MariaDB ColumnStore API PySpark 3

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark3
<</code>>

== Debian 9

=== Adding the MariaDB ColumnStore API APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https dirmngr
<</code>>

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore API

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api*
<</code>>

==== MariaDB ColumnStore API C++

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-cpp
sudo apt-get install mariadb-columnstore-api-cpp-devel
<</code>>

==== MariaDB ColumnStore API Java

To install only the Java part of the API use:

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-java
<</code>>

==== MariaDB ColumnStore API Python 2

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python
<</code>>

==== MariaDB ColumnStore API Python 3

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python3
<</code>>

==== MariaDB ColumnStore API Spark

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-spark
<</code>>

==== MariaDB ColumnStore API PySpark

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark
<</code>>

==== MariaDB ColumnStore API PySpark 3

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark3
<</code>>

== 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

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

Download the MariaDB ColumnStore key

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

== 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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore API

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api*
<</code>>

==== MariaDB ColumnStore API C++

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-cpp
sudo apt-get install mariadb-columnstore-api-cpp-devel
<</code>>

==== MariaDB ColumnStore API Java

To install only the Java part of the API use:

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-java
<</code>>

==== MariaDB ColumnStore API Python 2

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python
<</code>>

==== MariaDB ColumnStore API Python 3

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-python3
<</code>>

==== MariaDB ColumnStore API Spark

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-spark
<</code>>

==== MariaDB ColumnStore API PySpark

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark
<</code>>

==== MariaDB ColumnStore API PySpark 3

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-api-pyspark3
<</code>>

== 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

**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:

<<code>>
sudo yum --enablerepo=mariadb-columnstore-tools clean metadata
sudo yum install mariadb-columnstore-tools
<</code>>

== CentOS 7

=== Adding the MariaDB ColumnStore Tools YUM repository

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

<<code>>
[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
<</code>>

=== Installing MariaDB ColumnStore Tools

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

<<code>>
sudo yum --enablerepo=mariadb-columnstore-tools clean metadata
sudo yum install mariadb-columnstore-tools
<</code>>

**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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore

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

<<code>>
sudo zypper refresh
sudo zypper install mariadb-columnstore-tools
<</code>>

**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:

<<code>>
sudo apt-get install apt-transport-https
<</code>>

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore Tools

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-tools
<</code>>

**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:

<<code>>
sudo apt-get install apt-transport-https dirmngr
<</code>>

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore Tools

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-tools
<</code>>

**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

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

Download the MariaDB ColumnStore key

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

== 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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore Tools

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-tools
<</code>>

**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

=== Installing MariaDB MaxScale

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

You can also install this way:

<<code>>
sudo yum --enablerepo=mariadb-maxscale clean metadata
sudo yum install maxscale maxscale-cdc-connector
<</code>>

== CentOS 7

=== Adding the MariaDB MaxScale YUM repository

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

=== Installing MariaDB MaxScale

You can also install this way:

<<code>>
sudo yum --enablerepo=mariadb-maxscale clean metadata
sudo yum install maxscale maxscale-cdc-connector
<</code>>

== SUSE 12

=== Adding the MariaDB MaxScale ZYPPER repository

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

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

Download the MariaDB MaxScale key

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

=== Installing MariaDB MaxScale

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

<<code>>
sudo zypper refresh
sudo zypper install maxscale maxscale-cdc-connector
<</code>>

== Debian 8

=== Adding the MariaDB MaxScale APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https
<</code>>

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

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

Download the MariaDB MaxScale key

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

=== 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:

<<code>>
sudo apt-get update
sudo apt-get install maxscale maxscale-cdc-connector
<</code>>

== Debian 9

=== Adding the MariaDB MaxScale APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https dirmngr
<</code>>

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

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

Download the MariaDB MaxScale key

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

=== Installing MariaDB MaxScale

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

<<code>>
sudo apt-get update
sudo apt-get install maxscale maxscale-cdc-connector
<</code>>

== Ubuntu 16

=== Adding the MariaDB MaxScale APT-GET repository

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

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

Download the MariaDB MaxScale key

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

== Ubuntu 18

=== Adding the MariaDB MaxScale APT-GET repository

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

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

Download the MariaDB MaxScale key

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

=== Installing MariaDB MaxScale

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

<<code>>
sudo apt-get update
sudo apt-get install maxscale maxscale-cdc-connector
<</code>>

= 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

=== Installing MariaDB ColumnStore Data Adapters

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

<<code>>
sudo yum --enablerepo=mariadb-columnstore-data-adapters clean metadata
sudo yum install mariadb-columnstore-data-adapters-maxscale-cdc-adapter
<</code>>

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

<<code>>
sudo yum --enablerepo=mariadb-columnstore-data-adapters clean metadata
sudo yum install mariadb-columnstore-data-adapters-avro-kafka-adapter
<</code>>

== Debian 8

=== Adding the MariaDB ColumnStore Data Adapters APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https
<</code>>

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore Data Adapters

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters
<</code>>

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-kafka-avro-adapters
<</code>>

== Debian 9

=== Adding the MariaDB ColumnStore Data Adapters APT-GET repository

Install  package:

<<code>>
sudo apt-get install apt-transport-https dirmngr
<</code>>

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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore Data Adapters

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters
<</code>>

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-kafka-avro-adapters
<</code>>

== 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

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

Download the MariaDB ColumnStore key

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

== 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

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

Download the MariaDB ColumnStore key

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

=== Installing MariaDB ColumnStore Data Adapters

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-maxscale-cdc-adapters
<</code>>

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

<<code>>
sudo apt-get update
sudo apt-get install mariadb-columnstore-kafka-avro-adapters
<</code>>

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.

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

Products

Services

Pricing

Resources

About Us

Download MariaDB