Upgrade Mariadb 5.5 to Mariadb 10.2 on Centos 7 VestaCP

by Sandy

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 :

# 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

Donate with Paytm :

md-donate

You may also like

2
Leave a Reply

avatar
2 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
2 Comment authors
EpsilonionStuart De Usoz Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Stuart De Usoz
Guest
Stuart De Usoz

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

Epsilonion
Guest

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