Internet Redundancy Question

Yeah this seems to be a fundamental routing situation. Any enterprise class router can have multiple WAN connections. Typically, what we do is have 2 dns entries, one for each connection, then set up each entries in the redundancy settings.