Whoz Splits 530M-Document MongoDB Collection to Cut Backup and Restore Times
Whoz, a SaaS platform for professional services talent management, faced mounting operational strain after its MongoDB worklog collection grew to 530 million documents and 32 GB, with backups taking nearly an hour and restores up to four hours. The core data unit, called a worklog, records time spent by consultants on projects, and rising client numbers combined with finer-grained user entries were accelerating growth year over year. Engineers evaluated three solutions — MongoDB sharding, WiredTiger storage tiering to S3, and application-level partitioning — before ruling out the first two as either overengineered or unsupported. Sharding was dismissed because the problem was data locality rather than query throughput, while MongoDB confirmed that WiredTiger's internal tiering capabilities are not exposed for general use. The team ultimately opted for application-level collection splitting, separating historical worklogs from recent ones while keeping both transparently accessible to the application.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.


Discussion (0)
Log in to join the discussion and vote.
Log in