Question Version 18.0.52 and MariaDB 10.11

[Gene Steinberg]

Server operating system version

AlmaLinux 8.7

Plesk version and microupdate number

18.0.52

So this version evidently supports what is regarded as the current stable version of MariaDB, 10.11.

Are there any downsides in updating WordPress and XenForo forums to the new database release?

What's the best way to install it on a system using AlmaLinux 8.7? I used your instructions to get from MariaDB 10.3 to 10.6. Same instructions with different version numbers? What?

 

[scsa20]

I did this recently, I just followed this guide via the manual method for "Plesk on CentOS 7/RHEL 7":

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-

The only difference is on step 6.1 I change the version from 10.5 to 10.11 but otherwise the manual method is the same.

 

[Gene Steinberg]

Using XenForo and WordPress with current add-ons — any known issues?

 

[scsa20]

I don't use XenForo but I haven't had any issues with WordPress. As long as you kept those apps up to date you really shouldn't have any issues. I do recommend that you make make sure you have backups and if you're running on a VPS to take a snapshot before doing the upgrade so you can roll back if anything happens. Just remember to follow all the steps including the command for updating the databases after starting back up the sql server service.

 

[Gene Steinberg]

Our AlmaLinux 8.7 setup choked on the step to where the changed version number was called for.

Must I assume that 10.11 isn't available from the usual sources that support that OS?

 

[Gene Steinberg]

OK the repository Plesk set for 11.0 and 11.0.1 doesn't show anything for centos8-amd64/.

That's the issue.

 

[scsa20]

If you were following the steps, step 6.1is for

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

I just do

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

Instead, this will install the mariadb repo. It does take a bit but shouldn't take too too long. The whole upgrade process took me about 15 minutes all together.

 

[Gene Steinberg]

Granted but the repo file would have an incorrect base entry: https://yum.mariadb.org/10.11/centos8-amd64

That does not exist.

 

[Gene Steinberg]

And there is no step 6.1 in the instructions for CentOS 8, which is what I'm using as it's the closest match.

 

[scsa20]

This is why I said I said to follow the instructions for Plesk on CentOS 7 / RHEL 7 since, in reality, that's the most closest match for AlmaLinux (I use AlmaLinux 8.7 as well and those are the steps I followed)

I just followed this guide via the manual method for "Plesk on CentOS 7/RHEL 7":

If you followed what I suggested instead of following the CentOS 8 (which the steps is nowhere near the same nor correct) you wouldn't had the issue.

 

[Gene Steinberg]

It wasn't clear that I should use that version for AlmaLinux 8.7.

Yes, it was easier and we're good I think. So far the various WP, XenForo and DadaMail databases seem to work OK with MariaDB 11.0.1.

Thank you.