Updating & Upgrading When Needed - MariaDB & Ubuntu

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.



Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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