Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Setting up a SQL cluster under MS VS2005 R2 Part2


Setting up a SQL cluster under MS VS2005 R2 Part2

Author
Message
Perry Whittle
Perry Whittle
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15648 Visits: 17032
Comments posted to this topic are about the item Setting up a SQL cluster under MS VS2005 R2 Part2

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
alen teplitsky
alen teplitsky
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2222 Visits: 4654
not that i'll ever run SQL under VS 2005 in production, but isn't one of the benefits of virtualization that you don't need to set up MS clusters? the servers that host your virtual environment should be clustered so there is no reason to set up VM's that are clusters
Perry Whittle
Perry Whittle
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15648 Visits: 17032
thanks for your reply. The document does specify you should only use for test\educational purposes and that options such as VMWare HA make this redundant. Its more for people who want to learn or test, you cant generally play around with live clusters ;-)

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
lfguzman_25
lfguzman_25
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 167
Hi this are good instructions to make a windows clustering. I already made a cluster in Virtual Server 2005 with 3 nodes, and my configuration are 2 active nodes and one passive node. I can mount the volumes so i can have more scsi disks to implement clustering.
This procedure can not be done in Production environment. Has to be for development.

Greetings and good post.
;-)
alen teplitsky
alen teplitsky
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2222 Visits: 4654
is there any benefit to setting up a dev/qa cluster? we have clustered SQL servers but our dev and qa are on standalone sql servers and we have never had a problem
mojo-168709
mojo-168709
SSC Eights!
SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)

Group: General Forum Members
Points: 965 Visits: 831
SQL Noob (5/15/2009)
is there any benefit to setting up a dev/qa cluster?


The benefits are plenty. We use QA SQL cluster to test service pack installs; we also test the effect of failover to the applications so that the app developers would retry the connection when the failover occurs, instead of generating nasty app errors to the users.
noeld
noeld
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7794 Visits: 2048
SQL Noob (5/15/2009)
is there any benefit to setting up a dev/qa cluster? we have clustered SQL servers but our dev and qa are on standalone sql servers and we have never had a problem


In addition there are components like replication, logshipping and mirroring that you may want to test while you combine multiple technologies and this not only applies to clustering but to any thing you want to test that could be possibly difficult to emulate on a real system.
"VM" should, In my opinion be the King of QA and DEV


* Noel
Perry Whittle
Perry Whittle
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15648 Visits: 17032
SQL Noob (5/15/2009)
is there any benefit to setting up a dev/qa cluster?

as i said above, you can play to your hearts content without fear of retribution. Mojo pointed out the most obvious use. As VM's you can snapshot then install SP's or hotfixes, etc. As VM's you can revert back to the snapshot (you have to take copies of the virtual clustered disks too where the databases reside).

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

"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