MariaDB Docker Container Image

Docker Images

• All images are based on Alpine Linux
• Base image: wodby/alpine
• CircleCI builds
• Docker Hub

Supported tags and respective Dockerfile links:

• 10, 10.2, latest (Dockerfile)
• 10.1 (Dockerfile)

For better reliability we additionally release images with stability tags (wodby/mariadb:10.1-X.X.X) which correspond to git tags. We strongly recommend using images only with stability tags.

Environment Variables

Variable	10.2	10.1
MYSQL_BACK_LOG	100	100
MYSQL_CHARACTER_SET_FILESYSTEM	utf8	utf8
MYSQL_CHARACTER_SET_SERVER	utf8	utf8
MYSQL_CLIENT_DEFAULT_CHARACTER_SET	utf8	utf8
MYSQL_COLLATION_SERVER	utf8_unicode_ci	utf8_unicode_ci
MYSQL_DATABASE
MYSQL_DEFAULT_STORAGE_ENGINE	InnoDB	InnoDB
MYSQL_DUMP_MAX_ALLOWED_PACKET	1G	1G
MYSQL_GENERAL_LOG	1	1
MYSQL_INIT_CONNECT	SET NAMES utf8	SET NAMES utf8
MYSQL_INNODB_BUFFER_POOL_INSTANCES	4	4
MYSQL_INNODB_BUFFER_POOL_SIZE	1G	1G
MYSQL_INNODB_DATA_FILE_PATH	ibdata1:10M:autoextend:max:10G	ibdata1:10M:autoextend:max:10G
MYSQL_INNODB_FAST_SHUTDOWN	1	1
MYSQL_INNODB_FILE_FORMAT	-	barracuda
MYSQL_INNODB_FILE_PER_TABLE	1	1
MYSQL_INNODB_FLUSH_LOG_AT_TRX_COMMIT	2	2
MYSQL_INNODB_FLUSH_METHOD	O_DIRECT	O_DIRECT
MYSQL_INNODB_FORCE_LOAD_CORRUPTED	0	0
MYSQL_INNODB_IO_CAPACITY	200	200
MYSQL_INNODB_LARGE_PREFIX	-	1
MYSQL_INNODB_LOCK_WAIT_TIMEOUT	50	50
MYSQL_INNODB_LOG_BUFFER_SIZE	8M	8M
MYSQL_INNODB_LOG_FILE_SIZE	128M	128M
MYSQL_INNODB_LOG_FILES_IN_GROUP	2	2
MYSQL_INNODB_OLD_BLOCKS_TIME	1000	1000
MYSQL_INNODB_OPEN_FILES	1024	1024
MYSQL_INNODB_READ_IO_THREADS	4	4
MYSQL_INNODB_STATS_ON_METADATA	OFF	OFF
MYSQL_INNODB_STRICT_MODE	OFF	OFF
MYSQL_INNODB_WRITE_IO_THREADS	4	4
MYSQL_INTERACTIVE_TIMEOUT	420	420
MYSQL_JOIN_BUFFER_SIZE	8M	8M
MYSQL_LONG_QUERY_TIME	2	2
MYSQL_MAX_ALLOWED_PACKET	256M	256M
MYSQL_MAX_CONNECT_ERRORS	100000	100000
MYSQL_MAX_CONNECTIONS	50	50
MYSQL_MAX_HEAP_TABLE_SIZE	16M	16M
MYSQL_NET_READ_TIMEOUT	90	90
MYSQL_NET_WRITE_TIMEOUT	90	90
MYSQL_PASSWORD
MYSQL_PERFORMANCE_SCHEMA	OFF	OFF
MYSQL_PORT	3306	3306
MYSQL_QUERY_CACHE_LIMIT	1M	1M
MYSQL_QUERY_CACHE_MIN_RES_UNIT	2K	2K
MYSQL_QUERY_CACHE_SIZE	128M	128M
MYSQL_QUERY_CACHE_TYPE	ON	ON
MYSQL_RELAY_LOG_RECOVERY	0	0
MYSQL_ROOT_PASSWORD
MYSQL_SLOW_QUERY_LOG	0	0
MYSQL_SORT_BUFFER_SIZE	2M	2M
MYSQL_TABLE_DEFINITION_CACHE	400	400
MYSQL_TABLE_OPEN_CACHE	4096	4096
MYSQL_THREAD_CACHE_SIZE	75	75
MYSQL_TMP_TABLE_SIZE	16M	16M
MYSQL_USER
MYSQL_WAIT_TIMEOUT	420	420

"-" - Not available for this version

Orchestration Actions

Usage:

make COMMAND [params ...]
 
commands:
    import source=</path/to/dump.zip or http://example.com/url/to/dump.sql.gz> [db root_password host ignore="table1;table2;cache_%"] 
    backup filepath=</path/to/backup.sql.gz> [root_password host db nice ionice] 
    query query [db user password host] 
    query-silent query [db user password host] 
    query-root query [db root_password host]
    check-ready [root_password host max_try wait_seconds]  
    
default params values:
    user $MYSQL_USER
    password $MYSQL_PASSWORD
    db $MYSQL_DATABASE
    root_password $MYSQL_ROOT_PASSWORD
    host localhost
    max_try 1
    wait_seconds 1
    ignore ""
    nice 10
    ionice 7

Deployment

Deploy MariaDB to your own server via Wodby.