SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


windows cluster ip Configuration.


windows cluster ip Configuration.

Author
Message
Zeal-DBA
Zeal-DBA
Old Hand
Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)

Group: General Forum Members
Points: 337 Visits: 1125
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
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19826 Visits: 17242
Follow my guide at these links
Part 1
Part 2
Part 3

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1579 Visits: 1930
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.
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1579 Visits: 1930
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 ...
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19826 Visits: 17242
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" ;-)
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1579 Visits: 1930
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! :-D

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.
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19826 Visits: 17242
sql-lover (11/27/2012)
And you say that now! :-D

Ahem, cough, cough Whistling
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" ;-)
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1579 Visits: 1930
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 ...
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19826 Visits: 17242
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" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search