Group
  • Database

    Decide if I need read replicas

    Measures whether read scaling is actually your bottleneck before adding replica complexity.

    • Plan & validate
    • Advanced
    • General

Free Prompt

Evaluate whether my app actually needs read replicas or other read-scaling infrastructure, using evidence instead of anxiety. Gather first: current database CPU, memory, and connection utilization under real or load-tested traffic; the read/write ratio of my actual query traffic; the slowest queries and whether they'd be fixed by an index instead of hardware; and cache hit rates if caching exists. Then apply the decision in order: fix slow queries first (indexes, rewrites, pagination), add caching for hot reads second, scale the primary vertically third, and only then consider replicas. If the numbers say a replica is justified, plan it properly: which reads can tolerate replication lag (feeds yes, read-your-own-write no), how the app routes reads versus writes, and what happens when a replica falls behind. Don't add a replica because it sounds like what serious apps do. Don't route reads to a replica where the user expects to immediately see their own write; that's how 'my post vanished' bug reports happen. Deliver: the utilization evidence, the decision with reasoning, and if replicas are justified, the read/write routing plan with the lag-tolerance rule per feature.

What This Does / How This Helps

Runs the actual decision process for read scaling: measure first, fix queries, cache, scale vertically, and only then talk about replicas. Premature scaling is expensive in money and in complexity. A replica means routing logic, lag bugs where users can't see their own writes, and failover runbooks, all to solve a problem that one missing index was actually causing. This prompt forces the evidence before the infrastructure. If the numbers genuinely justify a replica, you get the routing plan with per-feature lag rules, which is the part that keeps 'where did my post go' reports from arriving.

Want to skip doing this by hand?

Fortivibe audits your app for all of the areas these prompts cover (and more).

See What We Check

Related Prompts