At the moment during a connect, if a DNS lookup returns multiple IP addresses, only one of the addresses is selected and used.
If we cannot connect to that address, if the other addresses were attempted in turn as well then the client would be more fault tolerant of a server with multiple IP addresses.
One subtlety is the interaction of this feature with the HA feature. I propose that if two server names are provided, each of which resolves to multiple IP addresses then all the addresses of server1 would be attempted before attempting to connect to server2.
At the moment during a connect, if a DNS lookup returns multiple IP addresses, only one of the addresses is selected and used.
If we cannot connect to that address, if the other addresses were attempted in turn as well then the client would be more fault tolerant of a server with multiple IP addresses.
One subtlety is the interaction of this feature with the HA feature. I propose that if two server names are provided, each of which resolves to multiple IP addresses then all the addresses of server1 would be attempted before attempting to connect to server2.