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
[-] rezzorix@alien.top 1 points 1 year ago

You could:

Backup your database. Run a second docker container with new version database. Restore/import backed up database from old version into the new version.

And then try out if all works without errors.

If errors, you can just revert back to your initial docker container with the old version.

[-] Altair12311@alien.top 1 points 1 year ago

I will give a shot! im watching some tutorials about how to do backups, thanks!

[-] adamshand@alien.top 1 points 1 year ago

If you are using bind mounts with your container, there is a really easy way to backup before an update.

  • stop the database container
  • cp -a bind_mount_dir/ bind_mount_dir.20231019

Then pull the latest database image and restart database container. If it works, yay, you're done.

If it doesn't work, reverse the steps:

  • stop the container
  • mv bind_mount_dir/ bind_mount_dir.broken
  • mv bind_mount_dir.20231019 bind_mount_dir

Restart container and you're back to exactly where you were before the upgrade.

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