UPGRADE MARIADB 5.5 to 10.3 CENTOS 7 | VESTACP | HINDI | MARIADB 10.4 TUTORIAL |

UPGRADE MARIADB 5.5 to 10.3 CENTOS 7 | VESTACP | HINDI | MARIADB 10.4 TUTORIAL |

To upgrade follow this simple steps to upgrade it to 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 this steps carefully.

First backup your current my.cnf config :

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

Now we need to remove current version of mariadb 5.5 installed on centos 7 :

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
yum install
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 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

then paste this 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 the 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

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

mysql_upgrade

that’s it you’ve successfully upgraded MariaDB 5.5/10.0/10.1/10.2/10.3 to MariaDB 10.4.

You can confirm the version by running this command from terminal ssh:

mysql