Question

Updating & Upgrading When Needed - MariaDB & Ubuntu

Posted June 12, 2020 189 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.

Regards

Colin

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.

×
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:

https://mariadb.com/kb/en/upgrading-from-mariadb-102-to-mariadb-103/

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!
Regards,
Bobby

Submit an Answer