Control Web Panel - CWP - MariaDB Upgrade 10.6 - Almalinux 8 - ZirveSunucum Information
Login
Customer Panel
Login
Register

Control Web Panel - CWP - MariaDB Upgrade 10.6 - Almalinux 8

How you can upgrade MariaDB version to 10.6 on Almalinux 8 server.

Please do not perform such operations without backing up your entire system.

Before starting an upgrade please confirm that you have the backup of MySQL databases and users. 

If you want to get only database backup, you can use this command first :

mysqldump --all-databases > /root/complete_database_backup.sql.gz

 

Also, make sure all your scripts/sites are compatible with the new version as there is no return back to an old version.

 

Check which version of MariaDB is installed on your server

rpm -qa|grep -i maria

 

Update Mariadb Repo First

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=mariadb-10.6 --skip-maxscale

 

If automatic updates do not occur after the above steps, check the repos manually.

MariaDB Repository Changes
Modify repo file to the version you want to upgrade
Edit File: /etc/yum.repos.d/mariadb.repo

* Modify your version in the repo : 
[mariadb-main]
name = MariaDB Server
baseurl = https://dlm.mariadb.com/repo/mariadb-server/10.6/yum/rhel/8/x86_64
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck = 1
enabled = 1
module_hotfixes = 1

 

[mariadb-tools]
name = MariaDB Tools
baseurl = https://downloads.mariadb.com/Tools/rhel/8/x86_64
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Enterprise-GPG-KEY
gpgcheck = 1
enabled = 1

 

Stop and remove the old version of MariaDB (Databases will not be removed)

service mysql stop
service mariadb stop
systemctl disable mariadb
rpm --nodeps -ev MariaDB-server

 

Install the new version of MariaDB

yum clean all
yum -y update "MariaDB-*"
yum -y install MariaDB-server
systemctl enable mariadb
service mariadb start
mysql_upgrade

 

Verify upgraded packages

rpm -qa|grep -i maria

 

 If you followed the steps correctly, the update process is complete.