Alter Active/passive two nodes to Active/Active cluster

Question

Post reply

Alter Active/passive two nodes to Active/Active cluster

lsalih

SSCertifiable

Points: 6143
More actions
December 10, 2014 at 8:43 am

#295823

Hi -
I have 2 nodes (node 1 and node 2) in active/passive mode. Node 1, which is the active node, runs 2 instances (PROD and DEV).
We have a need to make both nodes active/active cluster from the current Active/passive cluster setting, and migrate DEV instance to node 2. That way we will have node 1 running PROD instance and node 2 running DEV instance.
Can you please briefly list me the steps I need to take to ensure minimum down time and have a successful setup.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

just move the DEV group to node 2

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

"Ya can't make an omelette without breaking just a few eggs" 😉

lsalih SSCertifiable Points: 6143 More actions · Answer 2

As I stated, node 2 is passive. I understand you can just right click on the instance and tell it to move to second node.

The goal is to make these two nodes active/active.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

lsalih (12/10/2014)
As I stated, node 2 is passive. I understand you can just right click on the instance and tell it to move to second node.
The goal is to make these two nodes active/active.

By moving the instance to node 2 that then represents what was previously known as an active\active configuration.

Nowadays in Windows Server Failover Clustering they're simply known as multi instance clusters.

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

"Ya can't make an omelette without breaking just a few eggs" 😉

lsalih SSCertifiable Points: 6143 More actions · Answer 4

Perry -

Thanks for the clarification, I will then propose moving the instance.

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

Active-active never meant that both nodes were serving the same databases. That's never been how SQL clustering works. Active-active, before it went out of favour, used to mean two nodes each running their own instance of SQL, serving different databases.

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

lsalih SSCertifiable Points: 6143 More actions · Answer 6

Gail, I initially was confused but now I am clear. I already suggested moving the instance to other node. Thank you very much for clarification.