I'm trying to understand the multiple App Volume Server scenario behind a load balancer. For example, if I were to deploy three App Volume Servers that have an external SQL DB, would all three servers point to the same database, and have a primary/standby/standby configuration? Or would all three of them write to the same database and therefore all of them will play the "primary" role using the VIP from the load balancer?
If you use multiple Appvolumes servers behind a load balancer you must create a central database.
We are using 3 Appvolumes servers behind an F5 load balancer and the idea of multiple Appvolumes servers has 2 reasons (at least for us).
1. Redundancy. If one of the servers fails we still have 2 other servers that can serve the load of the agents.
2. Performance. Every server has an amount of threads it can use. If you have for example 3 servers and every server has 2 threads set you have a total of 6 threads meaning you could do 6 things at 1 time. If you have boot storms of people logging in at the same time I would highly suggest using more servers. If you have a small environment (lower that 250 VDI machines) I'd say 1 would be enough. But I would still use 2 due to redundancy but that's up to you off course..