Is there a short and proven linux shell command or script to safely perform a major-release upgrade on a mariadb docker container?

Question

The question is basically in the title already. At first I thought about a one-liner but maybe a short script is fine as well.

The command or script is meant to initiate all updating on the actual data that is required when stepping up to the next or a specified major release of mariadb.

Assumptions:

• Let's assume we are on an up-to-date Ubuntu 22.04 system
• The mariaddb container is part of some service that was brought up via docker-compose
• the official mariadb image from https://hub.docker.com/_/mariadb is used
• We are in the folder ($PWD) of the corresponding docker-compose.yaml file
• The mariadb container and data is currently on 10.5.? and it should finally upgrade to 10.10.2 for instance, may it be directly or step-by-step.
• the data are actually stored on a mapped volume (alternatively in a named volume)

Answer 1

1. docker compose down. Do NOT docker compose kill, MariaDB must be cleanly shutdown.
2. take backup of the volume:

   mkdir -p backup
   docker run --rm \
     -v "$VOLUME_NAME":/backup-volume \
     -v "$(pwd)":/backup \
     busybox \
     tar -zcvf /backup/my-backup.tar.gz /backup-volume```
   

(ref; docker blog)

1. change the compose file to the 10.10 tag or whatever suits you
2. Add env: MARIADB_AUTO_UPGRADE=1 to the compose file
3. docker compose up
4. look at the container logs and test connection.
5. if there is "InnoDB: Upgrade after a crash is not supported." in the log, that means it wasn't cleanly shutdown. Shutdown cleanly, go back to the 10.5 tag and start again. Do NOT google around or delete a the ib_logfile0. It won't start after that.