惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

V
V2EX - 技术
D
DataBreaches.Net
阮一峰的网络日志
阮一峰的网络日志
Recent Announcements
Recent Announcements
V
V2EX
Hugging Face - Blog
Hugging Face - Blog
T
The Exploit Database - CXSecurity.com
Simon Willison's Weblog
Simon Willison's Weblog
Cisco Talos Blog
Cisco Talos Blog
Microsoft Security Blog
Microsoft Security Blog
C
Cyber Attacks, Cyber Crime and Cyber Security
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
K
Kaspersky official blog
F
Fortinet All Blogs
GbyAI
GbyAI
Forbes - Security
Forbes - Security
The Cloudflare Blog
博客园 - 司徒正美
博客园_首页
量子位
Schneier on Security
Schneier on Security
G
GRAHAM CLULEY
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
P
Proofpoint News Feed
N
News | PayPal Newsroom
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
博客园 - 聂微东
T
Tor Project blog
V
Vulnerabilities – Threatpost
Y
Y Combinator Blog
Jina AI
Jina AI
Help Net Security
Help Net Security
T
Threat Research - Cisco Blogs
Recent Commits to openclaw:main
Recent Commits to openclaw:main
C
Cybersecurity and Infrastructure Security Agency CISA
Project Zero
Project Zero
N
News and Events Feed by Topic
I
Intezer
B
Blog
美团技术团队
C
CERT Recently Published Vulnerability Notes
NISL@THU
NISL@THU
L
LINUX DO - 最新话题
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Blog — PlanetScale
Blog — PlanetScale
AWS News Blog
AWS News Blog
T
Tailwind CSS Blog
The Last Watchdog
The Last Watchdog
雷峰网
雷峰网
有赞技术团队
有赞技术团队

The Practical Developer

