Updating & Upgrading When Needed - MariaDB & Ubuntu

Posted June 12, 2020 805 views
WordPressDigitalOceanMariaDBUbuntu 20.04

I am new to using a VPS and was hoping that someone could advise me on the following:

If I build a wordpress blog on Ubuntu 20.04 vps then MariaDB installs with version 10.3. Although this is not the latest version, I understand that this is a stable version and have been advised that its ok to use 10.3 for the next couple of years.

My question is:

How and how easy is it to update in say 2 years when support runs out for the version of Mariadb?

Is it a simple process and will it be a case of updating to the new ubuntu which will then upgrade my version of mariadb to a more recent version?

My blog by then will have lots of content on it, so IO suppose im a bit worried about not being able to just transfer it over to a new version when needed.

Im I worrying for nothing here.



These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi there @colinshaun77Eel,

MariaDB are usually quite good at documenting the upgrade process from one version to another.

For example, you could take a look at the upgrade guide for MariaDB 10.2 to MariaDB 10.3 here:

They have listed all of the steps along with the incompatible changes between the two versions.

Besides that, I would recommend keeping your server up to date by installing all of the latest security patches and minor upgrades on a regular basis by scheduling some maintenance windows.

One thing that I would strongly recommend is taking regular backups of your Droplet, so that in case that anything goes wrong with any future upgrade, you would have a working backup that you could revert to.

Another thing you could consider is going for a Managed Database Cluster, that way you would not have to worry about the database server maintenance, security upgrades and etc.

Hope that this helps!