Active/passive/active clustering

Question

Post reply

Active/passive/active clustering

madhu-686862

SSChampion

Points: 10707
More actions
August 26, 2008 at 2:23 pm

#189760

Hi,
our cluster configuration is Active/Passive/Active.
Iam installing failover clustered instance in active node1 and in the set up wizard screen 'cluster configuration' do we need to select the other 2 nodes as well or just the Passive node?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 1

you need to add any node that you wish to be able to fail that instance over to.

madhu-686862 SSChampion Points: 10707 More actions · Answer 2

so there is no need to install the failover instance on all the nodes?

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 3

it depends on how you want it setup. Say you have a 3 node cluster and 2 nodes have active instances. if you are adding a 4th node, and you only want it to fail to the inactive node, then you would choose just the node you are installing to and the passive node. If you want more flexibility to be able to fail it to another active node, then I would include all the nodes

madhu-686862 SSChampion Points: 10707 More actions · Answer 4

madhu-686862

SSChampion

Points: 10707

August 26, 2008 at 3:04 pm

#863414

thanks Adam

madhu-686862 SSChampion Points: 10707 More actions · Answer 5

H Adam,

could you please answer this question.

We created like 3 groups SQLA,SQLB,SQLC and each group has drives in it.Say SQLA has A,B,C drives. When Iam trying install 4th failover cluster instance,in the setup wizard,its says SQLA,SQLB,SQLC are in use. I have no option to chose other group. Is there is any chance to reuse SQLA,SQLB,SQLC groups? or for every instance we need choose different group?

If there are like 10 failover instances to install ,do we need create 10 different groups and each group need to has their own disk resources?

Sam Greene SSCertifiable Points: 5252 More actions · Answer 6

Each instance needs it's own Network Name, IP and Disks - don't they?

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 7

I have not found a way to reuse the disks. I suppose that they did that just to ensure all instances are independent of each other. We use mount points (I think they are called that) so that we can have 3 seperate physical disks only occupy one drive letter, so you only use a single drive letter, but still reap the benefits of having 3 different disks.