I will explain the problem first ...
I have an in-house webserver/web-app that is publicly accessible. Our Internet connection (Bonded ADSL MAX Premium) is therefore a single-point-of-failure (which has been highlighted by some recent connectivity issues).
As a low-cost backup I was thinking of adding a second Internet connection (Standard ADSL) with a static IP of it's own.
Now I was wondering if anybody has tried or would comment on the following idea ...
If I got an externally hosted server and run a proxy server like HAProxy, I could have this proxy requests to our main IP (down our main connection). Then have it failover to the second connection if the main one went down.
What you're proposing is certainly doable, the place I work at (web hosting company) has done that for a client, works pretty well. Best to use a caching reverse proxy like Varnish or Squid (in reverse proxy mode) so you can take advantage of the better bandwidth and latency of the datacentre-connected machine.
Why have an external server proxy your http requests? Why not just use dns to switch the host name to the ip address of the other connection?
If you need a single, static ip address, is there any way you could get your isp to route the ip address to the other connection in the event that the first goes down?
That sounds reasonable, though for the cost of a second connection, I'd also compare the cost of remote-hosting the app somewhere else.
You don't mention what kind of perimeter you have. My experience with firewalls is that you can have your main line entering your firewall, set up some kind of heartbeat on your ISPs perimeter router (which most will allow if you ask), and when that heartbeat fails, you have a backup DSL line or something inexpensive that it will failover to.
It used to be that we'd use an ISDN backup but these days you might also look at something like the Draytek 2800VG (Vigor 2800 ADSL2+ Router Firewall, VPN Device with Printer Port & Optional 802.11-SuperG Wireless LAN). The usb port in the back can be used with a USB 3G dongle to automatically connect as a failover.
That way if the clumsy crew with the backhoe digs up the phone lines you'll still have net.