MariaDB stack documentation¶

MariaDB can be configured with the following environment variables

External access¶

There are two ways to connect to a MariaDB server externally: publish port or set up an SSH tunnel.

Publish port¶

Publish MariaDB's port (3306) from stack configuration page to a dynamic node port and connect as:

mysql -h=[IP] -P[PORT] -u[USER] -p[PASSWORD] [DATABASE]

Where [PORT] is the generated node port (you can find it on a service page App Instance > Stack > MariaDB) and [IP] is the IP of the server where app instance deployed (or use the server hostname node-[SERVER UUID].wodby.cloud).

Set up tunnel¶

If you deploy MariaDB as a service inside of a stack that comes with an SSHD container, you can set up a secure tunnel:

Set up SSH tunnel on port 53306 (you can change it). You can find [SSH Port] on Instance > Stack > SSH page. For MariaDB (port 3306 by default) use the following command:
```
ssh -L 53306:mariadb:3306 -p [SSH Port] wodby@[Server IP] -N
```
Connect to the database via the tunnel on port 53306 (replace [tokens]):
```
mysql --protocol=TCP -P53306 -u[USER] -p[PASSWORD] [DATABASE]
```

Changelog¶

This changelog is for MariaDB stack on Wodby, to see image changes see tags description on repository page.

MariaDB updates

We strongly recommend to backup your database before upgrading your application stack
During MariaDB upgrade we run mysql-check and mysql-upgrade. This operation may take a few minutes for big databases

MariaDB 10.1

If your app has MariaDB 10.1 service and the app was created (or its stack was upgraded) after June 2018, you're actually running MariaDB 10.2 (see https://twitter.com/wodbycloud/status/1206943424861102081 for more details).

3.2.2¶

⬆️ MariaDB 11.4.7, 10.11.13, 10.6.22, 10.5.29

3.2.1¶

⬆️ Updated to 11.4.5, 10.11.11, 10.6.21, 10.5.28
⭐️ Added MariaDB 11.4

3.2.0¶

📜 MariaDB: mysqld and mysql_ binaries use in scripts to mariadb analogs

3.1.8¶

⬆️ MariaDB 11.4.4, 10.11.10, 10.6.20, 10.5.27

3.1.7¶

🪦 10.4 has reached EOL
🏔️ Alpine Linux updated to 3.20

3.1.6¶

⬆️ MariaDB 11.2.5, 11.1.6, 10.11.9, 10.6.19, 10.5.26

3.1.5¶

⬆️ MariaDB 11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34

3.1.4¶

⬆️ MariaDB 10.11.7, 10.6.17, 10.5.24, 10.4.33

3.1.3¶

🏔 Alpine Linux upgraded to 3.18 and 3.16

3.1.2¶

⬆️ Updated to 11.0.4, 10.11.6, 10.6.16, 10.5.23, 10.4.32
🪦 Version 10.9 has reached end of life
🐞 Bugfix: MYSQL_TRANSACTION_ISOLATION had no effect in 10.x

3.1.1¶

⬆️ MariaDB 11.0.3, 10.11.5, 10.10.6, 10.9.8, 10.6.15, 10.5.22, 10.4.31

3.1.0¶

MariaDB
⭐️ Added new version 10.11
🪦 Versions 10.3, 10.7, 10.8 have reached end of life and will no longer receive updates
⬆️ Updated to 10.9.7, 10.6.14, 10.5.21, 10.4.30

3.0.4¶

⬆️ MariaDB 10.9.6, 10.8.8, 10.6.13, 10.5.20, 10.4.29, 10.3.39

3.0.3¶

🏔 Alpine Linux upgraded to 3.17.3, 3.16.5

3.0.2¶

🐞 Incorrect architecture in Alpine Linux https://github.com/alpinelinux/docker-alpine/issues/303#issuecomment-1448126235

3.0.1¶

🏔 Alpine updated to 3.17.2, 3.15.7

3.0.0¶

⚠️ This version of stack requires server infrastructure 6.0.0+
⬆️ MariaDB 10.9.5, 10.8.7, 10.7.8, 10.6.12, 10.5.19, 10.4.28, 10.3.38
🏔 Alpine updated to 3.17 for MariaDB (10.5-10.9)

2.11.0¶

