version: "3.0"
services:
  shop_db:
    image: mariadb:10.5.5
    container_name: shop_db
    ports:
      - 3306:3306
    environment:
      MYSQL_ROOT_PASSWORD: "root"
      MYSQL_DATABASE: "open_shop"
      MYSQL_ROOT_HOST: "%"
    command: [
      '--innodb-flush-method=fsync',
      '--innodb-buffer-pool-size=20M',
      '--character-set-database=utf8mb4',
      '--character-set-server=utf8mb4',
      '--collation-server=utf8mb4_unicode_ci',
      '--character-set-client=utf8mb4',
      '--character-set-connection=utf8mb4',
      '--default-time-zone=+8:00',
      '--lower-case-table-names=1'
    ]
    volumes:
      #- ./_sql/init.sql:/docker-entrypoint-initdb.d/init.sql
      - ./mariadb/data:/var/lib/mysql
      - ./mariadb/conf:/etc/mysql/conf.d
    networks:
      - shop_net
networks:
  shop_net:
    external: true