Are CNAME Aliases for connection strings a good idea?

by SwissCoder   Last Updated February 11, 2019 09:06 AM - source

To be very flexible and move DBs around servers, we came up with the idea of using an alias per DB. So by changing a DNS entry, we can route all queries to a different DB without changing the connection string or re-deployment of the respective client application.

Are there any known drawbacks to this?

So far it seems to be quite a smart idea. Is it?



Related Questions




Oracle 10g Server Client Architechture

Updated June 17, 2017 14:06 PM

What reason could cause AWS RDS connections to

Updated May 17, 2018 15:06 PM