discussion Guide Plesk Plesk Panel MariaDB 10.6 Upgrade Guide 2025

[CL4Y]

On Linux servers running Plesk Panel, outdated versions of MariaDB (such as 5.5) may cause security vulnerabilities and performance issues due to lack of support for modern features.
Therefore, it’s strongly recommended to upgrade to a newer and more stable version like MariaDB 10.6.
This guide explains step-by-step how to upgrade MariaDB on CentOS 8, AlmaLinux 8, and AlmaLinux 9 systems with Plesk.
Before starting, it’s highly recommended to take a full backup.

⚠️ Warning: Always perform a full backup before proceeding to prevent data loss.
Note: MariaDB 10.4 and above are supported on Plesk Obsidian 18.0.30 and later.

---

1. 📂 Back Up All Databases​

Run the following command to back up all databases:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /tmp/all-databases.sql

⚠️ The SQL backup will be saved as all-databases.sql in /tmp/all-databases.sql.

---

2. 🛑 Stop MariaDB Service and Remove Old Packages​

After stopping the MariaDB service, remove old MariaDB packages to avoid leftover files. Run the following commands:

service mariadb stop
yum remove mariadb-gssapi-server
rpm -e --nodeps `rpm -q --whatprovides mariadb-server`

---

3. 📦 Add MariaDB 10.6 Repositories​

To add the official MariaDB repositories, run:

nano /etc/yum.repos.d/MariaDB.repo

Then add the following lines:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.6/almalinux8-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
priority=1
module_hotfixes=1

⚠️ The above repository is for AlmaLinux 8. Below are repository examples for other OS versions.

Save and exit: CTRL + X, then Y, then Enter.

For AlmaLinux 9:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.6/almalinux9-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
priority=1
module_hotfixes=1

For CentOS 8:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.6/centos8-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
priority=1
module_hotfixes=1

⚠️ To install a newer version, simply replace 10.6 with your preferred version in the baseurl.
Example: baseurl = http://yum.mariadb.org/10.11/almalinux9-amd64

⚠️ For Ubuntu-based systems, a manual MariaDB upgrade is not required, as they already include the latest supported version.

---

4. 🔄 Upgrade MariaDB​

Before upgrading, clear all yum cache by running:

yum clean all

Then upgrade MariaDB:

yum -y install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common

---

5. ⚙️ Update MariaDB Configuration Files​

Adjust the configuration for compatibility with the new version:

sed -i 's/bind-address = ::ffff:127.0.0.1/bind-address = 127.0.0.1/g' /etc/my.cnf

---

6. ▶️ Start the MariaDB Service​

systemctl restart mariadb

---

7. 🔧 Upgrade Databases​

Run the following command to upgrade databases:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mariadb-upgrade -uadmin

Then restart MariaDB:

systemctl restart mariadb

---

8. 🔄 Update Plesk Packages​

Ensure Plesk detects the new MariaDB version correctly by running:

plesk bin service_node --update local
plesk sbin packagemng -sdf

 

[CL4Y]

After completing these steps, MariaDB version 10.6 should be running successfully on your Plesk panel. If you encounter any issues, please let us know 🙂