Recommended mariadb version

ℹ️ Support
,
1

Hello,

So I started Nextcloud on my home server (running openSUSE Leap) couple years ago. I probably copied default mariadb version provided in sample compose file at the time. Today, after a couple Nextcloud upgrades (and no mariadb upgrades), my versions are as follows:

services:
  db:
    image: mariadb:10.5
    ...
  app:
    image: nextcloud:28
    ...
  phpmyadmin:
    image: phpmyadmin
    profiles:
      - phpmyadmin # just for maintenance
    ...

I assume, that I should upgrade my mariadb instance soon, as 10.5 is going to be EOL i couple months: MariaDB | endoflife.date

My questions are:

  1. To which version exactly do I upgrade? I would have preferred 10.x, so 10.11 (LTS) looks like a great choice with 3 years of support, but then your readme seems to still suggest 10.6 (which will be EOL next year): docs/nextcloud/README.md at master · docker-library/docs · GitHub
  2. What should the upgrade process look like, is it described somewhere, are there any actions I have to take in Nextcloud itself prior or after the upgrade? Alternatively, should I just back up the db, bring Nextcloud itself down, follow the mariadb standard upgrade process (presumably described somewhere in mariadb doc itself) and then just bring Nextcloud back online?
  3. Is there any article/doc describing which combinations of mariadb+Nextcloud are compatible, or at the very least will that be telegraphed at some point when support is dropped? I’m always confused about it, when I’m upgrading Nextcloud, and wondering whether it is going to start or not.
  4. Are there any benefits (eg. performance, stability) in upgrading mariadb?
1 Like
2

I see at software requirements for NC28 which is already EOL Nextcloud | endoflife.date

https://docs.nextcloud.com/server/28/admin_manual/installation/system_requirements.html#server

  • MySQL 8.0+ or MariaDB 10.3/10.5/10.6 (recommended)/10.11

so latest release is 11.6 You can use it but Nextcloud is not tested with this version yet. You can safely install 10.11 EOL (16 Feb 2023) You could upgrade NC to the latest version and install mariadb 11.4 EOL (29 May 2029)

For the Upgrade you should always backup first

https://docs.nextcloud.com/server/28/admin_manual/maintenance/backup.html#mysql-mariadb

then upgrade according to your OS package manager.
also see Upgrading from MariaDB 10.11 to MariaDB 11.4 - MariaDB Knowledge Base

Benefits from upgrading is that vulnerabilities are resolved

3

Exactly, and that is why I was planning to update it (I’m usually trying to use latest version of NC minus 1), but then I’ve noticed the mariadb version, and decided that maybe I should update it first (in case my mariadb is not supported by newer Nextcloud).

Thanks, that was the info I was looking for. It technically says, that 10.5 is still usable. Not sure what I’ll do though, I care more about the stability than having the latest version (especially as I just use it locally, so I don’t really care about security all that much), so maybe will stay on 10.5 until 10.11 becomes recommended.