Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Active /Active configuration Expand / Collapse
Author
Message
Posted Monday, September 24, 2012 11:34 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, 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
Post #1363793
Posted Tuesday, September 25, 2012 1:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 5,970, Visits: 12,866
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"
Post #1363819
Posted Wednesday, September 26, 2012 12:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, 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
Post #1364452
Posted Wednesday, September 26, 2012 9:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 7,089, Visits: 14,710
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?
Post #1364786
Posted Wednesday, September 26, 2012 10:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 5,970, Visits: 12,866
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"
Post #1364814
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse