Is there a how to guide to upgrade mysql to a newer version or to Mariadb ?

9 posts / 0 new
Last post
#1 Mon, 07/30/2018 - 14:31
tegra

Is there a how to guide to upgrade mysql to a newer version or to Mariadb ?

I searched and didnt see anything how how to upgrade to a new version of mysql or mariadb. Thanks in advance

Mon, 07/30/2018 - 14:45
andreychek

Howdy,

There unfortunately isn't a supported way to upgrade to newer software versions... the software in use is what's provided by your distribution.

Our recommended way of getting newer software would be to upgrade to a newer distro.

That said, there have been users who have had success in using third party repositories to accomplish that, but doing that can also lead to all sorts of problems too.

Sorry, I wish I had an awesomer answer :-)

-Eric

Mon, 07/30/2018 - 15:53
tegra

This is a fresh install. I was installing centos 7. Isnt that a new distro ? If that do you recommend anything ?

billy

Mon, 07/30/2018 - 15:59
andreychek

Howdy,

Yeah that is indeed the newest available to CentOS/RHEL.

If you need a newer MySQL/MariaDB version than that, you might want to look into what's provided by Ubuntu or Debian, which both have released new distro versions more recently.

-Eric

Tue, 07/31/2018 - 06:43
tegra

do are u saying that i will have to change the distro so that virtualmin installs a different version ?

billy

Tue, 07/31/2018 - 08:18
andreychek

Virtualmin does not provide MySQL/MariaDB. Your Linux distribution provides those.

Virtualmin simply uses what's installed.

I'm suggesting that you need to choose a distro based on the software versions you want.

If your requirements are to have a recent MySQL/MariaDB version, then you'd want to find a Linux distribution that provides the MySQL/MariaDB version you need.

If your requirements are to use CentOS 7 -- well, CentOS 7 ships with MariaDB 5.5.56.

Sorry, but CentOS doesn't provide a newer version than that.

And Virtualmin doesn't package it's own software, it just uses whatever is included with your distribution.

-Eric

Tue, 07/31/2018 - 08:48
tegra

I think i got it to work. I install a minimal centos 7 then i install mariadb first server and client then I installed the virtualmin script. After i logged in i had to specify the password for it which was none then add a password. thanks anyway for your help.

billy

Wed, 08/01/2018 - 18:15
Joe
Joe's picture

Virtualmin will happily use whatever database version you want.

We use mariadb 10 from the SCL (Software Collections Library) on our Virtualmin.com server, because I needed a feature that was introduced in that 10.x version. I recommend SCL for most situations where you need a newer version of something. The packages are reasonably well-maintained, and get a bit more vetting than more third party repositories.

--

Check out the forum guidelines!

Sun, 06/23/2019 - 11:17
leofishman

Can I install mariadb 10.2 over mysql 5.7.26 from the SCL and keep all virtual servers configurations and databases using ubuntu 18.04.2?

Topic locked