⭐️ Added new MariaDB 10.9
⬆️ Updated to 10.8.6, 10.7.7, 10.6.11, 10.5.18, 10.4.27, 10.3.37

2.10.4¶

⬆️ MariaDB 10.7.6, 10.6.10

2.10.3¶

⬆️ MariaDB 10.7.5, 10.6.9, 10.5.17, 10.4.26, 10.3.36

2.10.2¶

⭐️ Added MariaDB 10.8
⬆️ Updated to 10.7.4, 10.6.8, 10.5.16, 10.4.25, 10.3.35
🪦 MariaDB 10.2 has reached EOL

2.10.1¶

📜 MariaDB config: removed deprecated innodb_log_files_in_group and innodb_buffer_pool_instances from 10.5+

2.10.0¶

ℹ️ This update requires server infrastructure at least 5.9.0
🏔 Alpine Linux updated to 3.15

2.9.2¶

🏔 Security updates for base OS Alpine Linux

2.9.1¶

🏔 Patch updates for base OS Alpine Linux

2.9.0¶

⭐️ Added new MariaDB 10.7
⏎ Returned MariaDB 10.2 (dropped by mistake)
⬆️ Updated to 10.6.7, 10.5.15, 10.4.24, 10.3.34, 10.2.43
🚨 Reworked my.cnf configuration https://github.com/wodby/mariadb/issues/45:
- lower_case_table_names, join_buffer_size, innodb_open_files no longer set by default unless specified
- query_cache_size default value changed to 1M
- query_cache_type now OFF by default
- flush_log_at_trx_commit default value changed to 1
- Added new env vars $MYSQL_JOIN_BUFFER_SPACE_LIMIT, $MYSQL_OPTIMIZER_SWITCH (no default values)
- ⚠️ Name of $MYSQL_LOWER_CASE_TABLE_NAME changed to $MYSQL_LOWER_CASE_TABLE_NAMES

2.8.0¶

⭐️ Added new MariaDB 10.6
⬆️ Updates: 10.5.13, 10.4.22, 10.3.32, 10.2.41

2.7.9¶

⬆️ MariaDB 10.4.21, 10.3.31

2.7.8¶

⬆️ MariaDB 10.5.11, 10.4.20, 10.3.30, 10.2.39

2.7.7¶

⬆️ MariaDB 10.5.10, 10.4.19, 10.3.29, 10.2.38

2.7.6¶

📦 Base OS Alpine Linux updated to 3.13.5

2.7.5¶

⬆️ Updates: 10.5.9, 10.4.18, 10.3.28, 10.2.37
🚨 RocksDB plugin no longer compiled in

2.7.4¶

⬆️ Base image Alpine Linux updated to 3.13.2

2.7.3¶

⬆️ Base image Alpine Linux updated to 3.12.3
🦴 ImagePullPolicy changed to IfNotPresent

2.7.2¶

MariaDB 10.5.8, 10.4.17, 10.3.27, 10.2.36

2.7.1¶

MariaDB 10.5.6, 10.4.15, 10.3.25, 10.2.34

2.7.0¶

MariaDB 10.5

2.6.7¶

MariaDB 10.4.14, 10.3.24, 10.2.33, 10.1.46

2.6.6¶

MariaDB 10.1.45, 10.2.32, 10.3.23, 10.4.13
Adminer 4.7.7
Base OS Alpine Linux updated to 3.12.0

2.6.5¶

MariaDB 10.4.12, 10.3.22, 10.2.31, 10.1.44
mysql_upgrade now runs with --upgrade-system-tables and --verbose flags (run during stack upgrades)
mysqlcheck now runs with --verbose flag (run with every deployment)

2.6.4¶

MariaDB 10.4.11, 10.3.21, 10.2.30

2.6.3¶

MariaDB updates: 10.4.10, 10.3.20, 10.2.29, 10.1.43

2.6.2¶

MariaDB 10.4.8, 10.3.18, 10.2.27

2.6.1¶

❗️Security updates: 10.4.7, 10.3.17, 10.2.26, 10.1.41
Version 10.4 temporary has no PAM https://github.com/wodby/mariadb/issues/20
open_files_limit is now configurable https://github.com/wodby/mariadb/issues/18

2.6.0¶

