November 30, 2012 at 6:48 am
Ok,
So ... I am trying to test sql 2012 using Windows 2008 R2 and freeNAS for the share disks or LUNs.
I was able to setup the two nodes, create the iSCSI LUNs using freeNAS, joined to domain, setup the DC, etc, but just before running the Cluster setup and while staying on Node 1 (Node 2 up and running) the LUNs or SQL drives disappear making the Cluster validation fail.
Do I have to turn Node 2 down? I recall for SQL 2008 that's no longer needed but because this is a virtual SAN using freeNAS, not sure if it's some type or bug or required step.
I am really close to finish this test, this is the only thing stopping me from success...
Any advice?
Here's what I am using
-freeNAS
-Windows 2008 R2 Enterprise on Nodes
-Windows 2008 R2 Standard on DC
-VMWare Workstation 9
November 30, 2012 at 9:19 am
you'll typically see this when there aren't enough resources on the host machine to service all the VMs. Can you supply the full spec of your VMWare host?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 9:39 am
Perry Whittle (11/30/2012)
you'll typically see this when there aren't enough resources on the host machine to service all the VMs. Can you supply the full spec of your VMWare host?
Here are the full specs
-Dell Optiplex 790
-8GB RAM
-Intel i7 3.4 GHZ
To be honest, it feels kind of slow when DC, freeNAS and two nodes are up. I gave 2GB to each node, I may reduce for performance. I got the feeling the LUNs got corrupted.
This is my plan, so I won't loose my past two days work:
-Delete iSCSI mapping from nodes
-Delete LUNs from freeNAS box
-Recreate LUNs on freeNAS
-Start each node and map LUN
-Build cluster but one node 1st, the add 2nd (minimize LUN issue maybe?)
November 30, 2012 at 10:59 am
What are the specs for each VM?
You have to bear in mind that the host will have an overhead for its OS and the VMWare Workstation Hypervisor before you even start installing VMs. Using a Windows core installation for the DC will help conserve resources, it's best to run it all on ESX though. ESX literally runs on fresh air leaving oodles of resources for your VMs.
As a guide I have the following
Host
ESXi 5.1
6 core AMD CPU
16GB RAM
2 x Intel 1GB NICs
2 x 149GB SATA disks
1 x 500GB SATA disk
VMs
1 x Windows 2008 Core R2 DC 1vCPU and 1GB RAM
2 x Windows 2012 cluster nodes 2 vCPU and 2 GB RAM
2 x Windows 2008 R2 cluster nodes 2 vCPU and 2GB RAM
1 x Windows 2012 storage server 2 vCPU and 2GB RAM
1 x Windows 2008 server 2 vCPU and 1GB RAM
1 x Windows 7 pc 1 vCPU and 1GB RAM
1 x Windows XP pc 1 vCPU and 1GB RAM
3 x Windows 2003 R2 1 vCPU and 1.25GB RAM
At any one time i have around 6 VMs booted and running with no issues at all. I did have a couple of SQL 2012 nodes i use for AlwaysOn but i deleted those as i'm going to re deploy them.
The improvements in Windows storage server have encouraged me to move to this storage medium for the iSCSI LUNs and it's quite stable too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 12:04 pm
I'll have a "beefy" machine on two months, in our main data centers; a full VMware Server, but had to work with these specs for now. That's the reason for the slow PC I am using now, and VMware Workstation.
I managed to fix the issue, so far, reducing RAM to 1GB per node and I am configuring the Cluster node by node. So far so good ... I also reset or recreate the volume on freeNAS
November 30, 2012 at 12:52 pm
You must ensure that while no cluster is formed that the 2 nodes do not try to access the disks at once otherwise corruption occurs. Simply hold off exposing the LUNs to the second node via the iscsi initiator until the cluster is formed and operational.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 1:16 pm
Wohooo! ... 😛 ... success ....
November 30, 2012 at 1:43 pm
cracked it have you? 😉
-----------------------------------------------------------------------------------------------------------
"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