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 ««12

Planning Ahead - Single Node Clusters Expand / Collapse
Author
Message
Posted Wednesday, June 17, 2009 8:35 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:35 AM
Points: 33,102, Visits: 15,213
Andrew,

Great job and I'm glad you wrote the article. When I saw you mention it, I was surprised as it seems many other people were today. It's a great idea.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #736622
Posted Wednesday, June 17, 2009 11:05 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
Andrew,
Well done!

How hard is it to add a new node to SQL Cluster? Does SQL setup happen auto-magically (like when you install SQL on a 2 node cluster) when you add the node or are additional steps required?

Mark
Post #736820
Posted Wednesday, June 17, 2009 11:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 2:40 PM
Points: 2, Visits: 4
The article seemed to lack software requirements for a MSSQL cluster. We operate different versions of MSSQL, from what I've read only SQL Enterprise supports clustering. With that said, there's a high cost involved with the software itself. Anyone with ideas on clustering with a lower end version of MSSQL like Standard, or Web? We're considering "log shipping" and backing up to a central location so we can restore from a second active or standby SQL server.
Post #736823
Posted Wednesday, June 17, 2009 11:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 6, 2012 2:00 PM
Points: 6, Visits: 142
Hello Admin,

SQLServer 2005 standard version supports only 2 node clustering, where as Enterprise version supports multiple nodes.

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
Post #736828
Posted Wednesday, June 17, 2009 12:07 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:51 AM
Points: 6,266, Visits: 2,028
By the way many Hardware restrictions have been eliminated in SQL 2008


* Noel
Post #736865
Posted Wednesday, June 17, 2009 12:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 2:40 PM
Points: 2, Visits: 4
Thanks Ven, looks like Standard 2008 does the same.

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

Coming in at approx $5000/ea processor license. For kicks, estimate this project would cost:

2 x Servers @ $7000
1 x SAN @ $10000
2 x Switches @ 2500
2 x MSSQL Proc Lic @ 5000
----
$39,000

Post #736888
Posted Wednesday, June 17, 2009 12:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:12 PM
Points: 11, Visits: 286
Interesting concept, thanks for an eye opening article. However, as a fan of the 'Keep it Simple' club, I'd prefer not to have to configure & keep updated all of the clustering requirements/options/services etc. if not absolutely necessary. We have several clustered servers, active/passive, active/active. I'd have to keep cluster manager up all the time if all the 150 others were single node clusters. We use dns alias when switching servers to avoid code/client changes, & log shipping from the old to the replacement until the actual switchover.
Post #736896
Posted Wednesday, June 17, 2009 2:11 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 14, 2013 11:03 AM
Points: 80, Visits: 204
Previous versions of cluster services were very particular about the installation process. So much so that in the event of an error sometimes it was easier to start over rather than debug the issues. On top of that installing SQL Server and adding it to a 2nd, 3rd, etc node was not always so straight forward.
Have you found any obvious stumbling blocks on taking Nodes/SQL Servers in and out of the clustered environment?



thanks, ERH
Post #736961
Posted Thursday, June 18, 2009 5:59 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 3:45 PM
Points: 536, Visits: 752
Great idea! Using cluster to simplify hardware upgrades and minimize resulting impact to the end users. Thank you!


Post #737997
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse