July 21, 2010 at 8:48 am
when setting up a cluster is Sql server installed on each nodes c dirve or is it install on one of the shared san dirves ?
July 21, 2010 at 8:53 am
In my experience SQL Server is installed on each node's C drive and the user database data/log files are on the SAN.
July 24, 2010 at 1:46 am
From memory the installer wont let you select a shared drive, if you do it warns that the drive is a shared drive and forces you to make another selection
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 24, 2010 at 12:57 pm
SQL Server will be installed on the shared drive, however, some of the shared files will be on C: drive.
Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
August 3, 2010 at 1:14 pm
August 4, 2010 at 9:08 am
Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored drives to better use (offloading TEMPDB maybe)!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 9:46 am
Perry Whittle (8/4/2010)
Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored drives to better use (offloading TEMPDB maybe)!
If you're talking about sharing the Quorum drives with anything else, then NO!!!!!
Sounds like you need to read the SQL Server 2008 Upgrade Technical Reference Guide
(If you're thinking about splitting up the mirrored drives, then this doesn't apply.)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 4, 2010 at 10:17 am
WayneS (8/4/2010)
Perry Whittle (8/4/2010)
Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored drives to better use (offloading TEMPDB maybe)!If you're talking about sharing the Quorum drives with anything else, then NO!!!!!
Sounds like you need to read the SQL Server 2008 Upgrade Technical Reference Guide
(If you're thinking about splitting up the mirrored drives, then this doesn't apply.)
actually, YES!!!
a node majority with a witness file share on a 3rd server does the trick (commonly used in an Exchange CCR cluster).
The following link details how to set up a 3rd file share to act as a witness
http://technet.microsoft.com/en-us/library/bb676490(EXCHG.80).aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 11:21 am
Hi Perry,
If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at least 3 servers.
Robert
August 4, 2010 at 11:28 am
n
August 4, 2010 at 11:32 am
rdecker (8/4/2010)
Hi Perry,If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at least 3 servers.
Robert
Bingo, someones got it. Yes an MNS quorum based (no disk) cluster requires 3 nodes. What you do is configure the cluster with the 2 SQL Server nodes as shown. Windows 2003 SP1 on and 2008 clustering offer a new feature whereby a 3rd machine (witness) has a copy of the file share and completes the odd number required!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 11:36 am
ron morgan (7/21/2010)
when setting up a cluster is Sql server installed on each nodes c dirve or is it install on one of the shared san dirves ?
See Brad McGeHee walk through of configuration SQL Server 2005 cluster. I know you are referencing SQL 2008 but the concept is the same, wizard probably changed around.
When you run the setup on SQL Server it will detect all the shared drives configured for the group in Cluster Admin. It WILL NOT allow you to install to local drives, I believe it will only show the shared drives to install to. The only things installed to the local disk are the Management Tools and client tools. Everything else will be installed to the shared drives.
With regards to the Quorum drive, SQL Server uses this drive for a loging or syncing process for events that occur on the active node. In the event that a failover occurs this "log" file is used to sync up the failover node to ensure the instance comes up in the same state. It is also used by the clustering services in the operating system as well.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
August 4, 2010 at 11:48 am
more importantly, SQL Server does not care whether the quorum is an MNS or a disk!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2010 at 1:16 pm
Perry Whittle (8/4/2010)
rdecker (8/4/2010)
Hi Perry,If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at least 3 servers.
Robert
Bingo, someones got it. Yes an MNS quorum based (no disk) cluster requires 3 nodes. What you do is configure the cluster with the 2 SQL Server nodes as shown. Windows 2003 SP1 on and 2008 clustering offer a new feature whereby a 3rd machine (witness) has a copy of the file share and completes the odd number required!
Thanks Perry. I'm a visual person and will need to draw it out so I can connect the dot. I've came across the MNS concept many times but never paid any attention to it because of the need. When I'm done would you mind verify my understanding of the concept? Please post your email or join xenmaster.com so we can keep in contact. Thanks!
Robert
August 4, 2010 at 1:49 pm
Robert
remember as you are implementing a cluster you will inherently have more than 2 machines on the network (a cluster is dependant upon DNS and AD).
You cluster the 2 SQL server nodes using MNS but this requires 3 nodes? So, you simply configure a 3rd node (not a cluster node but a file share based witness) which could be a member server of the domain or a domain controller itself (not ideal but it works)!
The best thing to do is to play with this concept in a virtual environment, to re create the SAN storage I use FREENAS. I have a PDF doc that covers how to set up a virtual SQL Server 2008 cluster
at the following link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply