alfigusman0/backend-dbbackup repository overview

version: '3.9'
services:
  backend:
    image: alfigusman0/backend-dbbackup:latest
    container_name: dbbackup-api
    restart: unless-stopped
    pull_policy: always
    ports:
      - "${PORT:-4000}:4000"
    env_file: .env
    environment:
      NODE_ENV: production
      TZ: ${TZ:-Asia/Jakarta}
      DB_HOST: mysql
      DB_PORT: "3306"
      DB_USER: ${DB_USER:-backupuser}
      DB_PASS: ${DB_PASS}
      DB_NAME: ${DB_NAME:-backup_manager}
      REDIS_HOST: redis
      REDIS_PORT: "6379"
      REDIS_PASS: ${REDIS_PASS:-}
      JWT_SECRET: ${JWT_SECRET}
      JWT_EXPIRED_IN: ${JWT_EXPIRED_IN:-7d}
      ENCRYPTION_KEY: ${ENCRYPTION_KEY}
      CORS_ORIGINS: ${CORS_ORIGINS}
      FRONTEND_URL: ${FRONTEND_URL}
      GOOGLE_CLIENT_ID: ${GOOGLE_CLIENT_ID:-}
      GOOGLE_CLIENT_SECRET: ${GOOGLE_CLIENT_SECRET:-}
      GOOGLE_REDIRECT_URI: ${GOOGLE_REDIRECT_URI:-}
      LICENSE_SERVER_URL: ${LICENSE_SERVER_URL:-}
      LICENSE_PUBLIC_KEY: ${LICENSE_PUBLIC_KEY:-}
      LOG_LEVEL: ${LOG_LEVEL:-info}
    depends_on:
      mysql:
        condition: service_healthy
      redis:
        condition: service_healthy
    networks: [dbbackup-network]
    healthcheck:
      test: ["CMD", "wget", "-qO-", "http://localhost:4000/health"]
      interval: 30s
      timeout: 10s
      retries: 3
      start_period: 30s

  frontend:
    image: alfigusman0/frontend-dbbackup:latest
    container_name: dbbackup-frontend
    restart: unless-stopped
    pull_policy: always
    ports:
      - "${FRONTEND_PORT:-3001}:3000"
    environment:
      NEXT_PUBLIC_API_URL: ${NEXT_PUBLIC_API_URL:-http://localhost:4000}
    depends_on:
      backend:
        condition: service_healthy
    networks: [dbbackup-network]
    healthcheck:
      test: ["CMD", "wget", "-qO-", "http://localhost:3000"]
      interval: 30s
      timeout: 10s
      retries: 3
      start_period: 40s

  mysql:
    image: mysql:8.0
    container_name: dbbackup-mysql
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_ROOT_PASS}
      MYSQL_DATABASE: ${DB_NAME:-backup_manager}
      MYSQL_USER: ${DB_USER:-backupuser}
      MYSQL_PASSWORD: ${DB_PASS}
    volumes:
      - mysql_data:/var/lib/mysql
    ports:
      - "127.0.0.1:3307:3306"
    networks: [dbbackup-network]
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "root", "-p${DB_ROOT_PASS}"]
      interval: 10s
      timeout: 5s
      retries: 10
      start_period: 30s

  redis:
    image: redis:7-alpine
    container_name: dbbackup-redis
    restart: unless-stopped
    command: >
      redis-server --appendonly yes --requirepass ${REDIS_PASS:-}
      --maxmemory 256mb --maxmemory-policy allkeys-lru
    volumes:
      - redis_data:/data
    networks: [dbbackup-network]
    healthcheck:
      test: ["CMD", "sh", "-c", "redis-cli ${REDIS_PASS:+-a $REDIS_PASS} ping"]
      interval: 10s
      timeout: 5s
      retries: 5

volumes:
  mysql_data:
  redis_data:

networks:
  dbbackup-network:
    driver: bridge

# Timezone
TZ=Asia/Jakarta

# Database MySQL
DB_ROOT_PASS=ganti_password_root_kuat
DB_USER=backupuser
DB_PASS=ganti_password_user_kuat
DB_NAME=backup_manager

# Redis
REDIS_PASS=ganti_redis_password

# Security — WAJIB DIISI
# Generate: openssl rand -hex 32
JWT_SECRET=
# TEPAT 32 karakter: openssl rand -hex 16
ENCRYPTION_KEY=

# URL — sesuaikan dengan IP/domain server
PORT=4000
FRONTEND_PORT=3001
FRONTEND_URL=http://IP_ATAU_DOMAIN:3001
CORS_ORIGINS=http://IP_ATAU_DOMAIN:3001
NEXT_PUBLIC_API_URL=http://IP_ATAU_DOMAIN:4000

# Google OAuth (opsional — untuk Cloud Storage Google Drive)
GOOGLE_CLIENT_ID=
GOOGLE_CLIENT_SECRET=
GOOGLE_REDIRECT_URI=http://IP_ATAU_DOMAIN:4000/api/storages/google/callback

# Lisensi (kosongkan = mode development tanpa validasi)
LICENSE_SERVER_URL=https://license.alfi-gusman.web.id
LICENSE_PUBLIC_KEY=

LOG_LEVEL=info

docker compose pull
docker compose up -d
docker compose ps

POST /api/jobs/:id/run
  → BullMQ Queue (Redis)
      → backupService
          1. Verify connection + storage      (progress 10%)
          2. mysqldump / pg_dump → stream     (progress 20%)
          3. createGzip → compress in-memory  (progress 50%)
          4. upload stream → cloud storage    (progress 100%)
          → simpan cloud_path + download_url
          → kirim notifikasi WhatsApp