May 19, 2005 at 2:26 pm
Hi Everyone!
I have a Active Passive cluster configuration with two nodes (A & B) hosting one sql server instance (SQLDBServer1). The cluster disk resource E,F, G and H are used for SQLDBServer1 . A is the primary node. I was wondering if I can have the failover node - B run another instance of sql server (SQLDBServer2) at the same time. SQLDBServer2 will have B as its primary node and A as its failover node. SQLDBServer2 will use I and J disk resource.
Is this possible? if yes, then are there any drawbacks?
Thanks
Rosh
May 20, 2005 at 2:44 am
yes, but it needs its OWN set of Cluster Disk resources, ie one for the shared files (master, temdb etc), and the other for the Log and DB files. Apart from that, this setup works fine.
Oh, and u probably want to make a good guestimate about how much memory each one needs and cap it for each instance ... seeing as there IS a chance that both instances can end up on the same node!
Advantages : Ur passive node isn't sitting there doing nothing!?
Disadvantages : U'll need get another server license, as both are now doing work!
Basically, yeah .... this works a treat!!
May 20, 2005 at 6:47 am
You'll then have an Active-Active cluster.
May 20, 2005 at 9:23 am
yeah it should probably now be called active active. Actually we had active passive setup and then we were asked to utilize the second node. now since both the servers would be running sql server this should be called active active. Thanks Vinny for throwing light on the issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply