TrueNAS Core, upgrade MariaDB

I am still running Core with Nextcloud in a jail. I noticed today that MariaDB 10.6 will deprecated in june 26. Can i upgrade to 11.8 without screwing up my Nextcloud installation?

If your jail is running FreeBSD 13.5 you can upgrade your MariaDB version. Which one is supported by Nextcloud is found in the Nextcloud documentation.

Apart from 11.8 versions 10.11 and 11.4 also exist and might be a more conservative approach.

Keep in mind that once FreeBSD 13.5 is EOL you will not be able to install any packages and if you are running any version below 13.5 that is already the case now.

Better plan for a switch to TrueNAS CE or a different product. Jails in TrueNAS are dead. EOL for 13.5 is in April.

1 Like

I know Patrick and i have been running a TrueNAS CE server in parallel to get acquainted with it so i can flip the switch when needed but my Core server with indeed jails on 13.5-p6 are running perfectly fine and i’ve gotten used to FreeBSD so i have a bit of a hard time parting from it. NC33 recommends 11.8. I just never have done a major db upgrade so i am a bit in the dark.

In general MySQL/MariaDB will perform an in-place upgrade of your database.

Take a snapshot of all relevant datasets, first, keep fingers crossed. It’s probably going to work out just fine.

You might need to explicitly reinstall the client package and the PHP library.

service mysql-server stop
pkg install mariadb118-server
service mysql-server start

Good luck.