This action can be simply done by using DNS Round-Robin, that's when you configure in a DNS more than one A record for the same name. So at each query to resolve this name, the DNS server will respond with a different IP address, cycling into the set of A records provided for this unique name.
But in this scenario, there are a lot of potential problems :
But there are alternative solutions to the costly SAN. The OpenSource community offers you various kind of mechanisms to build highly-available filesystem.
When it comes to high-availability of databases, numerous strategies can be applied.
Do we need a complete active-active solution doing load-balancing ? Or do we have enough with a standby database ?
The technical implications behind these choices are totally different, also the reaction to outages will be different of course.