I have a web sever that connects to an internal database through a VPN. There are 2 IPs (primary and secondary) to the database from the web server. How can I setup my /etc/hosts file so that if the primary IP is not available then the secondary IP will be used?
Would this work for my hosts file?
141.131.286.1 abc.efg.datastore.com #primary
141.131.286.237 abc.efg.datastore.com #secondary
The hosts file does not provide such mechanism. If you list two IPs for the same name, only the first one will be used. So, there is no such thing as primary and secondary IPs.
Also, the hosts file does not handle URLs. It just handles names like the ones provided in the question. A URL contains complete path and protocol such as http://host/path/to/resource.
You can't provide resilience or round robin load balancing via the /etc/hosts file - it is not designed for that purpose.
Instead, your options are ... (in no particular order)
/etc/hosts doesn't support round robin but you can write a simple bash script to sed replace an entry tagged with a #RoundRobin comment (or any other tag you wish to use, just reflect it in the grep line in the script).
#!/bin/bash
fqdnips=( $(nslookup sub.domain.com|grep Address:|awk -F\ '{ print $2 }'|grep -v '#') )
new=`printf "${fqdnips[@]}"`
old=`grep "#RoundRobin" /etc/hosts|awk -F\ '{ print $1 }'`
sed -i "s/$old/$new/g" /etc/hosts
The above script grabs the output of nslookup for sub.domain.com and stores it in an array. It then prints the top most value to $new and grabs the existing value for tag #RoundRobin assigned in /etc/hosts ... lastly, it performs a sed replace
/etc/hosts file entry would look like this
127.0.0.1 localhost
::1 localhost
11.12.13.14 sub.domain.com #RoundRobin
Lastly, place this script in the root's crontab to run every hour or so and you'll now have an /etc/host round-robin.
This is particularly useful if you have a coded page that is pulling some data from an API and the DNS lookup for the API server is causing a lot of hang time in the page's script execution... resulting in high cpu consumption for what would otherwise appear to be a simple page. To avoid the costly DNS lookup (particularly if your site is doing hundreds of them per minute do to heavy traffic), you should use /etc/hosts to resolve the FQDN of the remote API server. This will dramatically reduce the CPU usage for pulling the API data and generating the page.
Note that at least on macOS, in contradiction to what the other answers say, the system resolver will return all entries associated with a host name in /etc/hosts instead of stopping at the first.
Easy to setup, please follow the instruction:
Easy way to make this happen would be to just use a public DNS service, like AWS Route53. You can enter multiple IP addresses per A record with priority
abc.efg.datastore.com
10 141.131.286.1
20 141.131.286.237
As long as no certificates are involved this is working and afaik not even against any norms or best practices.
NSLookup or other domain queries will return both addresses. Your app needs to be able to handle this. And yes, the domain needs to be a publicly registered one, not just a local hostname.
Yes multiple IPs in /etc/hosts works. Example, and test;
> echo "192.168.0.141 test
192.168.0.142 test
192.168.0.143 test" >> /etc/hosts
> dig test +short
192.168.0.141
192.168.0.142
192.168.0.143
However, the search mechanism simply goes does the list until it finds a match.
So while the answer to the question as written is YES, it is going to be a challenge. But nothing insurmountable.
Try this: Each of those IP addresses really do need to have differing names.
