• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Upgrade to MariaDB 10.6

Kulturmensch

Kulturmensch

Regular Pleskian
Server operating system version
Ubuntu 20.04.4 LTS
Plesk version and microupdate number
Plesk Obsidian v18.0.44_build1800220614.18
I have updated MariaDB to version 10.5 some time ago and would like to upgrade to version 10.6 now.

Is it simply possible to replace in etc/apt/sources.list

deb [arch=arm64,ppc64el,amd64] https://mirror.truenetwork.ru/mariadb/repo/10.5/ubuntu focal main
by
deb [arch=arm64,ppc64el,amd64] https://mirror.truenetwork.ru/mariadb/repo/10.6/ubuntu focal main

followed by
apt update && apt upgrade
?
If yes, are there additional steps necessary?
 
First of all I would not recommend to use a russion repository, no one knows if and when the connection to russian servers will be limited or blocked.
I recommend further to follow an adapted version of https://support.plesk.com/hc/en-us/...5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux- which includes a dump of the database data and the necessary upgrade command.
Be also aware of https://support.plesk.com/hc/en-us/...-on-TCP-IP-port-Got-error-22-Invalid-argument and other possible changes like this one. Some things have changed for 10.6 compared to previous versions.
 
Thank you. To get rid of the ru-repository was also an objective. But following your link and choose Ubuntu 20.4 I should then use:

add-apt-repository 'deb [arch=amd64,arm64,ppc64el,s390x] Index of /mariadb/repo/10.4/ubuntu/ focal main'

which seems to be a russion repository, too.

Any idea where I can get MariaDB 10.6 from a more safe repository?
 
So, I finally made it and got rid of the russian repository. I found this page where you can select an appropriate repository close to your location, too: I.e. Download MariaDB Server - MariaDB.org

For the installationen I removed 10.5 and then installed 10.6. After mariadb service restart everything worked again as before - no extra entries were needed.

By the way I wondered for a short time why not to upgrade to 10.7 or 10.8 but I saw that 10.6 is the last version with 5 year support - the later versions have only 1 year support. So, for me it was just a support matter to go for 10.6.

The two main apps which are working in my case without any modifications of *.cnf and *.conf after upgrade:
  • Nextcloud (24.0.2)
  • Drupal (9.4.1)
 
I'm trying to upgrade from MariaDB 10.3 to 10.6. I'm using AlmaLinux 8.7 on the Plesk server, running latest Plesk.

I'm trying to find the proper distribution on the MariaDB site to use in the upgrade, but it doesn't list that OS, nor do your upgrade directions.

Guidance please? I'm in the U.S.
 
Gene Steinberg said:
I'm trying to upgrade from MariaDB 10.3 to 10.6. I'm using AlmaLinux 8.7 on the Plesk server, running latest Plesk.

I'm trying to find the proper distribution on the MariaDB site to use in the upgrade, but it doesn't list that OS, nor do your upgrade directions.

Guidance please? I'm in the U.S.
Click to expand...

I use this repo data for MariaDB on AlmaLinux 8.7:
Code: 
# cat /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = https://yum.mariadb.org/10.6/centos8-amd64$
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
enabled=1
module_hotfixes=1
gpgcheck=1
 
Last edited:
That's where I checked the directions. The listed file doesn't exist.

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

I used the CentOS 8 instructions, since that seems closest to AlmaLinux 8.7. Wrong?
 
The file does not necessarily have to be named "MariaDB.repo". It could also be named "mariadb.repo" (in small letters) or "mickey.m.repo" or whatever. Please list the files in /etc/yum.repos.d and check which one is probably the existing mariadb repo file. There will only be a few. You can update that one with new content.
 
Of course, this wouldn't be a problem if Plesk simply included an installer for the latest supported version of MariaDB in the control panel, just as cPanel does.
 
# grep mariadb *.repo
?

If there is no repo for MariaDB, how can you already have MariaDB on your server? But anyway, in that case you can create the file.
 
Gene Steinberg said:
I went through every single file above and there is nothing mentioning MariaDB.
Click to expand...

Plesk installs MariaDB 10.3 from the [appstream] section of almalinux.repo.
Have a look at this directory of packages, where you will find mariadb:

Since that repo only supports mariadb 10.3, you need to add another repo file that contains version 10.6 of MariaDB.
It's more or less explained in the upgrade guide I posted above:

Screenshot 2023-02-19 at 11.09.03.png
 
Last edited:
OK, we are mostly set here, but for this:

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

If I'm going to use the MariaDB.repo file configured as follows:

# cat /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = Index of /yum/10.6/centos8-amd64/
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
enabled=1
module_hotfixes=1
gpgcheck=1

How do I modify the install file? When I changed galera-4 to galera-6, it failed. What do I need to fix in those instructions?
 
You must log in or register to reply here.

Similar threads

Jan Bludau
Issue Updating Debian 10 to 11
Replies
1
Views
742
Jan Bludau
Jan Bludau
B
Resolved MariaDB Upgrade 10.3 -> 10.6 not working
Replies
12
Views
2K
boosterfan
B
E
Question AlmaLinux 9 MariaDB 10.5 to 10.6 then after MariaDB 10.6 to 10.11
Replies
15
Views
3K
occinodo
O
D
Question How to update Maria DB from 10.3 to 10.5
Replies
1
Views
2K
Kaspar
K
brainforge
Resolved System updates have started failing.
Replies
2
Views
395
brainforge
brainforge
Back
Top