2 Node SQL Cluster, Instance on Each Node

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - PDX - 19 Apr 2005 20:27 GMT

Can one deploy a 2 node cluster with an instance on each node and the
failover node be the other? Like node A & node B, A's instance fails to B
and B's instance fails to A?

Signature

Thanks,
John

Reply to this Message

Rodney R. Fournier [MVP] - 20 Apr 2005 03:16 GMT

Yes, you can. This is allowable.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog

> Can one deploy a 2 node cluster with an instance on each node and the
> failover node be the other? Like node A & node B, A's instance fails to B
> and B's instance fails to A?

Reply to this Message

Mike Epprecht (SQL MVP) - 20 Apr 2005 08:01 GMT

In effect, you could run 8 instances on each node, with a maximum of 16 per
cluster.

Just make sure you configure SQL Server to not use all the memory on one
node, as during a failover, the other instance needs RAM too.

Regards
Mike

> Yes, you can. This is allowable.
>
[quoted text clipped - 9 lines]
> > failover node be the other? Like node A & node B, A's instance fails to B
> > and B's instance fails to A?

Reply to this Message

Geoff N. Hiten - 20 Apr 2005 14:54 GMT

As Mike and Rodney indicated, you can run up to 16 instances on a cluster
and divide them however you choose. To choose, you set the preferred host
order for each SQL resource group using the cluster admin tool. As Mike
warned, you must plan for all instances to "collapse" onto a single node
duriing a failover situation.

Here is a useful KB article that covers Memory allocation on a cluster along
with a lot o other very good topics.

Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/default.aspx?scid=kb;en-us;254321

Geoff N. Hiten
Microsoft SQL Server MVP

> Can one deploy a 2 node cluster with an instance on each node and the
> failover node be the other? Like node A & node B, A's instance fails to B
> and B's instance fails to A?

Reply to this Message