The Ultimate Guide to High Availability with MariaDB

Installing MariaDB AX from the Package Repositories

You are viewing an old version of this article. View the current version here.
  1. Introduction
  2. MariaDB ColumnStore Packages
    1. CentOS 6
    2. CentOS 7
    3. SUSE 12
    4. Debian 8
    5. Debian 9
    6. Ubuntu 16
    7. After installation
  3. MariaDB ColumnStore API (Bulk Write SDK) Package
    1. CentOS 7
    2. Debian 8
    3. Debian 9
    4. Ubuntu 16
  4. MariaDB ColumnStore Tools Package
    1. CentOS 6
    2. CentOS 7
    3. Debian 8
    4. Debian 9
    5. Ubuntu 16
  5. MariaDB MaxScale Packages
    1. CentOS 6
    2. CentOS 7
    3. SUSE 12
    4. Debian 8
    5. Debian 9
    6. Ubuntu 16
  6. MariaDB Connector Packages
    1. ODBC Connector
    2. Java Connector
  7. MariaDB ColumnStore Data Adapters Packages
    1. CentOS 7
    2. Debian 8
    3. Debian 9
    4. Ubuntu 16

Introduction

Installing MariaDB AX 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 MariaDB AX 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.

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

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*

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 --enablerepo=mariadb-columnstore-api clean metadata
sudo yum install mariadb-columnstore-api

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 -

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

Debian 9

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

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 -

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 Tools Package

Additional information on the Backup and Restore Tool:

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

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

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

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

Debian 9

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

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 -

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

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

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

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 mariadb-maxscale

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 mariadb-maxscale

Debian 9

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 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 mariadb-maxscale

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

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 mariadb-maxscale

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 CSC install package dependencies::

  • MaxScale CDC Connector
  • MariaDB ColumnStore API

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-maxscale-cdc-adapters

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-kafka-adapters

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

Debian 9

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

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

Comments

Comments loading...
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.