Choose Best Clustering Plan For Always On - in sql server 2014
-
Hi
again about Always on
we have 3 servers. I face with 2 plan to cluster servers in order to run Always on .
But I cant set Cons And Pros About these plans.
Please Help me.
Thank you
we have sql server 2014 And windows server 2008 R2
-
Neither of those are feasible for Always On Failover Clustering. With failover clustering, the instance fails over. The first would work if you put two instances on the HA server, the second wouldn't, a server can't be part of two failover clusters.
Or are you asking about Always On Availability Groups?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
It is about Availability Group.
I Planed to have One availability Group for each server.
Availability group 1 : Db1 ... 4 (Between server1 And HA)
Availability group 2 : Db5 (Between server2 And HA)
-
You should have been clear in your title and post that you were asking about Availability Groups, not clustering (which the title stated)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
But AGs are Based on Clustering.
And my main question is about Clustering structure . because in prevoius Project we failed because of clustering . And this time we have to sure aboue right choose of clustering structure.
And I should say :
In first step , most probably (as is showed in figures) we dont have DR.
-
Firstly, read through my stairway at this link
http://www.sqlservercentral.com/stairway/112556/[/url]
MotivateMan1394 (11/14/2015)
Hiagain about Always on
we have 3 servers. I face with 2 plan to cluster servers in order to run Always on .
But I cant set Cons And Pros About these plans.
Please Help me.
Thank you
we have sql server 2014 And windows server 2008 R2
Plan A is sound, all nodes are a member of the same WSFC.
Do you plan to have any FCIs deployed or just standalone instances?
Plan B will work but is not supported for a live system. Cluster resources cannot failover from cluster into another, all nodes must be part of the same WSFC. Plan B is only supported for migration purposes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Thank you .
But we dont want to have FCI. We want to use Availability Group .
and Forget our plans.
-----------------------------------------------------------------------
In simple terms :
We have 2 Practical server. (server1 And server2)
- there are 4 databases on server1 And 1 databases on server2.
we need HADR for our servers. (Based on Alwayson-Availability Group)
----------------------------------------------------------------------
It is my plan :
1- We get third server in role of HA server.
2- we Build an Availability Group with 2 node : server1 And ServerHA (This AG Has 4 databases) - Then Server-1 will be main replica And ServerHA will Be second Replica.
3- we Build Another Availability Group with 2 node : server2 And ServerHA (This AG Has 1 databases) - Then Server-2 will be main replica And ServerHA will Be second .
>>>>
This time the question is :
my Cluster plan How should be to support this HA Plan ?
Thank you
-
sorry, it's not clear what you're asking. have you read the stairway series thoroughly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply