How to Upgrade MariaDB 5.5 to MariaDB 10.0 on CentOS 7

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.

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


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


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

yum clean all


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

  • 62 Users Found This Useful
Was this answer helpful?

Related Articles

How to List Compiled PHP Modules from Command Line

Pre-Flight Check These instructions are intended specifically for listing compiled PHP modules...

How to Install or Uninstall PECL Extensions

Pre-Flight Check These instructions are intended specifically for installing or uninstalling...

How to Install the MongoDB PHP Driver (Extension) on CentOS 6

Step 1: Setup Environment, Install PHP Extension & Application Repository (PEAR) As a matter...

How to Add a User and Grant Root Privileges on CentOS 6.5

Step 1: Add the User It’s just one simple command to add a user. In this case, we’re...

How to Add a User and Grant Root Privileges on Ubuntu 14.04

Step 1: Add the User It’s just one simple command to add a user. In this case, we’re...

Powered by WHMCompleteSolution