Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Active /Active configuration


Active /Active configuration

Author
Message
saidapurs
saidapurs
SSC Veteran
SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)

Group: General Forum Members
Points: 209 Visits: 414
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
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8843 Visits: 16579
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
saidapurs
SSC Veteran
SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)

Group: General Forum Members
Points: 209 Visits: 414
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)
Matt Miller (#4)
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7664 Visits: 18097
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
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8843 Visits: 16579
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" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search