HLD-113·Messaging & Queues
Easy · 500 ptsImmutable Enterprise Compliance Audit Log Sink
Design an append-only compliance audit trail pipeline capturing administrative actions across SaaS tenants and serving recent security log queries.
Max p99
≤ 80 ms
Availability
≥ 99.5%
Budget
≤ $2,350
Functional Requirements
- FR-1POST /audit/{org_id}/events — Durably accepts structured security audit events without blocking callers.
- FR-2GET /audit/{org_id}/events — Queries recent tenant audit entries for admin security consoles.
- FR-3Retention & Lifecycle (org_id) — Enforces TTL retention windows, deduplication, or archival compaction without blocking live reads or writes.
- FR-4Must buffer batch audit floods and survive a primary database crash without losing accepted logs.
Workload Profile
Baseline Load5,000 Query Read RPS / 10,000 Audit Write RPS
Batch Sync Flood14,000 Read RPS / 32,000 Write RPS
Active Working Set10 GB hot 7-day tenant audit index
Traffic DistributionWrite-heavy burst from large enterprise org_id tenants
Consistency Model
Asynchronous indexing (< 5s query lag) acceptable; accepted audit records must not be dropped.
Solutions Locked
Sign in and either achieve AC or complete 3 official submissions on this question to inspect community diagrams and writeups.
Loading solutions...
Submission History (0)Select to replay
No submissions yet
Click Submit in the top bar to evaluate against all 7 judge cases and save each run here.
Design Write-up
0 boxes · 0 edges
0 words