Catalogue
- Cards
- 165
- Records
- 486
- Workloads
- 19
- Corpus version
- 74847648e25a
16 of 486 records match.
| Kind | Record | Organisation | Year | Setup |
|---|---|---|---|---|
| Decision | Batch ping writes with COPY in one transaction instead of calling a stored procedure once per ping | Healthchecks.io | 2025 | One database |
| Decision | Cache not-found results for UUID ping URLs so repeated pings to missing checks skip the database | Healthchecks.io | 2025 | One database |
| Decision | Store user segment membership for 270M+ users in roaring bitmaps downloaded from S3 at startup instead of Bloom filters | Grab | 2023 | Sharded |
| Decision | Enforce per-user frequency caps with a Redis sorted-set sliding log instead of DynamoDB or a sliding window limiter | Grab | 2023 | Sharded |
| Decision | Preload the Lua script via SCRIPT LOAD and pipeline per-user EVALSHA calls to avoid Redis Cluster CROSSSLOT errors | Grab | 2023 | Sharded |
| Decision | Scale ZippyDB keyspaces online via logical-to-physical shard indirection and coordinator-worker resharding | Meta | 2023 | Sharded |
| Decision | Offload Instagram-to-Threads follow-graph mirroring and notifications to rate-limited Async workers | Meta | 2023 | Sharded |
| Failure | A viral customer's pageviews backlog the shared queue for all sites while the database runs out of disk IOPS | Fathom Analytics | 2020 | One database |
| Failure | Unindexed backlog tables and a text-typed site ID kept the database slow after the disk was fixed | Fathom Analytics | 2020 | One database |
| Decision | Cap concurrent queue workers on purpose to protect the database, accepting a bigger backlog | Fathom Analytics | 2020 | One database |
| Decision | Limit pageviews processed per site per minute so one viral site cannot block the rest, then drop it | Fathom Analytics | 2020 | One database |
| Failure | Database contention filled Redis memory, and a full Redis could neither accept nor release jobs | Slack | 2017 | Sharded |
| Decision | Added Kafka in front of the Redis job queue instead of replacing Redis | Slack | 2017 | Sharded |
| Decision | Enqueue path acknowledges after the Kafka leader only, trading a small risk of lost jobs for latency | Slack | 2017 | Sharded |
| Failure | A hundred checker Lambdas each opened a database connection at once, and Postgres refused further connections | OnlineOrNot | One database | |
| Decision | Fan results in through SNS and a batching queue so one Lambda writes to Postgres, instead of upgrading the database | OnlineOrNot | One database |