Let us check how to upgrade/install MariaDB to latest Mariadb10.4 on Centos 7 this tutorial will also work with CWP and VestaCP or any other compatible control panel.

 

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 these simple steps to upgrade it to the latest version:

 

Step 1: Remove MariaDB 5.5/10.0/10.1/10.2/10.3

 

Before installing it is recommended to backup your databases, although it is not necessary if you followed these steps carefully.

 

First backup your current my.cnf config:

cp /etc/my.cnf /etc/my.cnf.bak

 

For MariaDB 5.5:

service mariadb stop  /  service mysql stop
rpm -e --nodeps galera
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.

 

For MariaDB 10.0/10.1/10.2/10.3:

service mysql stop 
rpm -e --nodeps galera
yum remove MariaDB-server MariaDB-client

 

At this point, MariaDB 10.0/10.1/10.2/10.3 will be removed completely but the databases are not removed don’t need to worry.

 

Then Install MariaDB 10.4.

 

Step 2: Installation/Updating

 

Installation/Updating from MariaDB 5.5/10.0/10.1/10.2/10.3 to MariaDB 10.4

 

Install/enable Official repo for mariadb 10.4:

yum install nano epel-release -y

 

Now edit/create the Repo file. Ensure you don’t have any other MariaDB repo file in /etc/yum.repos.d if exists delete or backup the existing repo file :

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

 

Now paste these lines and save it:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

 

After that, we’ll install MariaDB 10.4

yum clean all
yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y
yum update -y

 

Restore my.cnf file :

rm -rf /etc/my.cnf
cp /etc/my.cnf.bak /etc/my.cnf

 

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

systemctl enable mariadb
service mysql start

 

Step 3: Upgrade current databases

 

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

mysql_upgrade

 

You’ve successfully upgraded MariaDB 5.5/10.0/10.1/10.2/10.3 to MariaDB 10.4.  To verify the version run this command from terminal ssh:

mysql

 

這篇文章有幫助嗎? 0 Users Found This Useful (5 Votes)