By using this website, you agree to our Terms of Use (click here)
Does anyone have any experience or documentation on setting up load balancing for an On-Prem deployment? We have two IIS servers with Acumatica installed and both pointing to the same DB. We know we can just give users a different URL to manually force load balancing (by job functions), but we really wanted to configure automatic load balancing so that we only have to give the users one URL and then have the system determine which server to direct them to.
Here is something from one of our engineers. This is a general load balancing response based on years of load balancing our VPS environment and working with customers outside of Acumatica. We are a hosting and managed services company, not a VAR so we haven't done this specifically for Acumatica, but hopefully this helps.
From Engineer:
There are many factors to consider when it comes to Load Balancing, and even more variables. While the public forum might not be the most appropriate medium to discuss them all (security), I will try to simplify my answer but let me know if you need to discuss more and we can discuss over DM.
The quick and simple answer would be that it is very possible, and either configuration mentioned would work just fine. You can match any part of an inbound request (including paths) to route them to the appropriate backend.
You can also deploy this solution at no cost if you are technically adept, while using the Open source pfSense Haproxy package (GUI Based). pfSense NGF has many other packages that can be combined with Haproxy, to make it a full featured front-end solution. Like IPS/IDS, GEO-Filtering, Lets Encrypt, VPN only access, reputation filtering, reverse proxy, and you can even setup a pair for full redundancy.