The Libuv Thread Pool Trap: Why Node.js Async APIs Stall Under Load Postgres Covering Indexes with INCLUDE: Eliminate Heap Fetches on Read-Heavy Workloads Postgres DISTINCT ON: The Fastest Way to Get the Latest Row Per Group Postgres Transaction Isolation: The Anomalies Your App Actually Faces in Production Linux TCP Tuning for Node.js Microservices: The Kernel Settings That Stop Silent Connection Drops Under Load Postgres HOT Updates and Fillfactor: Why Not All Writes Are Created Equal Database Connection Pool Leaks: Finding the Promise That Never Returns Its Seat Linux OOM Killer in Production: Why Your Node.js Containers Die Without a Stack Trace Postgres Materialized Views: Refresh Strategies That Do Not Lock Your Dashboards API Dependency Health Checks: Why /health Is Not Enough Authorization with Zanzibar Tuples: How Google Manages Permissions and How To Build the Same Check in Node.js Postgres Advisory Locks: The 20-Character Primitive That Replaces Redis for Coordination Dead Letter Queues: The Message Queue Pattern That Saves You at 2 a.m. File Descriptor Exhaustion: The Kernel Limit That Silently Drops Node.js Connections Graceful Degradation: The Pattern That Turns Total Outages into Partial Success PostgreSQL Full-Text Search: Dropping Elasticsearch for 90% of Use Cases S3 Presigned Multipart Uploads: Stop Your API Server from Being a File Upload Bottleneck MessagePack vs JSON: The Binary Serialization Switch That Cut Our Internal RPC Overhead by 40% DNS Caching in Node.js: The Silent Cause of Production Latency Spikes Reliable Cron Jobs: The Pattern That Stops Double Runs, Missed Executions, And The 2 AM Page GraphQL Query Complexity: Stop the OOM Query Before It Reaches Your Resolver Node.js Event Loop Lag: The Hidden Metric Behind Random Latency Spikes API Request Validation with Zod: The Schema That Catches Bad Input Before It Corrupts Your Database Load Shedding in Node.js: How to Reject Traffic Before You Drown Request Hedging: Cut Tail Latency In Half Without Overprovisioning Git Bisect: The Automated Binary Search That Finds Breaking Commits in Minutes Node.js Garbage Collection Tuning: Stop Letting V8 Pause Your Event Loop Node.js Server Timeouts: The Settings That Stop Slow Clients from Holding Sockets Hostage Postgres BRIN Indexes: The Time-Series Secret That Shrinks Indexes by 99% Event Sourcing with PostgreSQL: The Pragmatic 80% Solution Node.js Cluster Mode: Scaling the Event Loop Across CPU Cores Postgres Partial Indexes: Stopping Soft Deletes from Ruining Your Query Performance Request Coalescing with the Singleflight Pattern: Stop Drowning Your Database on Every Cache Miss The Bulkhead Pattern: Why One Slow Endpoint Should Not Drown Your Whole Service Node.js AsyncLocalStorage: End-to-End Request Context Without the Propagation Hell Postgres Deadlocks: Logging the Victim, Reproducing the Race, and Fixing the Lock Order Your Node.js HTTP Client Is the Bottleneck: Connection Pool Tuning That Works Optimistic Locking in Postgres: Stop Losing Data to Race Conditions Postgres Read Replicas: Stop Serving Stale Data to Your Users Cursor Pagination: Why Offset Queries Explode at Scale and How to Fix Them Node.js Worker Threads: 60 Lines That Stop a CSV Upload from Timing Out Every Other Request Reliable Webhook Delivery: Architecture for Outbound HTTP You Can Trust Request Timeouts and Deadline Propagation: Stop the Chain of Slowness Advanced Security Practices in Node.js Graceful Shutdown in Node.js: The 40 Lines That Stop 502s During Deploys Finding Node.js Memory Leaks with Heap Snapshots Idempotency Keys in 30 Lines: Stop Your Webhook From Charging Customers Twice Backpressure In Node.js: The Fix For Slow-Motion Queue Meltdowns Retries Done Right: Jitter, Budgets, and the Stampede You Did Not See Coming The Cache Stampede: Why Your "Just Add Redis" Layer Crashes Postgres at 3 a.m. Postgres SKIP LOCKED: An 80-Line Job Queue You Can Run Without Redis Stop Doing Work Nobody Wants: AbortController in Node.js, Done Right The N+1 Query Problem: We Found 23 In One Codebase And Killed Every One I Tried 5 AI Coding Tools for a Month. Here Is What I Actually Use CI/CD From Zero to Production in 30 Minutes With GitHub Actions Node.js vs Bun vs Deno: Which Runtime Should You Pick in 2025? Kubernetes Resource Requests And Limits: The Numbers That Decide If Your Cluster Is Stable The Three Pillars of Observability Are A Myth: What Actually Matters In Production pnpm Vs npm Vs yarn Vs Bun For Monorepos: Which One Earns The Migration In 2024 JSONB Indexing In Postgres: GIN Vs Expression Indexes, And When Each Is The Right Choice A Code Review Checklist That Ends The Same Three Arguments Every Sprint gRPC Vs REST In 2024: When The Switch Pays For Itself React Suspense For Data Fetching: The Pattern That Replaces Half Your Loading State Code The Five-Stage Rollout: How To Ship A Risky Change Without Holding Your Breath GitHub Actions In A Monorepo: Caching, Path Filters, And Secret Boundaries That Actually Work The Blameless Postmortem That Actually Improves Things: A Template And Six Hard-Won Rules Recursive CTEs In Postgres: How To Query A Tree Without N Round Trips Node.js Streams: When They Actually Help, And When They Just Add Complexity Playwright Vs Cypress In 2024: The Honest Comparison Of Which One Earns The Test Time React Server Components: The Mental Model That Makes The "use client" Boundary Obvious Pod Disruption Budgets: The K8s Object That Keeps Your Service Up During Cluster Maintenance Postgres LISTEN/NOTIFY: The Pub/Sub You Already Have And Are Not Using Chaos Engineering Starter Kit: The Five Drills That Don't Need Netflix-Scale Spec-Driven API Development With OpenAPI: How To Stop Drifting From Your Docs Kubernetes Autoscaling Beyond CPU: The Custom-Metric HPA Pattern That Actually Works Postgres Partitioning For Time-Series: The Boring Setup That Saves Your Database Distributed Locks With Redis: An Honest Look At Redlock And When You Don't Need It HTTP/2 vs HTTP/3: What Actually Changes For Your App, And What Doesn't Image Optimization For The Web In 2023: srcset, AVIF, And The Lighthouse Score You Actually Want Kafka vs RabbitMQ: A Decision Tree That Doesn't Hate You UUID vs Bigint Primary Keys In Postgres: The Index Math That Decides For You Flame Graphs: How To Find The Slow Function In 30 Seconds Without Profiling Theatre Postgres Streaming Vs. Logical Replication: Which One Solves Your Actual Problem ESLint Rules That Earn Their Keep: The Twelve I Enable On Every Project Pre-Commit Hooks That Pay For Themselves: Husky, lint-staged, And The Five Rules That Stick Zero-Downtime Database Migrations: The Six-Step Pattern That Rules Them All Circuit Breakers In Node.js: 50 Lines That Stop A Failing Dependency From Taking Down Your Service Postgres VACUUM Is Not Magic: How Your Hot Table Bloats To 80GB And How To Fix It Kubernetes Liveness And Readiness Probes: The Difference That Causes Half Your Outages Rate Limiting In Production: A Token Bucket In 30 Lines Of Redis The Outbox Pattern: How To Stop Losing Events When Postgres And Kafka Disagree Load Testing With k6: The Three Scenarios That Find Real Bugs (Not Synthetic Numbers) Postgres Row-Level Security For Multi-Tenant Apps: The Pattern That Stops You From Leaking Data Rebase vs. Merge: The Team Policy That Ends The Argument Forever OpenTelemetry in Node.js: Distributed Tracing That Actually Helps During an Incident Feature Flags That Pay Rent: The 4 Flag Types And When To Delete Each ETag, Last-Modified, and the Caching Headers Most APIs Get Wrong Connection Pooling Without the Cargo Cult: pgbouncer in 100 Lines of Config JSONB Is Not a Schema: When To Reach For It in Postgres, And When To Stop Bash Strict Mode: The Three Lines That Stop Your Deploy Script From Lying To You
SLOs Without The Theatre: How To Pick Three Numbers That Actually Help
The Practica · 2023-12-08 · via The Practical Developer

