Setting up a SQL cluster under MS VS2005 R2 Part2

Question

Setting up a SQL cluster under MS VS2005 R2 Part2

Perry Whittle

SSC Guru

Points: 234013
More actions
May 15, 2009 at 12:21 am

#200543

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" 😉

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 1

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 SSC Guru Points: 234013 More actions · Answer 2

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 SSC Veteran Points: 261 More actions · Answer 3

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 SSC-Dedicated Points: 30014 More actions · Answer 4

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 SSCommitted Points: 1825 More actions · Answer 5

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 SSC Guru Points: 96590 More actions · Answer 6

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 SSC Guru Points: 234013 More actions · Answer 7

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" 😉