I have 16 web servers and 8 standalone database servers with same content (to spread the load).
Each web server contains the same site deployed for 16 tenants.
I have 2 tasks to do but they seem to be similar in what is needed.
I have a variable called ‘DatabaseServer’ which should point to the correct host.
How can I set this variable value to be different for the combination of tenant/environment/target?
We have a situation that a tenant is deployed to multiple web servers but these different web servers (for this tenant) need to connect to a different database server to spread the load.
We also have a load-balancing scenario where I need a variable to mark which tenant on a specific web server in PROD is attached or detached from the load-balancer. So I also need to set this value per tenant/environment/target.
How can I achieve my goal?
Thanks for your help.