Planning Ahead - Single Node Clusters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Andrew Hatfield » Planning Ahead - Single Node Clusters

19 posts, Page 2 of 2

««1 2

Planning Ahead - Single Node Clusters

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Wednesday, June 17, 2009 8:35 AM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

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

SuperDBA-207096

Posted Wednesday, June 17, 2009 11:05 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 02, 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

admin-1102965

Posted Wednesday, June 17, 2009 11:14 AM

Forum 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

Ven-450262

Posted Wednesday, June 17, 2009 11:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 06, 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

noeld

Posted Wednesday, June 17, 2009 12:07 PM

SSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260, Visits: 1,977

By the way many Hardware restrictions have been eliminated in SQL 2008

* Noel

Post #736865

admin-1102965

Posted Wednesday, June 17, 2009 12:45 PM

Forum 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

tferguson

Posted Wednesday, June 17, 2009 12:56 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 7:46 AM
Points: 11, Visits: 265

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

@STLSQLGuy

Posted Wednesday, June 17, 2009 2:11 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 4:17 PM
Points: 80, Visits: 203

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

mishaluba

Posted Thursday, June 18, 2009 5:59 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

Great idea! Using cluster to simplify hardware upgrades and minimize resulting impact to the end users. Thank you!

Post #737997

« Prev Topic | Next Topic »

19 posts, Page 2 of 2

««1 2

Permissions