mysql@.service

[Unit]
Description=%p-%i

# Requirements
Requires=docker.service

# Dependency ordering
After=docker.service
Before=backup@%i.timer

# Dependency binding
BindsTo=lamp@%i.service

[Service]
Restart=always
ExecStartPre=-/usr/bin/docker kill %p-%i
ExecStartPre=-/usr/bin/docker rm %p-%i
ExecStartPre=/bin/bash -euxc ' \
  mysql_folder=/data/domains/%i/mysql; \
  if [ ! -d /data/runtime/domains/%i/mysql ]; then \
    if [ ! -d $mysql_folder ]; then \
      mkdir -p $mysql_folder; \
      pass=`echo $RANDOM  ${date} | md5sum | base64 | cut -c-10`; \
      echo MYSQL_PASS=$pass > $mysql_folder/.env; \
      mkdir -p /data/runtime/domains/%i/mysql; \
    fi; \
  fi'

ExecStart=/usr/bin/docker run \
  --name %p-%i \
  -v /data/runtime/domains/%i/%p/db_files:/var/lib/mysql \
  -e STARTUP_SQL="/data/domains/%i/%p/dump.sql" \
  --env-file /data/domains/%i/%p/.env \
  pierreozoux/mysql
ExecReload=/usr/bin/docker restart %p-%i
ExecStop=/usr/bin/docker stop %p-%i

[Install]
WantedBy=multi-user.target