article-preview

Installing MariaDB .deb

Using the MariaDB Package Repository Setup Script

If you want to install MariaDB with apt, then you can configure apt to install from MariaDB Corporation's MariaDB Package Repository by using the MariaDB Package Repository setup script.

article-preview

Installing MariaDB with zipper

On SLES, OpenSUSE, and other similar Linux distributions, it is highly recommended to install the relevant RPM packages from MariaDB's repository using zypper.

This page walks you through the simple installation steps using zypper.

article-preview

From MariaDB - MariaDB Installation (Version 10.1.21) via RPMs on CentOS 7

Here are the detailed steps for installing MariaDB (version 10.1.21) via RPMs on CentOS 7.

The RPM's needed for the installation are all available on the MariaDB website and are given below:

jemalloc-3.6.0-1.el7.x86_64.rpm

MariaDB-10.1.21-centos7-x86_64-client.rpm

MariaDB-10.1.21-centos7-x86_64-compat.rpm

galera-25.3.19-1.rhel7.el7.centos.x86_64.rpm

jemalloc-devel-3.6.0-1.el7.x86_64.rpm

MariaDB-10.1.21-centos7-x86_64-common.rpm

MariaDB-10.1.21-centos7-x86_64-server.rpm

article-preview

Storage Engines Supported

MariaDB starting with  10.3.7

In MariaDB 10.3.7 and later, the InnoDB implementation has diverged substantially from the InnoDB in MySQL. Therefore, in these versions, the InnoDB version is no longer associated with a MySQL release version.

MariaDB starting with 10.2

In MariaDB 10.2  and later, the default InnoDB implementation is based on InnoDB from MySQL 5.7. See  Why MariaDB uses InnoDB instead of XtraDB from MariaDB 10.2  for more information.

article-preview

Installing MariaDB with yum/dnf

On RHEL, CentOS, Fedora, and other similar Linux distributions, it is highly recommended to install the relevant RPM packages from MariaDB's repository using yum or dnf. Starting with RHEL 8 and Fedora 22, yum has been replaced by dnf, which is the next major version of yum. However, yum commands still work on many systems that use dnf.

This page walks you through the simple installation steps using yum.

article-preview

Choosing the Right Storage Engine

  • InnoDB is a good general transaction storage engine, and, from MariaDB 10.2, the best choice in most cases. It is the default storage engine from MariaDB 10.2. For earlier releases, XtraDB was a performance enhanced fork of InnoDB and is usually preferred.
  • XtraDB is the best choice in MariaDB 10.1 and earlier in the majority of cases. It is a performance-enhanced fork of InnoDB and is MariaDB's default engine until MariaDB 10.1.
  • Aria, MariaDB's more modern improvement on MyISAM, has a small footprint and allows for easy copying between systems.
  • MyISAM has a small footprint and allows for easy copying between systems. MyISAM is MySQL's oldest storage engine. There is usually little reason to use it except for legacy purposes. Aria is MariaDB's more modern improvement.

article-preview

Installing MariaDB With the rpm Tool

This article describes how to download the RPM files and install them using the rpm command.

It is highly recommended to Install MariaDB with yum where possible.

Navigate to http://downloads.mariadb.org and choose the desired database version and then select the RPMs that match your Linux distribution and architecture.

article-preview

MariaDB RPM Files

Preferably, you should install MariaDB RPM packages using the package manager of your Linux distribution, for example yum or zypper. But you can also use the lower-level rpm tool.

A PHP Error was encountered

Severity: Core Warning

Message: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/monarxprotect-php56.so' - /usr/lib64/php/modules/monarxprotect-php56.so: undefined symbol: zend_is_auto_global_str

Filename: Unknown

Line Number: 0

Backtrace: