Availability Group Plan
We have 2 operation servers and 1 HA more over 1 DR server.
Then 4 servers.
In Operation server 1 :
- DB1
- DB2
- DB3
In Operation server 2 :
- DB4
It's nessesery for us that on
- any Failour on server1 OR server2 OR
- any suspection or coruption on any database on server 1 or server 2
we have support from HA.
And I need to DR for 30 min delay.
Then there are 2 plans .
Plan A :
A cluster with server 1 , 2, 3, 4
Av1 : with Server1 = Primary (All DBs), server HA = Secondary , Server DR = Secondary2 >>> listener1
Av2 : with Server2 = Primary (All DBs), server HA = Secondary , Server DR = Secondary2 >>> Listener2
Plan B :
A cluster with server 1 , 2, 3, 4
Av11 : with Server1 = Primary (DB1), server HA = Secondary , Server DR = Secondary2 >>> listener1
Av12 : with Server1 = Primary (DB2), server HA = Secondary , Server DR = Secondary2 >>> listener2
Av13 : with Server1 = Primary (DB3), server HA = Secondary , Server DR = Secondary2 >>> listener3
Av21 : with Server2 = Primary (DB4), server HA = Secondary , Server DR = Secondary2 >>> Listener4
Which of them is better?
