I have a scenario where SQL Server 2012 - Always-on feature configured.The primary and secondary are synchronous for failover purposes. I understand that we will have node 1 (PRIMARY) and node 2 . Also I know during fail over node 2 becomes PRIMARY.
My question is, (synchronous commit setup)
- When application send INSERT or any SQL transactions, which node first the execution happens? Is it on PRIMARY ?
- When node 1 fails then node 2 becomes PRIMARY, but who will make node 1 up? do I need to setup alerts? if node 1 dies then how HA and DR works?
- What is difference between active-passive or active-active?
Where I can find detailed information on always-on architecture? I have read many article but none explains the internals.