If you use MariaDB drivers.

mwcampbell · on June 10, 2017

Can 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 · on June 10, 2017

IIRC, 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 · on June 10, 2017

Why 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 · on June 10, 2017

I 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/Concep...