5 ms·
Failover time for RDS is high, like a minute or two. That's probably fine for lots of stuff, but not everything.
by paulddraper 9y ago
Failover time for RDS is high, like a minute or two.
That's probably fine for lots of stuff, but not everything.
- mrep 9y agoHow do you get higher availability than that?
- paulddraper 9y agoUse Virtual IP rather than DNS for failover. Minutes is a really long time to go down.
- mrep 9y agoHave you tested that? If you actually have an in-house solution to providing better availability than amazon's RDS options, then I recommend you market your engineering solution to the major cloud providers as they will pay you very well to help them implement your solution to that problem.
- paulddraper 9y ago> Have you tested that? Only all the time. > I recommend you market your engineering solution I saw exactly that company at the last re:Invent. Can't remember what the name was... > to the major cloud providers as they will pay you very well to help them implement your solution to that problem. My guess is that most reasonably sized organization manager their own databases for uptime-critical systems (case in point). It lets them have more control over backups, when to upgrade the database, how to handle failover, etc.
- wahnfrieden 9y agoTake a look at Aurora - around ten seconds.
- paulddraper 9y agoIf you use MariaDB drivers.
- mwcampbell 9y agoCan you link to more info on this? Do you mean using libmariadb, or some other driver (like a JDBC one)? What's the advantage over MySQL's libmysqlclient?
- paulddraper 9y agoIIRC, MariaDB has a table with the IP address of the master, and the MariaDB drivers (not sure which ones exactly) can check that table. That's the only way you can get a 10s failover.
- mwcampbell 9y agoWhy is that the only way to get a 10s failover? The TTL on the DNS records for Amazon RDS, at least for Aurora, is just 5s.
- paulddraper 9y agoI think because route53 is slow to update? I don't know. I do know that AWS itself documents 60-120s for RDS. http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concep...
- deleted 9y ago[deleted]