MySQL (mariadb image)
Container: mysql
Red: db_net
Datos: /srv/mysql/data (en el host)
Env file: /etc/fastfood/db.env
Bases y usuarios
- DB keycloak / user keycloak
- DB fastfood / user fastfood
Salud
docker ps --format "table {{.Names}}\t{{.Status}}\t{{.Ports}}"
docker logs --tail=50 mysql
Acceso admin
docker exec -it mysql mysql -uroot -p -h127.0.0.1
Backup
Script: /usr/local/sbin/backup-mysql.sh (dumps a /srv/backups/mysql/)
Schedule
Diario 02:30
30 2 * * * root /usr/local/sbin/backup-mysql.sh