Problem with MySQL: Production-Ready Docker Images for Craft

[foxtrotcz]

I was trying to create production ready Docker setup of Craft as per https://craftcms.com/knowledge-base/docker-in-production
I am using MySQL because that seems the most recommended database as per https://craftcms.com/knowledge-base/craft-database-options-and-best-practices

I have problem with MySQL backup and restore, from both CLI and dashboard.
Errors from CLI:
Backup:

Backing up the database ... error: The shell command "mysqldump '--defaults-file'='/tmp/fdiriropkuaa.cnf' '--add-drop-table' '--comments' '--create-options' '--dump-date' '--no-autocommit' '--routines' '--default-character-set'='utf8mb4' '--set-charset' '--triggers' '--no-tablespaces' '--no-data' '--skip-triggers' '--result-file'='/var/www/html/storage/backups/username--2026-04-26-151811--v5.9.20.sql' 'db' && mysqldump '--defaults-file'='/tmp/fdiriropkuaa.cnf' '--add-drop-table' '--comments' '--create-options' '--dump-date' '--no-autocommit' '--routines' '--default-character-set'='utf8mb4' '--set-charset' '--triggers' '--no-tablespaces' '--no-create-info' '--ignore-table'='db.assetindexdata' '--ignore-table'='db.cache' '--ignore-table'='db.imagetransformindex' '--ignore-table'='db.resourcepaths' '--ignore-table'='db.phpsessions' '--ignore-table'='db.sessions' 'db' >> "/var/www/html/storage/backups/username--2026-04-26-151811--v5.9.20.sql"" failed with exit code 2: mysqldump: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-dump' instead
mysqldump: Got error: 2026: "TLS/SSL error: self-signed certificate in certificate chain" when trying to connect

Restore:

Restoring database backup ... error: The shell command "mysql '--defaults-file'='/tmp/jxmkiidlqbsw.cnf' 'db' < "/var/www/html/storage/runtime/temp/bjrtpfdoqp/username--2026-04-26-123305--v5.9.20.sql"" failed with exit code 1: mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: self-signed certificate in certificate chain

Similar issues:
#17143
#18155

Could you please update the guide with production ready Dockerised Craft compatible with MySQL?

Looks like the problem is that the so-called "mysql-client" in Alpine is actually "mariadb-client".
I must say its annoying how Linux distros pretend MariaDB is MySQL and let people fight with the incompatibilities.
Relevant upstream issue: https://gitlab.alpinelinux.org/alpine/aports/-/issues/17798

Thanks.