Right now we have our servers hitting our primary mysqld directly.
In the event of an outage, we have to manually change ALL the config files which are pointing at the primary. The oth...
I don't think you'd want to have an app doing a DNS lookup to find out which IP address to connect to for SQL calls. The latency involved would probably be a major issue.