I am looking to setup an active/passive database cluster between data centers using mirroring and/or log-shipping across these two nodes. My challenge is understanding High Availability (HA) and getting the HA configuration correct.
Hardware Failure. I have no issues with this and understand that all traffic will be diverted to another data center or another node with in the same data center.
Data Center 1 Failure. Again, I have no issues here. All the traffic will be diverted to another data center.
Database Updates. I am facing an issue here.
During a patch upgrade on the Data Center 1 database, I want to divert all traffic to the Data Center 2 database. After patching is complete, I want to revert it back to Data Center 1. This may require breaking the mirroring/log-shipping configuration. How would I then copy all the changes made on the Data Center 2 database back to Data Center 1? Is there any feature I can use to get this incremental data while minimizing downtime?