MariaDB upgrade

Submitted by tinkyawoo on Thu, 01/21/2021 - 17:24 Pro Licensee

Some of the web app running on my server require MariaDB 10.XX and I would like to know if there is a way I can upgrade MariaDB 5.5.68.

Status: 
Closed (fixed)
Virtualmin version: 
6.14
Webmin version: 
1.962

Comments

Submitted by tinkyawoo on Fri, 01/22/2021 - 06:26 Pro Licensee

Status: Active ยป Closed (fixed)

Figured out to do it manually.

Submitted by tinkyawoo on Fri, 01/22/2021 - 06:26 Pro Licensee

Figured out to do it manually.

Ilia's picture
Submitted by Ilia on Fri, 01/22/2021 - 07:26

Hi,

Yes, upgrading MariaDB 5.5 to MairaDB 10 is possible and Virtualmin supports both versions equally well.

However, we never recommended doing it in the past for the reason that we wouldn't be able to provide any support, if any possible issues comes up.

We could give you simple instructions, which worked for us just fine, but again, you will be solely responsible for anything that happens further. :--)

Run the following commands:

nano /etc/yum.repos.d/MariaDB.repo

.. then paste the following content:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

.. then run the following command:

yum update -y

.. then:

systemctl restart mariadb

.. and finally:

mysql_upgrade -u root -p --verbose

We will add this to the video tutorial in the near future.