load balancing dual WAN w/ QoS, failover (ISPs are dynamic DHCP)

RouterOS Beginner Basics
1

I have a client. They run a motel. Internet speeds aren’t great, they would like to hook up a second ISP. They would like load balancing and failover implemented. I have some QoS running, I can do failover (failover setup running at a different client). I’ve researched this question for many hours. I’ve found lots wonderful tutorials on load balancing multiple WAN with failover. Several problems though. None of the tutorials, forum threads, or wikis mention load balancing and QoS together. They also say nothing about load balancing and dynamic DHCP from the ISP. They only show static IP setups (not much of a problem).

I guess my question is the following: is it possible to load balance multiple WAN, use QoS, have a failover setup, while using dynamic IPs on one device?

If anyone is familiar with such a setup, I would greatly appreciate a point in the right direction. My boss is all over me to get this finished and I’ve found nothing.

Thank you.

edit: guess I should add that the client is using a CCR 1009 for their router.

2

Dynamic wan IPs should work fine for Nth load balancing. In the article below, set the route’s gateways to the wan interface instead of specifying the gateway by IP address.
http://wiki.mikrotik.com/wiki/NTH_load_balancing_with_masquerade

An issue with Nth load balancing is some websites don’t like how your IP changes from one request to the next and may invalidate your session.

Also with Nth VoIP likely won’t work since a call must use only one IP for audio where as Nth would send some audio down each wan interface. You could create rules to force all VoIP down one wan though.

Starting with RouterOS 3.24, you can use PCC
http://wiki.mikrotik.com/wiki/Manual:PCC

PCC - per-connection-classifier is supposed to help with the above issues with Nth load balancing.

In this example, there are two firewall mangle rules that say when dst-address=10.112.0.2 then action=accept. I think you can remove these two mangle rules and it’ll continue working, maybe someone can comment on this.

If you’re ISP supports Bonding, that’s the easiest route. They provide two internet connections but it’ll appear as one connection. An ISP would likely provide the router that does the bonding, so you just have one standard WAN connection to worry about. Not an option if you’re using two ISPs.

As for QoS, it should just work fine with load balancing.