Active/Active/Passive questions?

Active/Active/Passive questions?

I have setup Active/Passive in the past with no problems
With Active/Active/Passive are all nodes on the same heartbeat?
Is the correct Private IP configuration correct?

Node1 10.0.0.1
Node2 10.0.0.2
Node3 10.0.0.3

If I go with this setup do both active nodes point at the passive mode as a 
failover?
Does Active Node1 and Active node2 need to know about one another?

Any tips helpful

Thanks,
Dave

date: Mon, 21 Apr 2008 11:11:00 -0700 author: Duparoni

Re: Active/Active/Passive questions?

All nodes must share the heartbeat network, so yes, the IP's are correct.

Any node can host a service, so it doesn't matter which is not running a
service.  They all know about each other.

-- 
   Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON   Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Duparoni"  wrote in message
news:37DC3821-A3DE-4BBE-A6C1-F45A1CB8FF83@microsoft.com...
I have setup Active/Passive in the past with no problems
With Active/Active/Passive are all nodes on the same heartbeat?
Is the correct Private IP configuration correct?

Node1 10.0.0.1
Node2 10.0.0.2
Node3 10.0.0.3

If I go with this setup do both active nodes point at the passive mode as a
failover?
Does Active Node1 and Active node2 need to know about one another?

Any tips helpful

Thanks,
Dave

date: Mon, 21 Apr 2008 16:08:29 -0400 author: Tom Moreau

Re: Active/Active/Passive questions?

It gets a bit more interesting than that in clusters with 3 or more nodes. 
The heartbeat messages are actually multicast IP, not directed IP.  That 
means you need to either fix a multicast IP for each node, create a MADCAP 
server (DHCP for Multicast), or deal with a lot of junk error messages in 
the event logs.  Personally, I let the servers settle on multicast addresses 
and then lock them in.

You still need the directed IP addresses on the heartbeat nodes and everyone 
must see everyone else.

-- 
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP





"Duparoni"  wrote in message 
news:37DC3821-A3DE-4BBE-A6C1-F45A1CB8FF83@microsoft.com...
>I have setup Active/Passive in the past with no problems
> With Active/Active/Passive are all nodes on the same heartbeat?
> Is the correct Private IP configuration correct?
>
> Node1 10.0.0.1
> Node2 10.0.0.2
> Node3 10.0.0.3
>
> If I go with this setup do both active nodes point at the passive mode as 
> a
> failover?
> Does Active Node1 and Active node2 need to know about one another?
>
> Any tips helpful
>
> Thanks,
> Dave

date: Mon, 21 Apr 2008 16:28:02 -0400 author: Geoff N. Hiten

RE: Active/Active/Passive questions?

> If I go with this setup do both active nodes point at the passive mode as a 
> failover?

Technically, a node deson't point to any other node for failover. Failover 
is configured for each resource group.

Linchi

"Duparoni" wrote:

> I have setup Active/Passive in the past with no problems
> With Active/Active/Passive are all nodes on the same heartbeat?
> Is the correct Private IP configuration correct?
> 
> Node1 10.0.0.1
> Node2 10.0.0.2
> Node3 10.0.0.3
> 
> If I go with this setup do both active nodes point at the passive mode as a 
> failover?
> Does Active Node1 and Active node2 need to know about one another?
> 
> Any tips helpful
> 
> Thanks,
> Dave

date: Mon, 21 Apr 2008 19:37:01 -0700 author: Linchi Shea

Re: Active/Active/Passive questions?

or you can turn off multi cast: http://support.microsoft.com/kb/307962



"Geoff N. Hiten"  wrote in message
news:O7HR04%23oIHA.4912@TK2MSFTNGP03.phx.gbl...
> It gets a bit more interesting than that in clusters with 3 or more nodes.
> The heartbeat messages are actually multicast IP, not directed IP.  That
> means you need to either fix a multicast IP for each node, create a MADCAP
> server (DHCP for Multicast), or deal with a lot of junk error messages in
> the event logs.  Personally, I let the servers settle on multicast
addresses
> and then lock them in.
>
> You still need the directed IP addresses on the heartbeat nodes and
everyone
> must see everyone else.
>
> -- 
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
>
>
> "Duparoni"  wrote in message
> news:37DC3821-A3DE-4BBE-A6C1-F45A1CB8FF83@microsoft.com...
> >I have setup Active/Passive in the past with no problems
> > With Active/Active/Passive are all nodes on the same heartbeat?
> > Is the correct Private IP configuration correct?
> >
> > Node1 10.0.0.1
> > Node2 10.0.0.2
> > Node3 10.0.0.3
> >
> > If I go with this setup do both active nodes point at the passive mode
as
> > a
> > failover?
> > Does Active Node1 and Active node2 need to know about one another?
> >
> > Any tips helpful
> >
> > Thanks,
> > Dave
>

date: Tue, 22 Apr 2008 11:13:58 +0100 author: Edwin vMierlo [MVP]

RE: Active/Active/Passive questions?

So how does the Crossover coniguration work with 3 nodes?
I need a crossover from Node1 to Node2 and Node1 to Node3?
Then Node2 to Node3?



"Duparoni" wrote:

> I have setup Active/Passive in the past with no problems
> With Active/Active/Passive are all nodes on the same heartbeat?
> Is the correct Private IP configuration correct?
> 
> Node1 10.0.0.1
> Node2 10.0.0.2
> Node3 10.0.0.3
> 
> If I go with this setup do both active nodes point at the passive mode as a 
> failover?
> Does Active Node1 and Active node2 need to know about one another?
> 
> Any tips helpful
> 
> Thanks,
> Dave

date: Tue, 22 Apr 2008 08:11:02 -0700 author: Duparoni

Re: Active/Active/Passive questions?

When you have > 2 nodes, you will need a hub.  A crossover will not do.

-- 
   Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON   Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"Duparoni"  wrote in message
news:207B531E-E253-42B0-9907-FF8E72CF5DCF@microsoft.com...
So how does the Crossover coniguration work with 3 nodes?
I need a crossover from Node1 to Node2 and Node1 to Node3?
Then Node2 to Node3?

"Duparoni" wrote:

> I have setup Active/Passive in the past with no problems
> With Active/Active/Passive are all nodes on the same heartbeat?
> Is the correct Private IP configuration correct?
>
> Node1 10.0.0.1
> Node2 10.0.0.2
> Node3 10.0.0.3
>
> If I go with this setup do both active nodes point at the passive mode as
a
> failover?
> Does Active Node1 and Active node2 need to know about one another?
>
> Any tips helpful
>
> Thanks,
> Dave

date: Tue, 22 Apr 2008 12:58:16 -0400 author: Tom Moreau

Re: Active/Active/Passive questions?

> When you have > 2 nodes, you will need a hub.  A crossover will not do.
>

or a switch and dedicated VLAN.

date: Wed, 23 Apr 2008 09:00:33 +0100 author: Edwin vMierlo [MVP]