• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

carini
Resolved Maria DB update fail, autoupdate no longer works
2
Replies
24
Views
2K
mow
M
Jan Bludau
Issue Updating Debian 10 to 11
Replies
1
Views
1K
Jan Bludau
Jan Bludau
P
Issue Upgrade Mariadb 10.3 to 10.6 completes but trying to start MariaDB fails with error "systemctl status mariadb.service" and "journalctl -xe"
Replies
12
Views
514
PeterK900
P
davidds64
Question How to upgrade MariaDB to latest version with Plesk Obsidian on Alma Linux 9
Replies
5
Views
1K
davidds64
davidds64
B
Resolved MariaDB Upgrade 10.3 -> 10.6 not working
Replies
12
Views
4K
boosterfan
B
Back
Top