Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

setting up Clustering - SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 9:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 PM
Points: 5,951, Visits: 12,822
Jpotucek (9/10/2012)
can anyone same MS Professional Services : )

don't understand, what does this mean?


Jpotucek (9/10/2012)
So speaking specifically how the drives would need to get carved out, I already have a 2 node active passive cluster on sql server 2005 and the drive configuration looks like this:

C: Local to each node (for Biniaries) (50GB)
D: Local to each node (for misc files) (85GB)
Q: Quorum (1GB)
M: MSTSC (1GB)
F: Shared on the San (datafiles) (300GB)
G: Shared On the San (Logfiles) (300GB)
H: Shared on the San (TempDB) (50GB)
____________________________________________________________
My 2008R2 Cluster with 3 Instances, will would look like this:
Default Instance
C: Local to each node (for Biniaries) (50GB)
D: Local to each node (for misc files) (85GB)
Q: Quorum (1GB)
M: MSTSC (1GB)
F: Shared on the San (datafiles) (100GB)
G: Shared On the San (Logfiles) (100GB)
H: Shared on the San (TempDB) (50GB)

Named Instance 1
I: Shared on the San (datafiles) (100GB)
J: Shared On the San (Logfiles) (100GB)
K: Shared on the San (TempDB) (50GB)

Named Instance 2
L: Shared on the San (datafiles) (100GB)
M: Shared On the San (Logfiles) (100GB)
N: Shared on the San (TempDB) (50GB)

Named Instance 3
R: Shared on the San (datafiles) (100GB)
S: Shared On the San (Logfiles) (100GB)
T: Shared on the San (TempDB) (50GB)

Or does each install create a new Quorum Drive as well because you are actually adding a Node?

You only have one quorum resource for the windows cluster whether it be a disk or file share, etc.

With the above configuration for your new cluster you may want to look at using mount points to cut down on the drive assignments and yep, you guessed it, heres a link to my guide on this site



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1356827
Posted Monday, September 10, 2012 9:29 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, March 24, 2014 5:37 AM
Points: 743, Visits: 1,535
"You only have one quorum resource for the windows cluster whether it be a disk or file share, etc."

So my Disk config looks OK.. One quorum disk regarless of the # of Instances?
and... Take a look a mount points? : )

You da' bomb! Thanks for all your guidance





Post #1356830
Posted Monday, September 10, 2012 1:08 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 PM
Points: 5,951, Visits: 12,822
You dont have a quorum resource for each instance installed, the cluster as a whole at the windows level has one quorum resource.

The resouce can be node majority for odd number of cluster nodes or disk or file share for even number of nodes.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1356971
Posted Monday, September 10, 2012 1:13 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, March 24, 2014 5:37 AM
Points: 743, Visits: 1,535
Thank you. that makes much more sense now.

and also .. when I said this:
"can anyone same MS Professional Services : )"

I meant to say:
"can anyone say MS Professional Services?"
meaning.. why didn't I hire MS professional services for this!!!!!!

Actually, I can't wait to dig into it! Thanks for all your guidance Perry!




Post #1356974
Posted Monday, September 10, 2012 1:32 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 PM
Points: 5,951, Visits: 12,822
Jpotucek (9/10/2012)
why didn't I hire MS professional services for this!!!!!!


No need to pay over the odds, You just merely need to hire a good contractor to design\install the system and provide onsite training.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1356985
Posted Monday, September 10, 2012 2:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:24 PM
Points: 302, Visits: 1,067
Perry Whittle (9/10/2012)

See my 3 part guide starting at this link to deploy and configure the Windows cluster and the clustered SQL server instance. It covers virtual but applies to physical too

See my guide at this link for details how to slipstream service packs and\or cumulative updates


Thanks for sharing!
Post #1357002
Posted Monday, September 10, 2012 2:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 PM
Points: 5,951, Visits: 12,822
you're welcome

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1357022
Posted Wednesday, September 12, 2012 7:57 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, March 24, 2014 5:37 AM
Points: 743, Visits: 1,535
one last point for clarification??

So (if I have this straight) There is one Quorum and one MSDTS and then multiple Instances would each have their own set of disks for Data, Logs, Tempdb, etc.

here is how I see the steps to install a Default Instance.

1) Setup 'New SQL Server Failover Cluster Installation" on Node 1
2) Go to the second Node (without failing over) and run set 'Add Node to a SQL Server failover
Cluster'

I should now have a fully functioning 2 Node Active Passive Cluster with a Default Instance.

---
For each SQL Server Instance that I want to add, would I repeat steps one AND two?



Post #1357988
Posted Wednesday, September 12, 2012 8:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 PM
Points: 5,951, Visits: 12,822
Jpotucek (9/12/2012)
one last point for clarification??

tut tut tut, any more of this and you'll be incurring fees



Jpotucek (9/12/2012)
So (if I have this straight) There is one Quorum and one MSDTS and then multiple Instances would each have their own set of disks for Data, Logs, Tempdb, etc.

With Windows 2008 you can have more than 1 clustered MSDTC, but essentially yes, you are right



Jpotucek (9/12/2012)
here is how I see the steps to install a Default Instance.

1) Setup 'New SQL Server Failover Cluster Installation" on Node 1
2) Go to the second Node (without failing over) and run set 'Add Node to a SQL Server failover
Cluster'

I should now have a fully functioning 2 Node Active Passive Cluster with a Default Instance.

What do you need me for?




Jpotucek (9/12/2012)
For each SQL Server Instance that I want to add, would I repeat steps one AND two?

yes, that's correct.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1358014
Posted Wednesday, September 12, 2012 8:51 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, March 24, 2014 5:37 AM
Points: 743, Visits: 1,535
it's just so different from 2005 that the more I read .... I keep second guessing myself

Thank you again for your patient guidance!!!



Post #1358026
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse