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

Setting up a SQL cluster under MS VS2005 R2 Part2 Expand / Collapse
Author
Message
Posted Friday, May 15, 2009 12:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #717640
Posted Friday, May 15, 2009 8:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 10, 2014 9:36 AM
Points: 1,414, Visits: 4,544
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

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #717957
Posted Friday, May 15, 2009 10:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #718087
Posted Friday, May 15, 2009 10:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 9:57 AM
Points: 17, Visits: 157
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.
Post #718098
Posted Friday, May 15, 2009 10:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 10, 2014 9:36 AM
Points: 1,414, Visits: 4,544
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

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #718111
Posted Friday, May 15, 2009 11:03 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 10:46 AM
Points: 911, 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.
Post #718120
Posted Friday, May 15, 2009 1:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:34 AM
Points: 6,259, Visits: 2,031
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
Post #718251
Posted Saturday, May 16, 2009 11:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #718543
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse