Upgrade Mariadb 5.5 to Mariadb 10.2 on Centos 7 VestaCP

In this tutorial we’ll upgrade/install to Mariadb 10.2 on Centos 7 running Vesta CP, by default vesta cp will install old base version of Mariadb 5.5 when installing on Centos 7. This tutorial will also work without vestacp installed. MariaDB is designed as a drop-in replacement of MySQL with more features, new storage engines, fewer bugs, and better performance. MariaDB is developed by many of the original developers of MySQL who now work for the MariaDB Foundation and the MariaDB Corporation, and by many people in the community. To upgrade follow this simple steps to upgrade it to latest version.

Update/Upgrade to MariaDB 10.3 on VestaCP/CWP/CentOS 7

Step 1

Before installing it is recommended to backup your databases, although it is not necessary if you followed this steps carefully. Now we need to remove current version of mariadb 5.5 installed on centos 7 :

service mariadb stop  /  service mysql stop
yum remove mariadb mariadb-server

at this point mariadb 5.5 will be removed completely but the databases are not removed don’t need to worry. Now we’ll navigate to Mariadb 10.2 installation :

Step 2

Install/enable Official repo for mariadb 10.2 :

yum install nano epel-release -y

Now edit/create the file :

nano /etc/yum.repos.d/mariadb.repo

then paste this lines and save it  (Remove any entries from mariadb.repo before pasting below if any):

# MariaDB 10.2 CentOS repository list - created 2018-02-15 08:21 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

After that we’ll install Mariadb 10.2

yum install MariaDB-server MariaDB-client -y

Then enable mariadb to start on boot and start the service :

systemctl enable mysql
service mysql start

Step 3

After that we need to upgrade current databases by this command :

mysql_upgrade

that’s it you’ve successfully upgraded mariadb 5.5 to mariadb 10.2.