Database upgrade

Server > Database upgrade (/server/db-upgrade) moves the MariaDB server to a newer long-term release (10.6, 10.11, 11.4, 11.8).

One background run, with its log in /var/log/hitechcloud/updates/db-upgrade-<time>.log:

1. checks that the server is MariaDB, the target is newer and there is room for a dump and a copy of the data directory;
2. dumps every database (all.sql.gz);
3. stops the server and copies its data directory and configuration;
4. switches to MariaDB's signed repository for the target and upgrades the packages;
5. starts the server, runs mariadb-upgrade and checks the version.

If step 4 or 5 fails, the previous packages, data directory and configuration are put back and the server is started again, by itself. Roll back does the same later, while the copy is kept (until the next upgrade); anything written since the upgrade is lost. Every site's database is unavailable while an upgrade runs. Type UPGRADE (or ROLLBACK) to confirm.

hitechcloudcli server-dbupgrade status [--json]
hitechcloudcli server-dbupgrade upgrade --to 11.4 --yes
hitechcloudcli server-dbupgrade rollback --yes