db-compose.yml

version: "3.8"

services:
  erpnext-db:
    image: mariadb:10.6
    container_name: erpnext-db
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_ROOT_PASSWORD}
      MYSQL_DATABASE: ${DB_NAME}
      MYSQL_USER: ${DB_USER}
      MYSQL_PASSWORD: ${DB_PASSWORD}
    command:
      - --character-set-server=utf8mb4
      - --collation-server=utf8mb4_unicode_ci
      - --skip-character-set-client-handshake
      - --skip-innodb-read-only-compressed
      - --max-connections=1000
      - --innodb-buffer-pool-size=1G
    volumes:
      - erpnext-db-data:/var/lib/mysql
      - ./backups:/backups
    ports:
      - "3306:3306"
    networks:
      - erpnext-network
    restart: unless-stopped
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "root", "-p${DB_ROOT_PASSWORD}"]
      timeout: 20s
      retries: 10

  redis-cache:
    image: redis:6.2-alpine
    container_name: redis-cache
    command: redis-server --maxmemory 512mb --maxmemory-policy allkeys-lru --appendonly yes
    volumes:
      - redis-cache-data:/data
    ports:
      - "6379:6379"
    networks:
      - erpnext-network
    restart: unless-stopped
    healthcheck:
      test: ["CMD", "redis-cli", "ping"]
      interval: 30s

  redis-queue:
    image: redis:6.2-alpine
    container_name: redis-queue
    command: redis-server --appendonly yes
    volumes:
      - redis-queue-data:/data
    ports:
      - "6380:6379"
    networks:
      - erpnext-network
    restart: unless-stopped
    healthcheck:
      test: ["CMD", "redis-cli", "ping"]
      interval: 30s

  # FIXED: Added missing redis-socketio service
  redis-socketio:
    image: redis:6.2-alpine
    container_name: redis-socketio
    command: redis-server --appendonly yes
    volumes:
      - redis-socketio-data:/data
    ports:
      - "6381:6379"
    networks:
      - erpnext-network
    restart: unless-stopped
    healthcheck:
      test: ["CMD", "redis-cli", "ping"]
      interval: 30s

volumes:
  erpnext-db-data:
  redis-cache-data:
  redis-queue-data:
  redis-socketio-data:  # FIXED: Added missing volume

networks:
  erpnext-network:
    external: true
    name: ${NETWORK_NAME}