Skip to content

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].wod.by).

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:

  1. 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
    
  2. 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).

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

2.6.0

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