SQLTeam.com | Weblogs | Forums

Choose the best Plan for Availability Group 2014


#1

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?


#2

If it is difficult to read, I painted the plans. Please Help me about this: Which plan is better, And what are the plan's problems?