Re:Introducing Cloud Spanner, a Global Database Service
by macintux on Tuesday February 14, 2017 @02:58PM
(#13646590)
How does Aurora know that the primary is dead? Automatic failover is problematic in a distributed system.
[ Parent
| on HN ]
Re:Introducing Cloud Spanner, a Global Database Service
by CaveTech on Tuesday February 14, 2017 @03:26PM
(#13646804)
AWS uses heartbeats for detecting liveliness. If x heartbeats fail the failover procedure is started. Generally 10s - 5minutes. In practice (for me) the failover has been less than 15s.
Re:Introducing Cloud Spanner, a Global Database Service
by macintux on Tuesday February 14, 2017 @03:37PM
(#13646903)
My concern was more around split brain. If you fail over while the write master is simply unreachable, pain results.
Re:Introducing Cloud Spanner, a Global Database Service
by edaemon on Tuesday February 14, 2017 @04:38PM
(#13647449)
Aurora's read replicas share the underlying storage that the primary uses, so AWS claims that there's no data loss on failover. They also claim -- and I've never heard anyone say they were wrong -- that Aurora failovers take less than a minute. So the pain should be limited to under a minute of lost writes, which most applications can handle (with an error). It can still be painful depending on the application.
See here for more info: https://aws.amazon.com/rds/aurora/faqs/#high-availability-an...
Re:Introducing Cloud Spanner, a Global Database Service
by xapata on Tuesday February 14, 2017 @03:16PM
(#13646717)
Yeah, the latency on that failover isn't specified.
Re:Introducing Cloud Spanner, a Global Database Service
by edaemon on Tuesday February 14, 2017 @04:48PM
(#13647525)
Do you mean the amount of time it takes to initiate a failover or the amount of time for a failover to complete?
For the former, I don't think they specify beyond "automatic".
For the latter, "service is typically restored in less than 120 seconds, and often less than 60 seconds": http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Aurora...