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


SQL SERVER 208 FAILOVER CLUSTERING


SQL SERVER 208 FAILOVER CLUSTERING

Author
Message
AK1516
AK1516
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 1018
The team came with an architecture of implementing active passive cluster.The node1 is going to have an
an instance of sql server 2008 with a single database in it.And the node2 is going to have a instance of sql server 2008 with a repoting database.Whose tables are replicated from database on node1.The failover occurs on from node1 to node2 and node2 to node1.

i got stuck with how could we have a instance of sql server running on active and passive at the same time?

Can any one help me with this??
Abhijit More
Abhijit More
SSC Eights!
SSC Eights! (985 reputation)SSC Eights! (985 reputation)SSC Eights! (985 reputation)SSC Eights! (985 reputation)SSC Eights! (985 reputation)SSC Eights! (985 reputation)SSC Eights! (985 reputation)SSC Eights! (985 reputation)

Group: General Forum Members
Points: 985 Visits: 767
I think you can't do it on one sever instance.

Abhijit - http://abhijitmore.wordpress.com
GilaMonster
GilaMonster
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59180 Visits: 44730
If both nodes are supposed to have SQL running on them, it's not an active-passive cluster. It's an active-active cluster.

Not hard to implement. Install one instance of SQL on the one node (with its disks and cluster group) and install another (different name) instance on the second node, with its own set of disks and cluster group.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


AK1516
AK1516
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 1018
Gil,

Thnaks for the reply.
Do you know any url /blog for documentation of the Active - Active failover cluster.
Derrick Smith
Derrick Smith
Right there with Babe
Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)

Group: General Forum Members
Points: 738 Visits: 715
The setup is really no different than active/passive.

Just install two instances, and then move one over to the other node.
george sibbald
george sibbald
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7422 Visits: 13687
Ahem. The term active\active is soooooooo last year. What you have there is a multi instance cluster.

---------------------------------------------------------------------
Derrick Smith
Derrick Smith
Right there with Babe
Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)

Group: General Forum Members
Points: 738 Visits: 715
george sibbald (9/14/2010)
Ahem. The term active\active is soooooooo last year. What you have there is a multi instance cluster.


But is it a multi-instance active/passive cluster? Or active/active? Or passive/passive (oh $#@*)?

Smile
AK1516
AK1516
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 1018
smith ,
How would you impliment this in active passive
Derrick Smith
Derrick Smith
Right there with Babe
Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)Right there with Babe (738 reputation)

Group: General Forum Members
Points: 738 Visits: 715
Clusters are not really complex things.

In a nutshell, there are Cluster Groups. You install SQL, and its resources get added to one of these groups that you specify. Then, through Cluster Administrator, you can set that group to run on either node (right click the group and click Move Group). That's essentially all there is to moving SQL instances between nodes.

The only difference between active/active and active/passive is that in active/passive, you have everything running on one node, while the other is just idle. In active/active, you have instances running on both nodes, but if one were to fail, it would be able to just move to the other node.

As far as installing SQL on a cluster..running through the setup is a bit different and there are a few extra requirements, but it's fairly simple once you go through it. There are a million pages out there with step by step screenshots (just google sql server 2008 cluster install).
GilaMonster
GilaMonster
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59180 Visits: 44730
george sibbald (9/14/2010)
Ahem. The term active\active is soooooooo last year.


I do apologist for not keeping up with fashion. ;-)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


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