Aurora Global Database
Putting Writes on the Global Writer Endpoint at Deployment, Not During the Outage
- Global writer endpoint tracking the current primary across switchover/failover, with extra write safeguards.
- DNS TTL ~5s recommendation and the DNS-change RDS event.
- Cluster-endpoint "-ro" stripping for promoted/manual endpoints.
- RDS Proxy: per-cluster endpoints need repointing; SESSION read-consistency unsupported through the proxy.
Production premise
The endpoint decision trades flexibility for failover semantics. The global
writer endpoint always resolves to the current primary — including after a
switchover or managed failover — and Aurora applies additional write
safeguards to traffic through it during fencing windows. Cluster endpoints
don't follow: a promoted secondary's writer endpoint is its old reader
endpoint minus -ro (my-global.cluster-ro-… becomes my-global.cluster-…),
so applications bound to cluster endpoints need config changes mid-incident.
Reads belong on each Region's own reader endpoint for local latency; RDS
Proxy users must repoint to the new primary's proxy endpoint after promotion.
Failure mode & inflection point
Applications hardcode the primary Region's cluster endpoint. During failover, writes keep aiming at a dead endpoint — or worse, at the recovered but diverged old primary — until someone edits config under pressure. Separately, DNS caches with default TTLs hold the stale global-endpoint record after promotion, and writes land on the fenced Region during the window; AWS's own guidance is that fencing is best-effort, not a guarantee.
Production guardrail
Default: every write path in every Region connects through the global writer endpoint, with DNS TTL at ~5 seconds (AWS's recommendation) and an alarm on the RDS event that signals the global endpoint's DNS change, so you confirm the application registered the new primary before resuming writes. Don't front the global endpoint with a cross-region RDS Proxy — proxy endpoints are per-cluster and need manual repointing anyway.