April 17, 2012 at 2:30 pm
Hi,
I have two identical machines having windows server 2008 R2 Enterprise edition and a SAN ready to create and share drives on it.
These machines have 4 processors with 10 cores per processor so there is a total of 40 processors (So the only alternative I have to use all those processors is to install SQL Server 2008 R2 Datacenter edition)
What will be the first step on this setup:
Create Windows Cluster or Map the Drives first?
Can you recommend some documentation specifying the steps of how to create a windows cluster and a SQL Server 2008 R2 Active/Passive cluster.
On the near future I will have to create an Active/Active so I will appreciate your recommendations, I have some ideas but I always ask to more knowledgeable peers
Thanks
April 18, 2012 at 5:52 am
APA0876 (4/17/2012)
What will be the first step on this setup:Create Windows Cluster or Map the Drives first?
You can do it either way. If you pre create all your LUNs and present them to the Windows nodes then when you create the cluster you may run all tests in one go.
If you create the Windows cluster first you will need to re run the cluster verification once all the shared disks are presented to the nodes.
APA0876 (4/17/2012)
Can you recommend some documentation specifying the steps of how to create a windows cluster and a SQL Server 2008 R2 Active/Passive cluster.
read my guides at the following links for information on setting up the cluster and also setting up mount points which you may or may not want to use. The deploy guide uses a virtual system but the process is exactly the same for the cluster deployment.
Mount points for sql server clusters[/url]
SQL Server cluster deployment[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 8:59 am
Thanks very helpful.
April 18, 2012 at 9:02 am
But if I create a Windows cluster first whithout having a shared volume for the Quorum disk where this will be created?
Thanks
April 18, 2012 at 9:40 am
if you don't have a shared volume it won't use one but will warn that the current configuration is not suitable for the number of nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 2:02 pm
Perry Whittle (4/18/2012)
if you don't have a shared volume it won't use one but will warn that the current configuration is not suitable for the number of nodes
So when I add the shared volumes including the Quorum drive I gues that there is a way to add the quorum drive thru the Failover cluster management (Configure Cluster Quorum settings)
Thanks again
April 19, 2012 at 2:18 pm
APA0876 (4/19/2012)
Configure Cluster Quorum settings
That's exactly it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 3:34 pm
I have configured Active /Passive cluster installing a sql server failover cluster on one of the nodes and on the other node I execute the installation with the Add node option,
How to proceed with an Active/Active installation. Is there a good guide that I can use?
I have windows server 2008 r2 Enterprise edition plus SQL Server 2008 R2 Datacenter edition.
Thanks, I appreciate your valuable help.
APA:-)
April 19, 2012 at 5:05 pm
APA0876 (4/19/2012)
How to proceed with an Active/Active installation. Is there a good guide that I can use?
Yes, the guide you already have 😉
Install a second instance and run the add node, then run one instance on one node and one on the other, that is active\active or multi instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2012 at 8:58 am
So I will need Two different Ips for the two instances, plus two more ips for the msdtc.
or just one MSDTC will be enough for the two instances?
Thanks
APA:-)
April 20, 2012 at 11:59 am
APA0876 (4/20/2012)
So I will need Two different Ips for the two instances
Exactly, you will meed separate IP, network name and disk storage for each instance.
APA0876 (4/20/2012)
plus two more ips for the msdtc. or just one MSDTC will be enough for the two instances?Thanks
APA:-)
Well now, that's a bone of contention. How busy do you expect the instances to be in terms or remote transactions?
You may be ok with just one or if the instances are busy you may need one for each instance, it's your call
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2012 at 1:10 pm
Perry Whittle (4/18/2012)
APA0876 (4/17/2012)
What will be the first step on this setup:Create Windows Cluster or Map the Drives first?
You can do it either way. If you pre create all your LUNs and present them to the Windows nodes then when you create the cluster you may run all tests in one go.
If you create the Windows cluster first you will need to re run the cluster verification once all the shared disks are presented to the nodes.
APA0876 (4/17/2012)
Can you recommend some documentation specifying the steps of how to create a windows cluster and a SQL Server 2008 R2 Active/Passive cluster.read my guides at the following links for information on setting up the cluster and also setting up mount points which you may or may not want to use. The deploy guide uses a virtual system but the process is exactly the same for the cluster deployment.
Hi, I can't get the Part 3 where you included the creation of the Windows cluster and the install of the SQL Server Instaces, Can you please share that link?
Thanks
April 23, 2012 at 1:32 pm
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply