Globally Distributed Postgres

Summary

Globally distributed Postgres describes a way to serve a conventional CRUD application across regions while keeping Postgres writes directed to one primary and reads near users. Fly’s proxy sends each request to the local application instance, where most requests succeed; when a write reaches a read-only replica, Rails catches PG::ReadOnlySqlTransaction and returns a fly-replay header naming PRIMARY_REGION. The proxy then retries the complete HTTP request inside its network, avoiding per-query cross-region database routing and allowing the application to retain its ordinary connection behavior. The approach can also support session-based read-your-own-writes and replica-freshness checks, but it is not suitable for every workload; the text contrasts it with geographically distributed databases such as CockroachDB.

Takeaways

1. 1

   Fly Postgres can be configured with a writer in one region and read replicas in other application regions; the text presents flyctl postgres create as the command to create such a cluster.

2. 2

   The Rails implementation uses eight lines to detect PG::ReadOnlySqlTransaction and direct Fly’s proxy to replay the request in the primary region.

3. 3

   The pattern is intended for read-heavy applications and is not a cure-all; distributed-by-design databases such as CockroachDB are presented as an alternative for write-heavy scenarios.