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.
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
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.
İpek
How do I design eventual consistency with the Saga Pattern in a distributed system?
Split the transaction into local steps with compensating actions, driven by one orchestrator over a queue, each idempotent and published through an outbox.
Volkan
How do I prevent PostgreSQL split-brain with quorum and consensus?
Don't hand-roll failover: put promotion behind a Patroni + etcd quorum, and let a primary cut off from the majority demote itself by fencing.
Tunç
How do I set up a Circuit Breaker for a flaky third-party API dependency?
A breaker alone won't hold: pull `connect_timeout` and `timeout` down to 800ms-2s, isolate the dependency behind a bulkhead, and define a cached fallback.