Deployment & Infrastructure

Infrastructure Architecture

High-Level Diagram

┌──────────────┐     ┌──────────────┐     ┌──────────────────┐
│   Browser    │────>│  VPS Server  │────>│  NeonDB          │
│  (students,  │     │  (Nginx/     │     │  (PostgreSQL 16) │
│   teachers,  │     │   PHP-FPM)   │     │  serverless      │
│   etc.)      │     │  Laravel     │     └──────────────────┘
└──────────────┘     │              │
                     └──────┬───────┘
                            │
                            ▼
                     ┌──────────────┐
                     │   Object     │
                     │   Storage    │
                     │  (S3 Proto)  │
                     └──────────────┘

Minimum VPS Specifications

Component Specification Notes
CPU Minimum 4 Core To handle 750+ CCU
RAM Minimum 8 GB Laravel + PostgreSQL is quite heavy
Storage 100 GB SSD/NVMe I/O speed critical for attendance
Bandwidth 1 Gbps Peak traffic 06:30-07:00
OS Ubuntu 24.04 LTS —

Production Server Stack

Layer Technology Reason
Web Server Nginx + PHP-FPM Lighter than Apache for production
PHP 8.4+ Stable, compatible with Laravel 13
Database PostgreSQL 16 via NeonDB Serverless, auto-scaling, branching, built-in PgBouncer
Cache Redis For session, cache, queue
Queue Redis + Laravel Queue For background jobs (photo upload, etc.)
Object Storage MinIO / Wasabi / Backblaze B2 S3-compatible

Server Configuration

Nginx Virtual Host

server {
    listen 80;
    server_name absen.smauii.sch.id;
    return 301 https://$server_name$request_uri;
}

server {
    listen 443 ssl http2;
    server_name absen.smauii.sch.id;

    root /var/www/smauii-core/public;
    index index.php;

    ssl_certificate     /etc/ssl/certs/smauii.crt;
    ssl_certificate_key /etc/ssl/private/smauii.key;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        fastcgi_pass unix:/var/run/php/php8.3-fpm.sock;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }

    location ~ /\.(ht|env) {
        deny all;
    }
}

PostgreSQL Tuning (Production)

NeonDB handles tuning server-side automatically. For self-managed PostgreSQL:

# postgresql.conf
max_connections = 200
shared_buffers = 1GB
effective_cache_size = 3GB
work_mem = 64MB
maintenance_work_mem = 256MB
random_page_cost = 1.1          # SSD
effective_io_concurrency = 200  # SSD
wal_buffers = 16MB

PHP-FPM Tuning

[www]
pm = dynamic
pm.max_children = 150
pm.start_servers = 20
pm.min_spare_servers = 10
pm.max_spare_servers = 40
pm.max_requests = 500

Object Storage

Architecture

[Laravel App]
    │
    ├── Upload file → S3 Driver (Laravel Filesystem)
    │       │
    │       ▼
    │   [Object Storage]
    │       ├── attendances/{year}/{month}/{nis}_{timestamp}.jpg
    │       └── leave_requests/{year}/{month}/{id_leave}_{document}.pdf
    │
    └── Save URL to database (photo_url, evidence_url)

Object Storage Directory Structure

bucket-smauii/
├── attendances/
│   ├── 2026/
│   │   ├── 06/
│   │   │   ├── 12345_20260622_064512.jpg
│   │   │   ├── 12346_20260622_064530.jpg
│   │   │   └── ...
│   │   └── ...
│   └── ...
├── leave_requests/
│   ├── 2026/
│   │   ├── 06/
│   │   │   ├── IZ001_doctor_letter.pdf
│   │   │   └── ...
│   │   └── ...
│   └── ...
└── temp/  ← for temporary files before validation

Provider Recommendations

Provider Price Capacity Notes
Wasabi ~$7/TB/month Unlimited Hot storage, no egress fees
Backblaze B2 ~$6/TB/month Unlimited Economical, download fees apply
Cloudflare R2 ~$0.015/GB/month Unlimited No egress fees
MinIO (self-hosted) Free Depends on server For on-premise

Laravel Integration

// config/filesystems.php
'disks' => [
    's3' => [
        'driver' => 's3',
        'key' => env('AWS_ACCESS_KEY_ID'),
        'secret' => env('AWS_SECRET_ACCESS_KEY'),
        'region' => env('AWS_DEFAULT_REGION'),
        'bucket' => env('AWS_BUCKET'),
        'url' => env('AWS_URL'),
        'endpoint' => env('AWS_ENDPOINT'), // Important for MinIO/S3-compatible
        'use_path_style_endpoint' => true,
    ],
],

// Upload example
$path = $request->file('photo')->storeAs(
    'attendances/' . now()->format('Y/m'),
    $student->nis . '_' . now()->format('Ymd_His') . '.jpg',
    's3'
);

Environment Variables (Production)

APP_NAME="SMART Absen SMA UII"
APP_ENV=production
APP_DEBUG=false
APP_URL=https://absen.smauii.sch.id

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=smauii_core
DB_USERNAME=smauii_user
DB_PASSWORD=********

SESSION_DRIVER=redis
QUEUE_CONNECTION=redis
CACHE_STORE=redis

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

FILESYSTEM_DISK=s3

AWS_ACCESS_KEY_ID=********
AWS_SECRET_ACCESS_KEY=********
AWS_DEFAULT_REGION=auto
AWS_BUCKET=smauii-presensi
AWS_ENDPOINT=https://s3.wasabisys.com
AWS_URL=https://smauii-presensi.s3.wasabisys.com

Deployment Checklist