I would like to know if it is possible to load balance the two ADSL connections and only when the 2 ADSL lines are down, that all traffic goes through the Fibre until at lease one of ADSL lines come back?
Can i do this on one router, or should I use two routers for the separate tasks?
Hi. You can do this in the same mikrotik harware. For the load balancing you can do by pcc and the fiber connection with distance like 3 and you have for backup this.
Without a dynamic routing protocol between your ISP and you (like BGP), you are probably stuck with masquerading your LAN IPs.
Let’s assume you have three point to point public IPs to your ISPs and your LAN is 192.168.0.0/24.
you would then have three masquerade rules:
chain=srcnat action=masquerade src-address=192.168.0.0/24 out-interface=WAN1
chain=srcnat action=masquerade src-address=192.168.0.0/24 out-interface=WAN2
chain=srcnat action=masquerade src-address=192.168.0.0/24 out-interface=WAN3
Then you would have your default routes contingent on a connection being up. There are many ways to do this, but the easiest is check-gateway ping. The lowest distance will be preferred. Even if you do PCC, you will want floating backup routes.
This alone would allow you to use any of the three connections with the same private host IP. Don’t forget to use DNS that will work on any of the three WAN connections!
This is an insanely good explanation of PCC hashing: