ianlintner-wf/mariadb

Generic MariaDB docker image

Generic MariaDB docker image

Join us on Slack

Supported tags and respective Dockerfile links:

• 10.1-2.0.0, 10.1, latest (10.1/Dockerfile)

Environment Variables Available for Customization

Environment Variable	Type	Default Value	Description
MYSQL_ROOT_PASSWORD	String		REQUIRED
MYSQL_USER	String
MYSQL_PASSWORD	String
MYSQL_DATABASE	String
MYSQL_DUMP_MAX_ALLOWED_PACKET	String	1G
MYSQL_PORT	Int	3306
MYSQL_DEFAULT_CHARACTER_SET	String	utf8
MYSQL_INNODB_FILE_FORMAT	String	barracuda
MYSQL_COLLATION_SERVER	String	utf8_unicode_ci
MYSQL_INIT_CONNECT	String	SET NAMES utf8
MYSQL_INIT_CONNECT	String	SET collation_connection = utf8_general_ci
MYSQL_CHARACTER_SET_SERVER	String	utf8
MYSQL_CHARACTER_SET_FILESYSTEM	String	utf8
MYSQL_QUERY_CACHE_TYPE	Int	0
MYSQL_QUERY_CACHE_MIN_RES_UNIT	String	2K
MYSQL_QUERY_CACHE_SIZE	String	128M
MYSQL_QUERY_CACHE_LIMIT	String	256K
MYSQL_THREAD_CACHE_SIZE	Int	0
MYSQL_TABLE_OPEN_CACHE	String	1024
MYSQL_TMP_TABLE_SIZE	String	16M
MYSQL_KEY_BUFFER_SIZE	String	32M
MYSQL_MAX_ALLOWED_PACKET	String	256M
MYSQL_MAX_CONNECTIONS	Int	50
MYSQL_INNODB_FILE_PER_TABLE	String	true
MYSQL_INNODB_FILE_FORMAT	String	barracuda
MYSQL_INNODB_LARGE_PREFIX	String	true
MYSQL_INNODB_STRICT_MODE	Int	0
MYSQL_INNODB_OPEN_FILES	Int	1024
MYSQL_INNODB_FLUSH_LOG_AT_TRX_COMMIT	Int	2
MYSQL_INNODB_BUFFER_POOL_SIZE	String	1G
MYSQL_INNODB_LOG_BUFFER_SIZE	String	8M
MYSQL_INNODB_LOG_FILE_SIZE	String	32M
MYSQL_LONG_QUERY_TIME	Int	2
MYSQL_SLOW_QUERY_LOG	Int	0
MYSQL_GENERAL_LOG	Int	1

Actions

Usage:

make COMMAND [params ...]
 
commands:
    import source=</path/to/dump.zip or http://example.com/url/to/dump.sql.gz> [db=<db name> root_password=<pass> host=<mariadb>]   
    backup filepath=</path/to/backup.sql.gz> [root_password=<pass> host=<mariadb> db=<db name>] 
    query query=<SELECT 1> [db=<dbname> user=<mysql> password=<pass> host=<mariadb>] 
    query-silent query=<SELECT 1> [db=<dbname> user=<mysql> password=<pass> host=<mariadb>] 
    query-root query=<SELECT 1> [db=<dbname> root_password=<pass> host=<mariadb>]
    check-ready [root_password=<pass> host=<mariadb> max_try=<8> wait_seconds=<5>] 
    
default params values:
    user $MYSQL_USER
    password $MYSQL_PASSWORD
    db $MYSQL_DATABASE
    root_password $MYSQL_ROOT_PASSWORD
    host localhost
    max_try 12
    wait_seconds = 5

Examples:

# Check if MariaDB is ready
docker exec -ti [ID] make check-ready -f /usr/local/bin/Makefile

# Run query
docker exec -ti [ID] make query query="CREATE TABLE test (a INT, b INT, c VARCHAR(255))" -f /usr/local/bin/Makefile

# Backup default database
docker exec -ti [ID] make backup filepath="/path/to/mounted/dir/backup.sql.gz" -f /usr/local/bin/Makefile

# Import from file
docker exec -ti [ID] make import source="/path/to/mounted/dir/export.sql.gz"

# Import from URL
docker exec -ti [ID] make import source="https://example.com/url/to/sql/dump.zip"

You can skip -f option if you use run instead of exec.

Using in Production

Deploy MariaDB container to your own server via Wodby.