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.
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 :
Install/enable Official repo for mariadb 10.2 :
yum install nano epel-release -y
Now edit/create the file :
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
After that we need to upgrade current databases by this command :
that’s it you’ve successfully upgraded mariadb 5.5 to mariadb 10.2.