Ubuntu LTS 22.04 (MariaDB vs MySQL)

[Gomez_Adams]

sigh

OK. Here’s a Q&A that took place before:

@Ilia

@Pierrot

if I have a U20 with mySQL and V6, some have been recently updated to V7 and kept mySQL … mySQL will be replaced only if I run the install again (which I wouldn’t do of course)

This is a good question and important one to understand to anyone running Ubuntu 20.04 with Virtualmin 6.

The short answer is no, meaning that we will not replace MySQL with MariaDB on existing installs, even if you upgrade to Virtualmin 7 as long as you stay on /vm/6 repos.

However, if you change to Virtualmin 7 repos for existing installs, for example, by running a new version of Virtualmin 7 install script with flag -s (to setup repositories), then it will eventually break things, as a stack package would be upgraded, forcing MariaDB instead.

That will most definitely break database service and would require a manual fix.

SO, what we’re all doing (those of us with 20.04 and MySQL) is waiting for the 7 installer. That way we can do a fresh install of 22.04, run the 7 installer, have MariaDB and simply migrate our databases over and be done with it.

You want to wing all of your stuff, fine. Knock yourself out. We’re waiting for the easy and new fix that will be bullet proof.

One of the first things these people will tell you is to NOT start changing all of your repos because you WILL break things in Virtualmin.

Hopefully you’ll get that.