2 WAN to LAN, What router do I need? [closed]
Solution 1:
What you need is WAN aggregation. A simple explanation would be: you would have router 1(dsl) feed into it and router 2 (cable) feed into it. The device will handle communications between the different WANS and send traffic to the device with the least amount of utilization it will also offer fail over if one of them goes down.
My company is currently looking into Fat pipe, and their diagram is posted above, here is a link to the product I referenced. There are qutie a few other options out there but we settled on Fatpipe because their pricing was good. Realize this technology is pretty expensive and quite difficult to setup but it is exactly what you are looking for.
Solution 2:
Traditionally this would be done with BGP to select the WAN interface that was closest to the destination.
Very few, if any, ISPs provide BGP facilities to consumers through ADSL or cable.
You can get some routers that do fancy things with routing tables to split the traffic 50/50 between the interfaces on a per-IP basis, but I don't know of any specifics at the moment.
Alot of people who want this kind of functionality create their own Linux based routers. There's lots of resources on the web to learn how to do load balancing with iptables or ipchains in Linux.