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