scaling SQL standard two node cluster

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 ?  
shadow2007Asked:
Who is Participating?
 
Ted BouskillSenior Software DeveloperCommented:
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
 
Ted BouskillSenior Software DeveloperCommented:
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
 
shadow2007Author Commented:
other replication strategies such as ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
shadow2007Author Commented:
hi ted thank you very much for your help, out of curiosity can mirroring be done on sql express ?
0
 
shadow2007Author Commented:
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
 
Ted BouskillSenior Software DeveloperCommented:
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
 
shadow2007Author Commented:
thanks ted
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.