Step 1 Remove MariaDB 5.5/10.0/10.1/10.2
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 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 :
service mysql stop yum remove MariaDB-server MariaDB-client
At this point MariaDB 10.0/10.1/10.2 will be removed completely but the databases are not removed don’t need to worry.
Then Install MariaDB 10.5.5 :
Step 2 Installation/Updating from MariaDB 5.5/10.0/10.1/10.2 to MariaDB 10.3
Install/enable Official repo for mariadb 10.5.5:
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.5.5/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
After that we’ll install Mariadb 10.5.5
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 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/10.0/10.1/10.2 to MariaDB 10.3.
You can confirm the version by running this command from terminal ssh: