How to Upgrade MariaDB 5.5 to MariaDB 10.0 on Fedora 20

MariaDB is a drop-in replacement for MySQL installed by default on CentOS 7, and offers many speed and performance improvements. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Requirements

• These instructions are intended for upgrading from MariaDB 5.5 to MariaDB 10.0 on Fedora 20.
• I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.

Step #1: Add the MariaDB Repository

First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.

yum -y update

Now find which repo you should use with the MariaDB repository generator. We’re going to add the CentOS 7 (64 bit) MariaDB 10.0 repository.

For a refresher on editing files with vim see: New User Tutorial: Overview of the Vim Text Editor.

vim /etc/yum.repos.d/MariaDB10.repo

# MariaDB 10.0 CentOS repository list – created 2014-10-13 13:04 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb] name = MariaDB
baseurl = http://yum.mariadb.org/10.0/fedora20-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Then exit and save the file with the command :wq.

Step #2: Remove the Existing MariaDB Installation

Be sure to backup MariaDB before proceeding with the following instructions!

Stop MariaDB.

systemctl stop mariadb

Remove the existing MariaDB packages.

yum -y remove mariadb-server mariadb mariadb-libs

Step #3: Install MariaDB 10.0

At this point, installing MariaDB 10.0 is as simple as running just one command.

yum -y install MariaDB-server MariaDB-client

And then start MariaDB again.

systemctl start mysql

Be sure that MariaDB is set to start at boot.

systemctl enable mysql

Run mysql_upgrade.

mysql_upgrade

Verify MySQL is now MariaDB by using the command client.

mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.0.14-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>