Our production environment has two redundant data centers. Within each data center we have multiple web servers talking to a single SQL cluster which has multiple broker DB servers.
The clustering works great if a single broker DB goes down, however, we have times that the cluster will need patching or fails and we want to auto fail over to a redundant cluster for the broker content without having to switch all web traffic over to the redundant data center.
Does anyone have something like this working in production?
I completely understand how to get the published data to the redundant cluster, but how would the web server traffic automatically pull from the passive DB cluster when the active DB cluster starts having problems?
Consider we are using 2013sp1 so the CIL and microservice architecture is not an option at this time.