MySQL / MariaDB

Deploy a MySQL or MariaDB database with persistent storage.

Quick Deploy

Go to Services → New Service

Enter service name: mysql and click Create

MYSQL_ROOT_PASSWORD=your-secure-password
MYSQL_DATABASE=myapp
MYSQL_USER=appuser
MYSQL_PASSWORD=app-secure-password

Mount Path	Volume
`/var/lib/mysql`	`mysql-data`

Click Create to deploy.

Image: mysql:8

Environment variables:

Image: mariadb:11

Same environment variables as MySQL.

Use Docker networking:

mysql://appuser:app-secure-password@mysql:3306/myapp

Or with the full container name:

mysql://appuser:password@senate-mysql-xxx:3306/myapp

Exposing databases publicly is a security risk. Use SSH tunnels or VPN instead.

If you must expose externally:

[mysqld]
max_connections = 200
innodb_buffer_pool_size = 1G
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log

/path/to/my.cnf:/etc/mysql/conf.d/custom.cnf:ro

docker exec senate-mysql-xxx mysqldump -u root -p myapp > backup.sql

docker exec -i senate-mysql-xxx mysql -u root -p myapp < backup.sql

Use a cron job or backup service:

#!/bin/bash
DATE=$(date +%Y%m%d)
docker exec senate-mysql-xxx mysqldump -u root -p$MYSQL_ROOT_PASSWORD myapp | gzip > /backups/myapp-$DATE.sql.gz