The team reads the Google SRE book and decides to “do SLOs.” Three months later, every service has 8 SLIs, dashboards everywhere, and nobody has actually used the SLO data to make a decision. The error budget exists in a spreadsheet that gets updated quarterly. Reliability has not measurably improved.

SLOs done well are not bureaucratic. They are two numbers per service and one rule that applies them: when the error budget is gone, stop shipping features and fix reliability instead. That is the entire mechanism. Everything else is optional.

This post is the version that works for normal-sized teams: how to pick the SLI, set the SLO, calculate the error budget, and tie it to actual decisions.

The terms, briefly

SLI (Service Level Indicator). A measurement. “Percentage of HTTP requests that returned 2xx within 500ms.”

SLO (Service Level Objective). The target. “99.5% of requests over the trailing 30 days.”

Error budget. The gap between perfection and the SLO. If your SLO is 99.5%, your error budget is 0.5%. Over 30 days, that’s 216 minutes of allowed badness. If you’ve used 200 minutes, you have 16 minutes of error budget left.

SLA (Service Level Agreement). A contract. “We refund customers if we drop below 99%.” Looser than the SLO; SLO is internal target, SLA is what you promise outside.

Most teams confuse SLO and SLA. The SLA exists for sales / legal; the SLO is the internal target. SLO is always tighter than SLA.

Pick two SLIs per service

The biggest mistake is having too many SLIs. The right number is two. Pick one availability SLI and one latency SLI:

Availability SLI: percentage of valid requests that succeeded.

SLI = (valid_responses_2xx_3xx + valid_responses_4xx_excluding_429) / total_valid_responses

The 4xx exclusion is important. A user sending a malformed request is not a service failure. 429 (rate limited) is included because it’s the service deciding to fail; 400 / 401 / 403 / 404 are typically excluded.

Latency SLI: percentage of valid requests served within a threshold.

SLI = (requests_under_500ms) / (total_valid_requests)

500ms is a starting point. Pick a number based on user expectations for your service.

For services that aren’t HTTP (queue consumers, batch jobs), the SLIs are different but the same idea: one “did it work” SLI, one “did it work fast enough” SLI.

Pick the SLO based on what users feel

A common trap: setting the SLO at “the current observed level.” If the service is currently at 99.97% availability, setting an SLO of 99.95% means the team is below SLO before they start.

The right SLO is the level at which users start to notice and complain. For most consumer-facing APIs:

  • 99.9%: about 43 minutes/month of downtime allowed. Standard for non-critical SaaS.
  • 99.95%: 22 minutes/month. For revenue-critical paths.
  • 99.99%: 4 minutes/month. Hard to achieve; requires significant investment.
  • 99.999%: 26 seconds/month. Rare; only for infrastructure.

99.9% is the right SLO for most teams. Higher requires actual engineering investment in resilience; you can’t get there by copying a number.

The error budget rule

Here is the entire mechanism: when you have used your error budget, stop shipping features and fix reliability.

If your SLO is 99.9% and you’ve spent 50 minutes of downtime in the last 28 days (out of 40 minutes allowed), you are over budget. The next sprint is not a new feature; it is the work that prevents the next 50 minutes.

This rule is what makes SLOs valuable. Without it, the SLO is decoration, interesting numbers that don’t change anyone’s behavior. With it, the SLO is a forcing function for engineering investment.