MariaDB:
- Updated to 10.3.16, 10.2.25
- Added new major version 10.4
- You can now add plugins via $MARIADB_PLUGIN_LOAD https://github.com/wodby/mariadb/issues/15
- Added linux-pam library for PAM auth
- Added $MYSQL_CONNECT_TIMEOUT https://github.com/wodby/mariadb/issues/17
Adminer updated to 4.7.2
Alpine Linux updated to 3.10.1 for MariaDB (except 10.1) and Adminer

2.5.4¶

MariaDB:
- Updated to 10.3.15
- log_warnings now configurable, set to 2 by default for all versions
Adminer rebuilt against latest base image

2.5.3¶

MariaDB updates: 10.2.24, 10.1.40
Adminer rebuilt against latest base image
Alpine Linux updated to 3.9.3 for MariaDB (except 10.1) and Adminer

2.5.2¶

MariaDB updated to 10.3.14
Adminer rebuilt against latest base image
Alpine Linux updated to 3.9.3 for MariaDB (except 10.1) and Adminer

2.5.1¶

MariaDB updated to 10.2.23

2.5.0¶

MariaDB:
Patch updates: 10.3.13, 10.2.22, 10.1.38
MariaDB 10.2, 10.3 rebased to Alpine 3.9 and OpenSSL 1.1
innodb_force_recovery and innodb_purge_threads are now configurable via env vars
Added mysql-check orchestration action and now run with every MariaDB deployment to detect potential issues
Adminer updated to 4.7.1 and rebuilt against the latest PHP image

2.4.1¶

MariaDB updates: 10.2.21, 10.3.12, ~~10.1.37~~ https://github.com/wodby/mariadb/issues/10

2.4.0¶

Patch updates: 10.3.11, 10.2.19
We now run mysql_upgrade automatically on stack upgrades

2.3.4¶

MariaDB 10.0 innodb_default_row_format now set to dynamic by default

2.3.3¶

MariaDB patch update 10.3.10
Adminer:
- Bugfix: some $PHP_ env vars were ignored
- Default memory limit set to 512M
- Adminer and Webgrind rebuilt against the latest PHP image

2.3.2¶

MariaDB
- Patch update: 10.2.18
- Improved performance for backup orchestration action
Adminer:
- Added the default list of plugins, enabled via $ADMINER_PLUGINS
- You can now change Adminer design via $ADMINER_DESIGN z
- Updated to the latest stable PHP image

2.3.1¶

MariaDB patch update: 10.1.36

2.3.0¶

MariaDB patch updates: 10.3.9, 10.2.17, 10.1.35
Image rebased to Alpine Linux 3.8
Backup action performance improvement: no intermediate file created
Bugfix: triggers duplicated during db dump
Bugfix: no privileges before import could cause failure
ionice no longer used in orchestration actions

2.2.0¶

New version 10.3 added (10.3.7)
MariaDB updates: 10.2.15, 10.1.34
optimizer_prune_level and optimizer_search_depth are now configurable https://github.com/wodby/mariadb/issues/4
❗Default innodb_buffer_pool_size set to 128M that should significantly decrease memory usage by MariaDB container. See stack documentation to learn how to calculate the optimal size of innodb_buffer_pool_size for your application
Default innodb_buffer_pool_instances set to 1

2.1.0¶

Updated to 10.1.31, 10.2.12
Rebased to Alpine Linux 3.7
Default memory request set to 64m

2.0.1¶

Restored MariaDB 10.1 innodb_large_prefix setting (enabled by default) removed in 2.0.0

2.0.0¶

New MariaDB 10.2.11
MariaDB updated to 10.1.29
Shutdown grace period increased to 5 minutes
Health check timeout increased to 30 seconds
Deployment strategy no longer can be changed
Optimized default values in my.cnf
New environment variables to configure recovery options
Default user/group in a container now mysql
Backup action now runs with nice (10) and ionice (7)
Improved error handling in import action

1.0.4¶

MariaDB updated to 10.1.26

1.0.3¶

Directory __MACOSX now excluded from import archive

1.0.2¶

MariaDB now recovers privileges in case of an error during import

1.0.1¶

Priveleges are now revoked for a regular user during import
Bug fix: sometimes tables weren't ignored during backup

1.0.0¶

Initial release