Upgrade Mariadb 5.5 to Mariadb 10.2 on Centos 7 VestaCP

by Sandeep B.

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.

If this post helps you in any way please consider a donation

Donate with PayPal :

md-donate

You may also like

2 comments

Stuart De Usoz September 10, 2019 - 12:52 pm

Note that if you had already secured mysql (for my case anyway) I needed to upgrade with
mysql_upgrade -u root -p

Reply
Epsilonion September 17, 2019 - 1:23 pm

Always make a back up
# mysqldump -u root -ppassword –all-databases > /tmp/all-database.sql

Reply

Leave a Comment