Active/Active/Passive Cluster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Active/Active/Passive Cluster

I’ve been doing a lot of reading on clustering and would just like someone to confirm that I’m understanding all this correctly. The company I work for have a database application and also want to implement MS Sharepoint. Am I right in saying that I can have three nodes:
one with a SQL instance to run the db app.
one with a SQL instance to run sharepoint.
And finally, a third node to act as failover for both of these apps, effectivly giving me an N+1 configuration? Thanks in advance for any help.

This sounds right. Raulie
This sounds right. Raulie
On the second one you have to see whether Sharepoint will work with automatic failover, as SQL server can.
THis could be a problem in relying the automated high availability solution. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Does that still apply if we have a sharepoint farm i.e. seperate front end web servers/app servers etc so that the only part of Sharepoint that’s in the cluster is the database? Simon
I think it should work, I’m not sure but its better to check with Sharepoint (Office) related forums or articles in this case, we have had such issues in the past using Sharepoint & SQL within the clustered environment. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>