November 24, 2012 at 4:04 am
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
November 24, 2012 at 4:56 am
November 27, 2012 at 7:23 am
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.
November 27, 2012 at 12:09 pm
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 ...
November 27, 2012 at 2:22 pm
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" 😉
November 27, 2012 at 3:15 pm
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.
November 27, 2012 at 3:50 pm
sql-lover (11/27/2012)
And you say that now! 😀
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" 😉
November 28, 2012 at 7:15 am
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 ...
November 28, 2012 at 9:22 am
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" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply