marrowyung
asked on
Windows 2008 R2 enterprise edition cluster.
Dear all,
I setup the Windows 2003 cluster for the use of SQL server 2005 cluster before but I forget how to do it now.
now we tried to use Windows 2008 R2 enterprise edition + SQL server 2008 R2 standard edition as a 2 x nodes SQL cluster.
What is the pre-request before configuring the Windows 2008 R2 cluster?
1) We just need one volumn before installing cluster component as that one is the Quorm voume? after configuring the Windows 2008 R2 cluster, that volume only saw by the active volume that own all disk resource?
2) if we have 2 x SQL instance on the same 2x nodes cluster group, then we need 2 x volume as the Quorum before configurating the windows clusters?
3) MSDTC is a serivce and suggested to install on other dedicated volumn other than the Quorum volume ?
Any step by step guide "?
DBA100.
I setup the Windows 2003 cluster for the use of SQL server 2005 cluster before but I forget how to do it now.
now we tried to use Windows 2008 R2 enterprise edition + SQL server 2008 R2 standard edition as a 2 x nodes SQL cluster.
What is the pre-request before configuring the Windows 2008 R2 cluster?
1) We just need one volumn before installing cluster component as that one is the Quorm voume? after configuring the Windows 2008 R2 cluster, that volume only saw by the active volume that own all disk resource?
2) if we have 2 x SQL instance on the same 2x nodes cluster group, then we need 2 x volume as the Quorum before configurating the windows clusters?
3) MSDTC is a serivce and suggested to install on other dedicated volumn other than the Quorum volume ?
Any step by step guide "?
DBA100.
Mariano
this maybe helps you: http://dusk1911.wordpress.com/2011/06/12/installing-sql-2008-r2-cluster-step-by-step/
ASKER
it is a very good resource but:
1) "Now in windows server 2008 R2, the cluster Quorum and storage will be configured automatically, we need to check on that "
We can't manually select which volume the Quorum use ? This is the biggest I can forseen.
the .net seems to be the configured as the application server, which menas the software will be install automatically on both node? and that's why it is followed by SQL installation then ?
so no need to prepare some cluster volume before going ahead?
1) "Now in windows server 2008 R2, the cluster Quorum and storage will be configured automatically, we need to check on that "
We can't manually select which volume the Quorum use ? This is the biggest I can forseen.
the .net seems to be the configured as the application server, which menas the software will be install automatically on both node? and that's why it is followed by SQL installation then ?
so no need to prepare some cluster volume before going ahead?
El recurso de quorum se puede elegir en el asistente de configuración en caso de tener varios discos.
http://technet.microsoft.com/es-es/library/cc770620(v=ws.10).aspx
http://technet.microsoft.com/es-es/library/cc770620(v=ws.10).aspx
ASKER
"This is the biggest I can forseen."
The biggest problem I can forseen .ahah
The biggest problem I can forseen .ahah
The quorum resource can be chosen in the wizard if you have multiple disks..
Sorry. I betrayed the subconscious :p
I usually configure the quorum disk with 1GB. after creating the cluster have to click with the right mouse button on the name of the cluster. display the menu "More Actions" and click "Configure Cluster Quorum Settings". In the options, usually choose "Node and Disk Majority". The next step is to select the disk you want to act as Quorum.
Sorry. I betrayed the subconscious :p
I usually configure the quorum disk with 1GB. after creating the cluster have to click with the right mouse button on the name of the cluster. display the menu "More Actions" and click "Configure Cluster Quorum Settings". In the options, usually choose "Node and Disk Majority". The next step is to select the disk you want to act as Quorum.
This is the link in english:
http://technet.microsoft.com/en-en/library/cc770620(v=ws.10).aspx
http://technet.microsoft.com/en-en/library/cc770620(v=ws.10).aspx
ASKER
"after creating the cluster have to click with the right mouse button on the name of the cluster. display the menu "More Actions" and click "Configure Cluster Quorum Settings""
so this is before "Verifying Cluster Storage and Quorum" section on http://dusk1911.wordpress.com/2011/06/12/installing-sql-2008-r2-cluster-step-by-step/ ?
or we just CHANGE that after the wizard configure that for us ?
are you using windows 2008 R2 cluster BTW ?
so this is before "Verifying Cluster Storage and Quorum" section on http://dusk1911.wordpress.com/2011/06/12/installing-sql-2008-r2-cluster-step-by-step/ ?
or we just CHANGE that after the wizard configure that for us ?
are you using windows 2008 R2 cluster BTW ?
After section 7 you already have installed the Cluster. I guess because of the number of nodes, the wizard can automatically configure quorum. In my case I always had to manually configure it as you suggested earlier.
All my clusters are Windows 2008 R2 or Windows Server 2012
All my clusters are Windows 2008 R2 or Windows Server 2012
ASKER
Crower,
"I usually configure the quorum disk with 1GB"
so right now after you look back, is 1GB of Quorum disk is enought for Windows 2008 R2 ?
"After section 7 you already have installed the Cluster."
This one http://dusk1911.wordpress.com/2011/06/12/installing-sql-2008-r2-cluster-step-by-step/ do not have any section 7, or which one you are talking about?
so :
1) If we have 2 x SQL instance on 2 x nodes in a cluster group, then we need to setup 2 x 2GB volume in the SAN before configurating the quorm ?
2) After setup the quotum, each SQL instance running on each nodes will only see the hard disk belongs to them ?
"I usually configure the quorum disk with 1GB"
so right now after you look back, is 1GB of Quorum disk is enought for Windows 2008 R2 ?
"After section 7 you already have installed the Cluster."
This one http://dusk1911.wordpress.com/2011/06/12/installing-sql-2008-r2-cluster-step-by-step/ do not have any section 7, or which one you are talking about?
so :
1) If we have 2 x SQL instance on 2 x nodes in a cluster group, then we need to setup 2 x 2GB volume in the SAN before configurating the quorm ?
2) After setup the quotum, each SQL instance running on each nodes will only see the hard disk belongs to them ?
ASKER
so we only need to make sure that 2 x quorm volume is there to create the 2 x active and passsive cluster ?
No. The quorum resource is unique. in my 2-node configurations with multiple instances of SQL I have only one configured quorum disk.
ASKER
Crower,
So at the beginning, both nodes should see all harddisks, right?
1) Then we leave only one drive as the quotum for both nodes. in this cluster.
2) We setup using the link you provides,
3) during the wizard, change the quotum drive.
4) finsih the cluster installation.
5) after 4, we should only see the drivers belongs to each active instance.
6) install SQL server 2008 R2 standard cluster.
am I right on this ?
So at the beginning, both nodes should see all harddisks, right?
1) Then we leave only one drive as the quotum for both nodes. in this cluster.
2) We setup using the link you provides,
3) during the wizard, change the quotum drive.
4) finsih the cluster installation.
5) after 4, we should only see the drivers belongs to each active instance.
6) install SQL server 2008 R2 standard cluster.
am I right on this ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Crower,
you are the only one here which give me usaful advice like that.
I don't know who to give mark if I don't give you.
Thanks for that.
I just knew yesterday that a vendor will do the installation for us, and therefore, I might have chance to touch it.
But I will install a standalone SQL server 2008 R2 standard server, any step by steps guide on this to make my job quicker?
DBA100.
you are the only one here which give me usaful advice like that.
I don't know who to give mark if I don't give you.
Thanks for that.
I just knew yesterday that a vendor will do the installation for us, and therefore, I might have chance to touch it.
But I will install a standalone SQL server 2008 R2 standard server, any step by steps guide on this to make my job quicker?
DBA100.
ASKER
is the disk with MSDTC is the one that do the Quorum disk ? I forget about that concept, configure the Windows 2003 cluster 7 years ago ! haah.