Upgrade Mariadb 5.5 to Mariadb 10.2 on Centos 7 VestaCP 1
Linux,  VestaCP

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.

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 mariadb // or 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.
Avatar of jamesblackvn

Tui là jamesblackvn!

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Website này sử dụng Akismet để hạn chế spam. Tìm hiểu bình luận của bạn được duyệt như thế nào.