question

kumar4ashwani avatar image
kumar4ashwani asked

Active-Active clustering vs Active-Passive clustering

For sql clustering (active-active) what changes do I need to make which are not used in active-passive clustering. I checked in a video that showed the same installation for active-active and active-passive. Please help.
clustering
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
0 Likes 0 ·
KenJ avatar image
KenJ answered
Not sure which video you watched, but the only difference is that an 'active active' cluster, which is now usually called a 'multi-instance failover cluster,' has more than one SQL instance configured as clustered resources. The setup and administration is identical to an 'active passive' cluster, which is now usually called a 'single instance failover cluster,' and is just a failover cluster instance with only a single instance configured as a clustered resource. I love Allan Hirt's short essay (diatribe) on the descriptive difference between the 'old' names and the new names for failover cluster instances. If you have a few minutes, it might be an enjoyable and informative read - [ http://sqlha.com/2012/01/09/once-more-with-feeling-stop-using-activepassive-and-activeactive/][1] [1]: http://sqlha.com/2012/01/09/once-more-with-feeling-stop-using-activepassive-and-activeactive/
6 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

it's not clear what your configuration looks like. Why do you list 6 IP addresses above? Which operating system does the cluster nodes run? For more help on sql server HA check my stairway at this link http://www.sqlservercentral.com/stairway/112556/ Regards Perry
1 Like 1 ·
I want to configure active active clustering as i configured like Like:- OS1--->failover insttallaed1---->node added for "failover insttallaed2" OS2--->failover insttallaed2---->node added for "failover insttallaed1" IP used:- for cluster------> 10.20.102.50--> failover insttallaed1 -->node failover insttallaed1 IP used:- for cluster------> 10.20.102.51--> failover insttallaed2--> node failover insttallaed2 SO please help me ,is it active active cluster or not, if yes the the then if "failover insttallaed1' and 'node failover insttallaed1' then how its resources go to 'failover insttallaed2'..?
0 Likes 0 ·
How many SQL instances are there in this?
0 Likes 0 ·
scenerio is :- SQlCLuster1--IP--10.125.11.11 SqlInstance1--IP--10.125.11.12 sqlnode-------IP--10.125.11.13 SQlCLuster2--IP--10.125.11.14 SqlInstance2--IP--10.125.11.13 sqlnode-------IP--10.125.11.12 Please suggest is it sql active/active cluster..? If yes then if "SQlCLuster1" gone fail(SqlInstance1 and its node) then how automatically all resorces and db's shift to SQlCLuster2 bacause these two seprate cluster.. If no then how can i make it active active.Please suggest
0 Likes 0 ·
Please re check its 4 ip's not 6 and i have configured two clusters.Also please clear about active active cluster only ...??? -----------First Cluster------------- SQlCLuster1--IP--10.125.11.11------ Virtual IP1 SqlInstance1--IP--10.125.11.12--Main Server IP sqlnode-------IP--10.125.11.13--Main Server Node IP ---------------second cluster:------------------ SQlCLuster2--IP--10.125.11.14--------Virtual IP2 SqlInstance2--IP--10.125.11.13-----Second main IP sqlnode-------IP--10.125.11.12 ---Second Server Node IP
0 Likes 0 ·
Show more comments
KenJ avatar image
KenJ answered
If you open failover cluster manager, I take it you can see both nodes and both SQL instances? If so, and everything is properly setup, then you do have a multi-instance ("active/active") failover cluster and SqlInstance1 will automatically move to SQlCLuster2 when SQlCLuster1 fails. You can test this within failover cluster manager by manually triggering a failover from of SqlInstance1 from SQlCLuster1 to SQlCLuster2. Within failover cluster manager, select the "Roles" from the left then right click your instance in the central pane and select "Move" you just "Select Node..." and move it to the other node.
7 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

you need at least 2 nodes, this should be fairly obvious. 1 instance runs on node 1 and another runs on node 2. I really recommend you read my stairway series linked above, you're asking questions which would be covered by reading the stairway. Each clustered instance you install requires a unique IP address. So, With a 2 node cluster and 2 instances of sql server you need 5 IP addresses. one for each node, one for each clustered instance and one for the cluster access point regards perry
1 Like 1 ·
but by choosing this option i will move to SQlCLuster1 "node" not to cluster SQlCLuster2. could you please share the process to switch from SQLCluster1 to SQLCluster2....?
0 Likes 0 ·
Please help me to get the solution..?
0 Likes 0 ·
I shared the process to switch between SQLCluster1 and SQLCluster2 (presuming those are two nodes within one cluster and not two separate clusters). Did it work? You haven't posted whether you can see both nodes and your SQL instance within Failover Cluster Manager. If you can then you have a failover cluster, if you can't then you don't - which sounds like the answer to the question you were asking. Is there some other specific thing you are looking for?
0 Likes 0 ·
I need only active active cluster configuration requirement working... 1.How many minimum server required for active active clustering... 2.How many minimum IP's required for active active cluster..? 3.Can i switch one cluster databases to another in active active clustering...? Please share the scenario with example....
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.