Active /Active configuration

• saidapurs

  Hall of Fame

  Points: 3477

  More actions

  September 24, 2012 at 11:34 pm

  #264707

  Hi All,

  I configured SQL cluster configuration successfully as Active /Passive but i am not understand how do i configure Active /Active?

  What is the use of Active /Active?

  Please help me or advice me how do i configure Active/Active configuration..

  Thanks & Regards

  Satish

• Perry Whittle

  SSC Guru

  Points: 233821

  More actions

  September 25, 2012 at 1:07 am

  #1541670

  saidapurs (9/24/2012)

  ---

  Hi All,

  I configured SQL cluster configuration successfully as Active /Passive but i am not understand how do i configure Active /Active?

  This term was previously used to describe a multi instance cluster. You would have more than 1 clustered instance running on more than one cluster node.

  saidapurs (9/24/2012)

  ---

  What is the use of Active /Active?

  Please help me or advice me how do i configure Active/Active configuration..

  Thanks & Regards

  Satish

  Typically you are utilising resources on a node that would otherwise be inactive, this can increase licencing costs though.

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• saidapurs

  Hall of Fame

  Points: 3477

  More actions

  September 26, 2012 at 12:28 am

  #1542218

  Hi Peery,

  I am using 1 cluster & multiple node. You mean multiple clusters are called active/active?

  Please collaborate this one....

  Thanks & Regards

  Satish Saidapur

• Matt Miller (4)

  SSC Guru

  Points: 124210

  More actions

  September 26, 2012 at 9:26 am

  #1542495

  no - in any given clustered instance, one node is active and one or more nodes are inactive.

  In the "active/active" setup, you would be looking to split your instance in half (so in theory you'd pslit the activity across nodes), and you'd ensure that one node is running one instance and the other node is running the other instance.

  So conceptually you'd be going from:

  Server/Instance (running 100 DB)

  Node1 active

  node2 inactive (passive)

  to something that looks more like (the numbers are purely there to represent an even split of the effort)

  SERVER/instance1 (running 50 db)

  Node1 active

  node2 passive

  SERVER/instance2 (running 50 db)

  Node1 passive

  node2 active

  So only one node is running any given DB at a time. That said you are using the hardware more efficiently, and under normal operation conditions you'd expect better performance because of that.

  This is not the same way other RDBMS leverage or define active/active.

  ----------------------------------------------------------------------------------
  Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

• Perry Whittle

  SSC Guru

  Points: 233821

  More actions

  September 26, 2012 at 10:14 am

  #1542522

  saidapurs (9/26/2012)

  ---

  Hi Peery,

  I am using 1 cluster & multiple node. You mean multiple clusters are called active/active?

  Please collaborate this one....

  Thanks & Regards

  Satish Saidapur

  Microsoft now prefer the term mutli instance cluster. At a basic level an active\passive cluster would be as follows

  ClusterNode1 ClustSQL-01\INST1 active

  ClusterNode2 ClustSQL-01\INST1 passive

  An active\active or multi instance cluster would be as follows

  ClusterNode1 ClustSQL-01\INST1 active

  ClustSQL-02\INST2 passive

  ClusterNode2 ClustSQL-01\INST1 passive

  ClustSQL-02\INST2 active

  Instances are active across the cluster nodes instead of all running on a single node

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