Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Thu, 26 Jun 2008 23:05:00 -0700,    group: microsoft.public.sqlserver.clustering        back       


Number of nodes for sql clustering   
Hi,

i understand that the technology for clustering are N+1 or N+m. However, Can 
1 deploy sql cluster nodes in odd numbers? Example, 3 nodes with 
active/active/passive or 5 nodes with 3 active/2 passive ??

Many thanks!!
regards,
Windows Fan
date: Thu, 26 Jun 2008 23:05:00 -0700   author:   chua

Re: Number of nodes for sql clustering   
> Hi,
>
> i understand that the technology for clustering are N+1 or N+m. However,
Can
> 1 deploy sql cluster nodes in odd numbers? Example, 3 nodes with
> active/active/passive or 5 nodes with 3 active/2 passive ??

Yes you can, in your own example:

3-node a/a/p -- you have 2 instances of SQL one running on node 1, one
running on node 2, none running on node 3

In this example you run a N+1 where N=2

Rgds,
Edwin.
date: Fri, 27 Jun 2008 09:05:35 +0100   author:   Edwin vMierlo [MVP]

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us