We have two wan data links (with two different telecom providers) going from our central office to a remote location. Each data link currently transfers data from different equipment that are in two distinct subnets. We would like the data links to be redundant and have load balancing. I am thinking of using a Cisco RV042 Dual-WAN router at both the local and the remote site to achieve this. So far, I have been searching online for a similar usage scenario with the Cisco RV042, but all I can find are case scenarios when the two WAN links are for ISPs. Is it ok to use two Cisco RV042s and/or is there a better way?
Is it ok to use two Cisco RV042s
I can't imagine you'll have any issues with using the RV042. Using the built-in load-balancing methods automatically set up a WRR scheduling profile for you. Check out the RV042 User Manual for more information on how to set that up and a snippet of what's happening under the hood.
is there a better way?
There is always a better way, but given the equipment you are using, I think this is your best option without investing too much money and effort into redesigning your network for such a small gain.
In my opinion, this is a good option.
If you haven't actually committed to purchasing the Cisco devices, one solution I can think of is to put in a pair of Fortigate devices, then configure them to build a pair of tunnels and perform load balancing between the two tunnels.
With suitable models (the ones with internal storage), you'd even get WAN Optimization feature.