# docker-compose.yaml
services:
  mariadb:  # MariaDB SQL Server
    container_name: mariadb
    image: mariadb
    ports:
      - "3306:3306"
    volumes:
      - "/storage/docker/mariadb:/var/lib/mysql"
    environment:
      - MYSQL_DATABASE=ha-mariadb
      - MYSQL_ROOT_PASSWORD=supersecret
      - DB_HOST=http://localhost/
      - TZ=America/Los_Angeles
    restart: unless-stopped

# configuration.yaml
recorder:
  db_url: mysql://root:supersecret@localhost/ha-mariadb?charset=utf8