this post was submitted on 18 Oct 2023
1 points (100.0% liked)

Self-Hosted Main

504 readers
1 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

For Example

We welcome posts that include suggestions for good self-hosted alternatives to popular online services, how they are better, or how they give back control of your data. Also include hints and tips for less technical readers.

Useful Lists

founded 1 year ago
MODERATORS
communick@selfhosted.forum
1
Should i update my selfhosted database? MariaDB (alien.top)
submitted 1 year ago by Altair12311@alien.top to c/main@selfhosted.forum
9 comments fedilink hide all child comments
 

Hi! im a bit confused because i have a MariaDB instance on my mini-pc so i can control things like NextCloud but some people told me i should not update my docker image of MariaDB because it can break? and other people said update it... Im unsure what to do... Some advices?

you are viewing a single comment's thread
view the rest of the comments
[โ€“] thekrautboy@alien.top 1 points 1 year ago (1 children)

Database version upgrades can be tricky. Always make a proper backup before! Ideally you would make a db dump plus a copy of the db container data.

Typically smaller version upgrades are not a problem, for example updating from 10.9.4 to 10.9.5 shouldnt be a issue.

But major upgrades, like going from 9.6 to 10.2 can cause more problems and you should always pay attention to the release notes of a new version and also make sure that the software that makes use of that db is also still compatible with that new db version. For example it could be that Nextcloud says to stay on 10.9 and 11.0 is not yet supported.

Since databases are usually not configured so that anyone can connect to it, let alone the open internet, it is not too bad when you lag behind a few versions. Ideally when using Docker networking for example you would have a closed network that only connects the db with the actual app that needs the app, and nothing else can connect to that db.

[โ€“] Altair12311@alien.top 1 points 1 year ago

Thanks for take the time and explain it well to me,i really appreciate it, thanks you so much