Upgrade Mysql 5.7 to MariaDB 10.2 on CentOS7

In this article, I’m going to upgrade Mysql5.7 to Mariadb 10.2 on CentOs7 system. This is a simple procedure that yoyu can easly follow.

Login as root user in to your system through SSH.

You can get the current mysql version by running following command.

#  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 will get following as output.

mysql Ver 15.1 Distrib 10.2.23-MariaDB, for Linux (x86_64) using readline 5.1