When I run this: sudo apt install mariadb-server-10.3
I get an error saying:
Reading package lists… Done
Building dependency tree… Done
Reading state information… Done
Package mariadb-server-10.3 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
Can I use 10.6 or the latest 10.9.1 RC ,or how can I get 10.3 now?
Short answer: You can definitely use the 10.6 it mentioned. It’s fine.
Every Linux distribution + version offers a different set of software. To discover what the Advanced Packaging Tool (APT) offers on a Debian-based system, type this in a console:
sudo apt-cache search "mariadb-server"
For example, my laptop (Debian 11) replies with this:
mariadb-server - MariaDB database server (metapackage depending on the latest version)
mariadb-server-10.5 - MariaDB database server binaries
mariadb-server-core-10.5 - MariaDB database core server files
So I could install MariaDB Server 10.5 using 'apt’
Without using 'apt', you can install any version you want. There are many ways. If you want binaries, the links for MariaDB are here:
Warning: If you’ve never done this before, know that installing MariaDB manually does -not- yield identical results, compared to installing with ‘apt’. Package Managers usually do extra, helpful things during installation. For example configuring the SQL “root” account, loading Time Zones, creating a directory structure. Sometimes they alter the 'my.cnf' file.
If you’re in a hurry, I would stick with ‘apt’, rather than potentially get “stuck” manually installing.
But if you have time to experiment, it’s quite possible: I’ve manually installed MariaDB several times.
Another great way to get a specific version of MariaDB server is with Docker. Just have to make sure you configure the Database data files to be persistent.
It seems to have worked, although I have not had the time this week to put it through a thorough test sequence. I do have a sandbox server running with this configuration and the few cursory tests seemed to have worked out well.
Do I endorse it as the fix? Well, all I can say is that:
The install didn’t blow up
The Admin startup wizard ran just fine
The database restore of one of my production servers didn’t blow up
Creating a Sales Invoice seemed to work.
That is all I have had time to test. So I would say to anyone else that it is certainly worth a try.