Mid-tier failover clustering and load balancing
Posted: Wed Jun 21, 2017 9:33 am
Currently we have two mid-tiers on VMs in the same colo. We are expanding to more colos and want to set up better failover and load balancing support. If we use Windows Server Failover Clustering, can we install two mid-tiers in one cluster and two mid-tiers in another cluster to support failover in case one of the VMs goes down? The SP Select Client software has to connect to one mid-tier IP. Maybe we can set up a load balancer or reverse proxy to allow the client to connect to the primary cluster or round robin the users to different mid-tiers?
We also want to set up a second SQL Server and use AlwaysOn Availability Groups. Does SP Select use "ApplicationIntent=ReadOnly" for read only based connections? This way our synchronous secondary can support read only connections.
We also want to set up a second SQL Server and use AlwaysOn Availability Groups. Does SP Select use "ApplicationIntent=ReadOnly" for read only based connections? This way our synchronous secondary can support read only connections.