Question How to upgrade MariaDB to latest version with Plesk Obsidian on Alma Linux 9

[davidds64]

Server operating system version

Alma Linux 9.4 with latest updates

Plesk version and microupdate number

Plesk Obsidian 18.0.62 Update 1

I cannot upgrade MariaDB to latest version via web interface, it simply does nothing. I am running Alma Linux 9.4 (compatible with Red Hat Enterprise Linux 9.4) with latest updates and Plesk Obsidian 18.0.62 Update 1. PHP Version 8.3.9. MariaDB 10.5.22. I do not have mariadb root password, since Plesk handles this through the admin user. So...

I have been looking for a way to upgrade MariaDB to latest version in this situation, and I built a guide. I would like to know if it is good enough and I can upgrate mariadb and keep plesk running. Would you please check it and tell me if i have to make any modifications?

This is the Guide:

If you can’t upgrade MariaDB through the Plesk interface, you can perform the upgrade via the command line. Here’s a step-by-step guide to help you upgrade MariaDB on AlmaLinux 9 with Plesk:

Backup Your Databases:
plesk db dump > /root/all-databases.sql

Stop MariaDB Service:
systemctl stop mariadb

Add the MariaDB Repository: Create a new repo file:
vi /etc/yum.repos.d/MariaDB.repo
Paste the following contents into the file:
[mariadb]
name = MariaDB
baseurl = Index of /yum/11.4.2/almalinux9-amd64/
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Remove Old MariaDB Server:
dnf remove mariadb-server
dnf clean all

Install the Latest MariaDB Version:
dnf install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common

Start MariaDB Service:
systemctl start mariadb
systemctl enable mariadb

Run MariaDB Upgrade:
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

Verify the Installation:
mysql -V
systemctl status mariadb

This process should help you upgrade MariaDB to the latest version while ensuring compatibility with Plesk123.

Could I perform this upgrade safety? I do not want my plesk server and linux to stop working properly. Than you so much in advance for your help.

 

[Kaspar@Plesk]

A how-to article to manually upgrade MariaDB when running Plesk can be found here:

https://support.plesk.com/hc/en-us/articles/12388091703703-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux

I'd recommend using these steps instead of the ones you've outlined.

 

[davidds64]

Ok. I finally took the official howto and made an upgrade through Plesk web interface, just adding the line to allow it to panel.ini, since it is supposed to be right and successfull. Everthing went fine and mariadb became updated to 10.11. But there's a problem: the web interface process does not end, and keeps hanged in the "Upgrading the structure of all tables", after a lot of "OK" it keeps hanged that place.

The upgrade process only have to finish that step and the las one: "Syncing system components". I have been waiting for nearly an hour and it does not finish (I have only a few databases). Anyway, when I open Plesk in another tab, it says that "mariadb has been upgraded", and 2 worpress sites using that database work fine. How can I finish the process? I think it is not a matter of time, and that the process is hanged. :-/ Can you help me to finish this upgrade? Thank you so much in advance.

 

[davidds64]

Now, the mariadb upgrade process still seems hanged, with a moving line at the bottom, but now there is a green sign at the top saying "Upgrade completed. mariadb has been upgraded to 10.11 version. If you have any problem see this: https://support.plesk.com/hc/en-us/...eshooting-Common-MariaDB-MySQL-Upgrade-Issues (no useful info there)". There is also a "Finish" button at the bottom, but the last 2 steps remain undone.

What can I do? Just press "Finish" and forget about data loss and things like that? Is there any other "right" option to make sure everything goes ok?

 

[Kaspar@Plesk]

Some other users have reported a "hanged" upgrade process too but found that upgrading actually finished after clicking the Finish button.

But if you want to be sure I suggest opening a ticket with our support team for an investigation on you server. To sign-in to support and open a ticket go to https://support.plesk.com.

If you got your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative to get support directly from Plesk: https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk

 

[davidds64]

Ok. Enough. That "Finish" button is there for something. I pressed that and got an "Apollo Error 500" with lots of links to javasript files ending in vendor.js. I got an option to reload page. I did it and I saw my mariadb server in plesk running fine. Wordpress sites also run fine. I hope the problems end here and everything is OK. Thank you so much for your help.