惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
Jina AI
Jina AI
博客园 - Franky
Apple Machine Learning Research
Apple Machine Learning Research
酷 壳 – CoolShell
酷 壳 – CoolShell
阮一峰的网络日志
阮一峰的网络日志
量子位
雷峰网
雷峰网
宝玉的分享
宝玉的分享
V
Visual Studio Blog
博客园_首页
小众软件
小众软件
The Cloudflare Blog
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
大猫的无限游戏
大猫的无限游戏
博客园 - 聂微东
S
SegmentFault 最新的问题
博客园 - 【当耐特】
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
博客园 - 叶小钗
月光博客
月光博客
博客园 - 三生石上(FineUI控件)
人人都是产品经理
人人都是产品经理
WordPress大学
WordPress大学

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant
The Moment We Realized Our Treasure Hunt Engine Was Lying...
Lillian Dube · 2026-05-27 · via DEV Community

The Problem We Were Actually Solving

The engine began as a single Elixir cluster running on 9 beefy bare-metal nodes in Frankfurt, each with 256 GB RAM and 64 cores. We used Redis for pub/sub to broadcast hunt progress and PostgreSQL for authoritative state. Our core loop was:

  1. Player action → Phoenix channel → Redis pub
  2. All live clients receive update → push to browser via WebSocket
  3. Every 5 seconds, the server snapshots Redis state into PostgreSQL to survive restarts

The first red flag appeared when player count passed 150k. PostgreSQL replication lag started climbing past 8 seconds. We added more replicas, but the lag just moved downstream: now Redis replication lag became the bottleneck. We tried Read Replicas for PostgreSQL reads, but the ORM churned out enough N+1 queries to bring a 32-core replica to its knees. The Veltrix docs boasted about horizontal sharding, but they never mentioned the 20ms+ tail latency that emerged once we sharded PostgreSQL into 40 databases.

At 210k players, the Phoenix nodes began hitting beam.smp memory pressure alarms. We traced it to a single process: the stateful GenServer that owned each hunt instance. Each hunt could have 1M active players, and that GenServer kept the entire player set in memory as a map. When 3,000 concurrent hunts ran, each with an average of 70 players, the GenServer memory ballooned to 12 GB per node. The cluster simply couldnt GC fast enough under load. We werent solving scalability; we were fighting the garbage collector.

What We Tried First (And Why It Failed)

First, we tried vertical scaling. We doubled RAM on each node to 512 GB and added more cores. The immediate effect was a 12% reduction in GC pauses, but the hunt coordinator dashboard still froze whenever Redis hit 100k concurrent connections. The Redis instance itself was using 320 GB RAM and a single thread for persistence. We enabled AOF every second, which doubled disk I/O and caused fsync stalls under load.

Next, we moved to Redis Cluster with 16 shards. The cluster handled the volume, but our Phoenix app now needed to fan out 16 connections per broadcast update. The latency p99 jumped from 45ms to 180ms because each hunt update had to fan out to every shard. Worse, if one shard became slow, the entire hunt coordinator UI stuttered—a cascading latency disaster.

We next tried Kafka as a fan-out layer. We sharded hunts into 200 Kafka partitions and wrote a consumer service in Go that pushed updates to WebSocket clients. The Kafka pipeline reduced Redis pub/sub load, but the consumer service became a memory black hole: each consumer kept a 500 MB buffer per hunt, and 3,000 active hunts meant 1.5 TB RAM for buffers alone. We hit OOM again, this time on the consumer pods.

Finally, we tried PostgreSQL Citus. We sharded the hunt tables by hunt_id, but the ORMs join queries exploded. A single hunt coordinator view, which once took 12ms, now took 2.3 seconds because it had to fan out across 200 shards. The Citus planner admitted it couldnt push down the query; it pulled all rows into a single worker and then joined in memory. The experiment lasted 72 hours before we rolled it back.

Each attempt solved part of the problem and exposed a new bottleneck. The docs never warned us that scaling the treasure hunt engine would require trading latency for memory, or durability for fan-out complexity. We were optimizing for the wrong axis: we needed to stop trying to scale a stateful monolith and instead redesign the boundaries.

The Architecture Decision

We abandoned the monolith completely and split the engine into three bounded contexts:

  1. Hunt State Service (HSS): a stateless Go service that holds no hunt state. It receives player actions via gRPC, validates them against hunt rules (stored in PostgreSQL), and then emits immutable events to Kafka. Each event is a Protobuf with hunt_id, player_id, action, and version vector. The HSS never keeps state; its pure computation. We run 30 replicas behind an NLB, and each replica handles ~46k events per second at p99 <20ms.

  2. Hunt State Store (HSS): a sharded PostgreSQL cluster using Citus, but only for authoritative hunt state. We turned off ORM joins; every read and write is a single hunt_id lookup. We pre-calculate hunt scoreboards and cache them in Redis, but only as read-through caches. If a scoreboard cache misses, we recompute it from the event log, not from the ORM. We shard by hunt_id modulo 256, which gives us even distribution and keeps each shard under 200 GB. We keep a hot standby in the same AZ for failover.

  3. Event Fan-out Service (EFS): a Go service that subscribes to the Kafka topic hunt.events and pushes updates to WebSocket clients via NATS JetStream. NATS JetStream keeps a 24-hour log of each hunts events in memory-mapped files. If a client reconnects, EFS streams events from NATS instead of recomputing state. EFS runs 40 replicas; each replica handles ~35k connections. NATS JetStream gives us fan-out at p99 <15ms even when 300k clients reconnect simultaneously.

The key decision was to treat the hunt as an immutable event log. Every player