?
Solved

scaling SQL standard two node cluster

Posted on 2007-10-19
7
Medium Priority
?
696 Views
Last Modified: 2011-10-03
I am about to implement a 2 node SQL 2005 standard cluster, I want to be prepared to scale any recommendations ? issues with scaling to more than 2nodes and having redundant locations ?  
0
Comment
Question by:shadow2007
  • 4
  • 3
7 Comments
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 20112277
SQL 2005 Standard Edition can only include two nodes so that eliminates scalability.  Otherwise you have to use SQL 2005 Enterprise.

Also all nodes have to belong to the same domain (OU)  I don't think clustering over a WAN would be efficient, you'd have to have multiple clusters and use other replication strategies.
0
 

Author Comment

by:shadow2007
ID: 20123238
other replication strategies such as ?
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 2000 total points
ID: 20125006
Mirroring, Log Shipping or my least favourite, Replication are your main choices.  However, there is latency involved because the primary database will always be newer than the duplicates otherwise the overhead of continuously duplicating the data will kill performance.

I prefer to keep all my data in one location and distribute the front end web applications.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:shadow2007
ID: 20186040
hi ted thank you very much for your help, out of curiosity can mirroring be done on sql express ?
0
 

Author Comment

by:shadow2007
ID: 20186120
btw once I hear from you about mirrioring or log shipping on sql express ....(not easy to find relieable experts out here :) ) i will be accepting your solution
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 20186965
Yes and no.  The SQL 2005 can only retain the copy, not publish the original.

Here is a good link that explains it: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
0
 

Author Comment

by:shadow2007
ID: 20187279
thanks ted
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question