The suggested upgrade procedure is:

Shutdown and uninstallMariaDB 5.5
Take a backup (this is the perfect time to take a backup of your databases)
InstallMariaDB 10.0[1]
Runmysql_upgrade
- Ubuntu and Debian packages do this automatically when they are installed; Red Hat,CentOS,and Fedora packages do not
- MysqL_upgradedoes two things:
  1. Upgrades the permission tables in theMysqLdatabase with some new fields
  2. Does a very quick check of all tables and marks them as compatible withMariaDB 10.0
- In most cases this should be a fast operation (depending of course on the number of tables)
Add new options tomy.cnfto enable features
- If you changemy.cnfthen you need to restartMysqLd
@H_301_54@

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.

Pre-Flight Check @H_301_54@

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

Step #1: Add the MariaDB Repository @H_301_54@

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 theMariaDB 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/centos7-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 @H_301_54@

Be sure to backup MariaDB and/or your entire serverbefore proceeding with the following instructions! @H_301_54@

Removing MariaDB will remove services that depend on MariaDB! @H_301_54@

Stop MariaDB:

systemctl stop mariadb

Remove the existing MariaDB packages:

yum remove mariadb-server mariadb mariadb-libs

Clean-up the repository cache information with the following command:

yum clean all

Step #3: Install MariaDB 10.0 @H_301_54@

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)]>