Stitch Fix Open Source

Open Source software is a huge part of our success. These projects are our small contribution back.

Stitch Fix Open Source

Strictly enforced Database SLA Techniques Adopt

Scaling

By default, Postgres does not enforce any connection limits or lock timeouts. While this is a sensible default, if you are sharing a single database across many apps—as we are—it creates the ability for one application to take down the entire system.

What we've done instead is to instrument Active Record's connection setup to enforce limits:

What this means is if an application were to suddenly experience poor performance, it would not be able to hold onto database connections while it suffered the outage. This means that while that application will be experiencing trouble, the other applications using that database will not.