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

windows cluster ip Configuration. Expand / Collapse
Author
Message
Posted Saturday, November 24, 2012 4:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 10:09 PM
Points: 208, Visits: 1,040
hello experts,
i want to configure cluster in my laptop (8GB RAM, i7, 1 TB disk), so i have installed VMware 9 and created two virtual machines, and In both the machines i have installed windows server 2008 Datacenter edition and in one of them i configure Domain controller service, as per my knowledge there should be two types of network private(to communicate both server each other) and public for application connectivity, and for that i have to configure minimum 2 IPs on each machine and one IP for cluster (total 5 IPs), but i have very less knowledge in networking so please let me know from scratch how to do such configuration. like assigning IPs and what IP i can provide (ranges)???

your responce will be appreciable

thanks
Post #1388299
Posted Saturday, November 24, 2012 4:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 6,760, Visits: 14,410
Follow my guide at these links
Part 1
Part 2
Part 3


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1388302
Posted Tuesday, November 27, 2012 7:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 416, Visits: 1,346
Perry Whittle (11/24/2012)
Follow my guide at these links
Part 1
Part 2
Part 3


Thanks for sharing.

Perry,
Do you think I can use this as a guide for a SQL 2012 Cluster? Planning to do some testing at home this week.

Also, I do have VMware running on my Mac systems at home. But do not remember if I need to download something additional in order to re-create the share disk.
Post #1389183
Posted Tuesday, November 27, 2012 12:09 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 416, Visits: 1,346
Disregard previous post! ...

I am actually deploying a Virtual SQL 2012 Cluster following this guide. Here's the quick software list:

-VMware Workstation 9.0
-freeNAS 8.2
-Win 2008 R2 evaluation ed.

So far so good. I managed to setup the shared storage using freeNAS and installing DC and Node1 now. The freeNas screenshots and option are totally different though. Menu changed ...
Post #1389366
Posted Tuesday, November 27, 2012 2:22 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 6,760, Visits: 14,410
sql-lover (11/27/2012)
Disregard previous post! ...

I am actually deploying a Virtual SQL 2012 Cluster following this guide. Here's the quick software list:

-VMware Workstation 9.0
-freeNAS 8.2
-Win 2008 R2 evaluation ed.

So far so good. I managed to setup the shared storage using freeNAS and installing DC and Node1 now. The freeNas screenshots and option are totally different though. Menu changed ...

I now use Windows storage server to create iSCSI targets that are exposed to the cluster nodes, but if you're happy using FreeNAS thats fine. If you're using the later version of FreeNAS there'll definitely be changes in the menu.

The SQL Server installer hasn't changed too much between 2008 R2 and 2012, so no great shakes there.

Post back if you get stuck.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1389413
Posted Tuesday, November 27, 2012 3:15 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 416, Visits: 1,346
Perry Whittle (11/27/2012)

I now use Windows storage server to create iSCSI targets that are exposed to the cluster nodes, but if you're happy using FreeNAS thats fine.


And you say that now!

Yeah, I was stuck for 2 hours here at work. I was not able to see the iSCSI disks from Windows. And it was because a stupid mistake: the iSCSI service was "off". I do not think that explanation is on your tutorial, because I believe that's what you call there "enable iSCSI target" or something like that. Once I turned on, voila' ... silly mistake from my part.

I like freeNAS, never used it, so I am glad I am learning new stuff. Back to 2003 when I build my 1st Virtual Cluster, I used fixed shared storage that found online. Ohhh... those times , lol, it was SQL 2000 and Win 2003.

I know that if I pass this part (shared disks and attach those to Windows) the rest is piece of cake for me: DC, joining nodes, etc. I think SQL 2012 cluster setup is similar to SQL 2008, but wanted to give a try.
Post #1389434
Posted Tuesday, November 27, 2012 3:50 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 6,760, Visits: 14,410
sql-lover (11/27/2012)
And you say that now!

Ahem, cough, cough
The guide was written over a year ago



sql-lover (11/27/2012)
I was not able to see the iSCSI disks from Windows. And it was because a stupid mistake: the iSCSI service was "off". I do not think that explanation is on your tutorial, because I believe that's what you call there "enable iSCSI target" or something like that.

Are you referring to this section of Part1?

Perrys rather excellent guide
Once this is done you may then go to "Services" > "iSCSI target". The first task is to enable the iSCSI Target by checking the box indicated and then clicking "Save and restart".


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1389443
Posted Wednesday, November 28, 2012 7:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 416, Visits: 1,346
I can help you and modify yours ... or give you screenshots. I may do this two or three times for learning purposes and prior my business trip next week.

However, just faced a small challenge after I fixed the iSCSI issue. I was able to format one of the partition, but having issues with the others. I am getting this similar error

 
Nov 16 00:40:33 freenas istgt[7437]: istgt_lu_disk.c:3960:istgt_lu_disk_lbwrite: ***ERROR*** lu_disk_write() failed
Nov 16 00:40:33 freenas istgt[7437]: istgt_lu_disk.c:6051:istgt_lu_disk_execute: ***ERROR*** lu_disk_lbwrite() failed
Nov 16 00:40:33 freenas istgt[7437]: istgt_lu_disk.c:3960:istgt_lu_disk_lbwrite: ***ERROR*** lu_disk_write() failed
Nov 16 00:40:33 freenas istgt[7437]: istgt_lu_disk.c:6051:istgt_lu_disk_execute: ***ERROR*** lu_disk_lbwrite() failed



Got the feeling /var/log got full on the freeNAS, but not sure. It may be data corruption or a freeNAS bug too ... checking ...
Post #1389762
Posted Wednesday, November 28, 2012 9:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 6,760, Visits: 14,410
I'm already working on a guide for sql server 2012, windows 2012 on ESX5.1i

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1389904
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse