Database Replication: How Production Systems Stay Fast and Available When One DB Fails

One database is fine — until traffic grows or it crashes. Replication is the first real step in scaling: copy writes from a Primary to Replicas so reads scale, failover gets safe, and one machine stops being a single point of failure. Here's how it actually works, what breaks, and the tradeoffs nobody mentions.