Polat
Race condition on balance updates: Pessimistic Lock or Redlock?
Keep the invariant in the DB with an atomic `UPDATE ... WHERE balance >= 40` or a `SELECT ... FOR UPDATE`, and save Redlock for non-DB resources.
Just Ask
Questions and answers on software architecture, PHP, Go and careers
Ask me anything about software architecture, careers, PHP, Go and the craft of building software; I answer here, in the open, for everyone. (Page 5/8)
Ask a question
Whatever's on your mind, don't hold back. Questions reach me directly; I answer the good ones and publish them on this page. Your email is never published.
Answered questions
Gökhan
How do I handle poison-pill messages and a Dead Letter Queue in the queue?
Put `tries` and a `backoff` on the job so it lands in `failed_jobs` at the cap, alert from a `JobFailed` listener and replay it with `queue:retry`.
Eren
Health check design: how do I separate Liveness and Readiness?
Keep liveness dependency-free and check dependencies in readiness with a cached probe, since liveness restarts the pod while readiness only sheds traffic.
Furkan
How do I migrate a table to PostgreSQL partitioning with zero downtime?
Stand up monthly RANGE declarative partitioning on `created_at`, backfill history in batches while the app writes, then swap names in a single transaction.
Sinan
What rules should I follow to prevent database deadlocks?
Acquire locks in one global order such as ascending PK, keep transactions short, target `FOR UPDATE` at the fewest rows, and retry the rest with backoff.
Oğuz
How do I handle panics in a Go HTTP server with recovery middleware?
Wrap requests in a `defer recover()` middleware at the outermost layer, log the stack with the request id, return a generic 500 and emit a metric.
Levent
Disaster recovery: how do I design an active-passive scenario around RTO and RPO?
RPO 5min buys continuous cross-region replication and PITR, RTO 30min an IaC-provisioned warm standby behind Route 53 failover, rehearsed on a game-day.
Serkan
How do I prevent log storms and disk-full outages?
Collapse repeated errors into one counted line, back off retries, cap logrotate by size and count, and give `/var/log` a volume off the root disk.
Murat
How do I build smart rate limiting against distributed brute force and DDoS?
Per-IP limits lose to rotating proxies, so key the Redis sliding-window on account + IP + ASN, add account lockout and leave volumetric floods to the edge.
Hakan
Graceful degradation: how do I isolate non-critical services under load?
Split the critical path (browse, cart, checkout) from the nice-to-haves, put those behind feature flags with short timeouts, and rehearse the kill-switch.