Hi,
How/Is DW handling for Load Balancing scenarios?
Going into DW10 and customers asking for our options around Load Balancing / High Availability. I know that in DW9, there is a dll we can add to support it (essentially triggers cache from the master node to all other nodes), but I don't remember if there's something similar for DW10.
Based on that we will need to explore our options to configure LB, whether we always use Active-Passive, pointing them to a particular node when they want to manage data in the backend OR if we could adopt a Round Robin setup (which can be more challenging for backend scenarios).
To add to this, I also need to consider things like Shared database (only good option for DW9) or if we could have some Database replication setups for more demanding customers.
Best Regards,
Nuno Aguiar