MariaDB – Installation

All downloads for MariaDB are located in the Download section of the official MariaDB foundation website. Click the link to the version you would like, and a list of downloads for multiple operating systems, architectures, and installation file types is displayed.

Installing on LINUX/UNIX

If you have intimate knowledge of Linux/Unix systems, simply download the source to build your install. Our recommended way of installing is to utilize distribution packages. MariaDB offers packages for the following Linux/Unix distributions −

  • RedHat/CentOS/Fedora
  • Debian/Ubuntu

The following distributions include a MariaDB package in their repositories −

  • openSUSE
  • Arch Linux
  • Mageia
  • Mint
  • Slackware

Follow these steps to install in an Ubuntu environment −

Step 1 − Login as a root user.

Step 2 − Navigate to the directory containing the MariaDB package.

Step 3 − Import the GnuPG signing key with the following code −

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db

Step 4 − Add MariaDB to the sources. list file. Open the file, and add the following code −

sudo add-apt-repository 'deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntuprecise main'

Step 5 − Refresh the system with the following −

sudo apt-get update

Step 6 − Install MariaDB with the following −

sudo apt-get install mariadb-server

Installing on Windows

After locating and downloading an automated install file (MSI), simply double-click the file to start the installation. The installation wizard will walk you through every step of installation and any necessary settings.

Test the installation by starting it from the command prompt. Navigate to the location of the installation, typically in the directory, and type the following at the prompt −

mysqld.exe --console

If the installation is successful, you will see messages related to startup. If this does not appear, you may have permission issues. Ensure that your user account can access the application. Graphical clients are available for MariaDB administration in the Windows environment. If you find the command line uncomfortable or cumbersome, be sure to experiment with them.

Testing the Installation

Perform a few simple tasks to confirm the functioning and installation of MariaDB.

Use the Admin Utility to Get Server Status

View the server version with the Mysql admin binary.

[root@host]# mysqladmin --version

It should display the version, distribution, operating system, and architecture. If you do not see the output of that type, examine your installation for issues.

Execute Simple Commands with a Client

Bring up the command prompt for MariaDB. This should connect you to MariaDB and allow the execution of commands. Enter a simple command as follows −

mysql> SHOW DATABASES;

Post- Installation

After successful installation of MariaDB, set a root password. A fresh install will have a blank password. Enter the following to set the new password −

mysqladmin -u root password "[enter your password here]";

Enter the following to connect to the server with your new credentials −

mysql -u root -p
Enter password:*******

Upgrading on Windows

If you already have MySQL installed on your Windows system, and want to upgrade to MariaDB; do not uninstall MySQL and install MariaDB. This will cause a conflict with the existing database. You must instead install MariaDB, and then use the upgrade wizard in the Windows installation file.

The options of your MySQL my.cnf file should work with MariaDB. However, MariaDB has many features, which are not found in MySQL.

Consider the following conflicts in your my.cnf file −

  • MariaDB uses Aria storage engine by default for temporary files. If you have a lot of temporary files, modify key buffer size if you do not use MyISAM tables.
  • If your applications connect/disconnect frequently, alter the thread cache size.
  • If you use over 100 connections, use the thread pool.

Compatibility

MySQL and MariaDB are essentially identical. However, there are enough differences to create issues in degradation. Review more of these key differences in the MariaDB Knowledge Base.

Leave a Reply