The quarterly review

Once a quarter, review the SLOs:

  • Did we hit our targets? If not, why?
  • What did we burn the budget on? (Outages, deploys, dependency failures.)
  • Should the targets change? (Upward if you’re consistently exceeding, downward if you’re consistently failing because of unfixable factors.)
  • What investment moves the needle next quarter?

The right cadence is quarterly. Monthly is too noisy; annual is too slow.

Implementation: Prometheus + Grafana

A working SLO measurement stack is Prometheus collecting metrics and a small set of dashboards. The availability burn-rate query:

1 - (
  sum(rate(http_requests_total{job="api", status!~"5.."}[28d]))
  /
  sum(rate(http_requests_total{job="api"}[28d]))
)

For burn-rate alerts, Sloth or similar generators turn an SLO definition into Prometheus alert rules:

# sloth definition
service: "api"
slos:
- name: "availability"
  objective: 99.9
  sli:
    events:
      error_query: 'sum(rate(http_requests_total{status=~"5.."}[{{.window}}]))'
      total_query: 'sum(rate(http_requests_total[{{.window}}]))'
  alerting:
    page_alert: { labels: { severity: page } }
    ticket_alert: { labels: { severity: ticket } }

Sloth generates the alert rules: page on a fast burn (using budget too quickly), ticket on a slow burn. The alerts say “you’re going to be out of budget in X hours if this continues,” which is meaningful.

Multi-burn-rate alerts

A naive “alert when SLI is below SLO” fires on every blip. The better pattern is multi-burn-rate: alert when you’re burning budget too fast relative to the time window.

  • High burn rate over 5 min → page (something is wrong right now).
  • Medium burn rate over 1 hour → page (sustained degradation).
  • Low burn rate over 6 hours → ticket (slow leak, fix this week).

The math: if your SLO is 99.9% (0.1% error budget), a burn rate of 14× means you’d consume the entire 30-day budget in ~50 hours. That’s the threshold for a fast-burn page.

Sloth, Pyrra, Nobl9 all generate these alerts from a simple SLO definition.

SLOs for things that aren’t HTTP

For queue consumers:

  • Availability: 99.9% of jobs complete (after retries) within their TTL.
  • Latency: 99% of jobs complete within N seconds of being enqueued.

For batch jobs:

  • Availability: % of scheduled runs that complete successfully.
  • Latency: % of runs that complete within their SLO duration.

For a database:

  • Availability: % of queries that succeed.
  • Latency: % of queries under N ms.

The pattern is the same: pick “did it work” and “fast enough.”

The four traps

1. Tracking too much. 30 SLIs across 10 services, nobody knows which to look at first. Two SLIs per service. Roll up across services for an org-level view.

2. SLO too tight. “We aim for 99.99%” but the team is paged every 3 days. The SLO is wrong; nobody trusts it; it gets ignored. Set the SLO at “what we can credibly hit,” not “what we wish we could.”

3. Ignoring the rule. SLO violated, error budget gone, the team ships a new feature anyway because there’s a deadline. Now the SLO is theatre. The rule is the value; if you can’t enforce it, the SLO is decoration.

4. SLO based on infrastructure, not user impact. “99.9% pod uptime” is not what users care about. Measure user-facing requests, not internal pod health.

When to set SLOs

A common question: how big should the team be before SLOs are useful? Roughly: when there are enough services that prioritization between “feature work” and “reliability work” needs a process. Below that, say 5 engineers, SLOs are overkill.

For a 20-engineer org, SLOs help. For a 100-engineer org, they’re essential. For a 5-engineer startup, just have good monitoring and trust.

The takeaway

Two SLIs per service. SLO at “users notice and complain” level. Error budget determines what the team works on next. Quarterly review. Multi-burn-rate alerts so you know when budget is being spent fast.

That is the whole system. Anything more is process the team will eventually drop. Anything less is dashboards without consequence. The middle is the version that pays back.


A note from Yojji

The kind of reliability process that prevents “we hope it’s reliable” from masking a real problem (SLOs, error budgets, the cadence that ties them to engineering investment) is the kind of long-haul engineering culture Yojji’s teams put into the platforms they ship for clients.

Yojji is an international custom software development company founded in 2016, with teams across Europe, the US, and the UK. They specialize in the JavaScript ecosystem (React, Node.js, TypeScript), cloud platforms (AWS, Azure, GCP), and full-cycle product engineering, including the SRE-adjacent practices that decide whether reliability is measured or just hoped for.