monday.com's engineering team shares how they migrated board item ID generation from a MySQL auto-increment bottleneck to a distributed, DynamoDB-backed ID Generator Service. The core challenge was maintaining integer IDs due to legacy constraints. The solution uses atomic DynamoDB updates to lease ID ranges, a double-buffering strategy with eager loading to eliminate runtime latency, and strict waste controls. The rollout used shadow mode testing, k6 load testing, and a 5-billion ID safe zone to prevent collisions during gradual traffic migration. The post concludes with a recommendation to use UUIDv7 for new architectures.
Table of contents
The Solution: A Centralized ID GeneratorOptimizing for PerformanceRolling Out with Zero DisruptionIf You Were Starting Today…Sort: