SQL SERVER 208 FAILOVER CLUSTERING

Question

Post reply

SQL SERVER 208 FAILOVER CLUSTERING

AK1516

SSCrazy

Points: 2705
More actions
September 14, 2010 at 7:14 am

#240277

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??

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Abhijit More SSCertifiable Points: 6897 More actions · Answer 1

I think you can't do it on one sever instance.

Abhijit - http://abhijitmore.wordpress.com

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

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 SSCrazy Points: 2705 More actions · Answer 3

Gil,

Thnaks for the reply.

Do you know any url /blog for documentation of the Active - Active failover cluster.

Derrick Smith SSChampion Points: 10833 More actions · Answer 4

The setup is really no different than active/passive.

Just install two instances, and then move one over to the other node.

george sibbald SSC Guru Points: 104210 More actions · Answer 5

Ahem. The term active\active is soooooooo last year. What you have there is a multi instance cluster.

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

Derrick Smith SSChampion Points: 10833 More actions · Answer 6

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 $#@*)?

🙂

AK1516 SSCrazy Points: 2705 More actions · Answer 7

smith ,

How would you impliment this in active passive

Derrick Smith SSChampion Points: 10833 More actions · Answer 8

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).

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

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

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 10

Here is good link...this will walk you through the whole thing...4 parts

http://www.mssqltips.com/tip.asp?tip=1687

Rao.V Hall of Fame Points: 3452 More actions · Answer 11

Rao.V

Hall of Fame

Points: 3452

September 14, 2011 at 4:14 am

#1381148

the final link is gud

llweiss SSC Rookie Points: 28 More actions · Answer 12

Just a word of caution.

If you intent for RS to run on the cluster, you can only do this with SQL 2008 Enterprise and above, not Standard.

Once you install SQL on a cluster you can not make any changes, like adding reporting services as I found out the hard way.

If you just want RS running on one of the nodes in the cluster it can be done but has to be in a separate instance. Of course you lose failover capability then as well.

george sibbald SSC Guru Points: 104210 More actions · Answer 13

Install RS as a named instance on both nodes, configuring the first install to use databases supported on the cluster. then configure RS as a scaled out install and set up a cname that points to the SQL virtual server name.

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

AK1516 SSCrazy Points: 2705 More actions · Answer 14

how would the same database file be shared on diff clusters ?