|
Home > Archive > MS SQL Server Clustering > April 2005 > 2 Node SQL Cluster, Instance on Each Node
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
2 Node SQL Cluster, Instance on Each Node
|
|
| John - PDX 2005-04-19, 8:23 pm |
| 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?
--
Thanks,
John
| |
| Rodney R. Fournier [MVP] 2005-04-20, 3:23 am |
| 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
"John - PDX" <JohnPDX@discussions.microsoft.com> wrote in message
news:774BF52E-A7FF-44AC-B863- FC7B0035C07D@microso
ft.com...
> 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?
> --
> Thanks,
> John
| |
| Mike Epprecht (SQL MVP) 2005-04-20, 3:23 am |
| 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
"Rodney R. Fournier [MVP]" wrote:
> 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
>
> "John - PDX" <JohnPDX@discussions.microsoft.com> wrote in message
> news:774BF52E-A7FF-44AC-B863- FC7B0035C07D@microso
ft.com...
>
>
>
| |
| Geoff N. Hiten 2005-04-20, 9:23 am |
| 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/defaul...kb;en-us;254321
Geoff N. Hiten
Microsoft SQL Server MVP
"John - PDX" <JohnPDX@discussions.microsoft.com> wrote in message
news:774BF52E-A7FF-44AC-B863- FC7B0035C07D@microso
ft.com...
> 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?
> --
> Thanks,
> John
|
|
|
|
|