SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Active /Active configuration


Active /Active configuration

Author
Message
saidapurs
saidapurs
Right there with Babe
Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)

Group: General Forum Members
Points: 727 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
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52681 Visits: 17672
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
Right there with Babe
Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)

Group: General Forum Members
Points: 727 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)
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28811 Visits: 19002
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
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52681 Visits: 17672
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