Re: Three Node cluster - Active /Active /Passive
- From: "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx>
- Date: Tue, 9 Aug 2005 09:26:22 -0400
1) Yes.
2) Two Virtual Servers
3) Poorly.
In practice, You will likely allow each SQL Server to use an entire host
node's resources, knowing that there is a "spare" node available during a
failover. When a failover occurs, I typically reset the memory requirements
for each instance so I can "stack" muptiple instances on the same node. I
always have alerting to detect when a failover occurrs so someone can pay
immediate attention to the problem.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Viking" <Viking@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14B196AE-3679-4266-B6A1-DAF3D71D9F1B@xxxxxxxxxxxxxxxx
> Hello everybody,
>
> We are trying to consolidate our servers, by moving databases to instances
> (3 nodes) running under Active /Active /Passive mode.
>
> My doubts here are
>
> (1) Can we ever do this? I said "Yes", it may be possible but never tried.
> (2) If yes, how many virtual servers would we need (two or three)?
> (3) Now with passive Node how it is going to work if both the servers were
> to fail?
>
> TIA
.
- References:
- Three Node cluster - Active /Active /Passive
- From: Viking
- Three Node cluster - Active /Active /Passive
- Prev by Date: RE: Need advise on SQL Server installating in MS cluster 2k3 Major
- Next by Date: RE: Need advise on SQL Server installating in MS cluster 2k3 Major
- Previous by thread: RE: Three Node cluster - Active /Active /Passive
- Next by thread: Need advise on SQL Server installating in MS cluster 2k3 Majority
- Index(es):
Relevant Pages
|
