Upgrade MariaDB from 5.x to 10.2

If you need to upgrade your MariaDB 5.x toa 10.2 version here are the spteps how to do it for CentOS 7:

#  mysql -V

Now follow the below steps one by one to upgrade to Mariadb10.2

1. Stop mysql service

#  systemctl stop mysql

2. Take the backup of databases.

Be sure to backup MySQL before upgradation process with the following instructions!

# cp -apf /var/lib/mysql /var/lib/mysql_backup
#  mysqldump --all-databases > all_databases.sql

3. Remove the existing mysql package from the system.

#  yum -y remove mysql-server mysql-client

4. Add MariaDB repository.

# vi  /etc/yum.repos.d/MariaDB.repo 

And copy the following line to the repsitory file.

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

:wq!  (save and exit)

Install MariaDB10.

Installation of MariaDB can be done by following simple step.

# yum -y install MariaDB-server MariaDB-client 

Start MariaDB service.

# systemctl start mariadb.service
# systemctl enable mariadb.service

Run mysql upgrade command

 # mysql_upgrade

You have succesfully upgraded to mariadb10 and you can verify it by running following command

# mysql -V

You should get oputput like this:

Server version: 10.2.27-MariaDB MariaDB Server