June 7, 2011 at 2:47 am
Hi All
Is it possible to run a cluster in Active/Active with the same instance across both nodes.
I would of thought no and the way to do it would be to install a second instance, copy the databases and set up mirroring / replication between the two?
Thanks
Ant
June 7, 2011 at 2:57 am
anthony.green (6/7/2011)
Hi AllIs it possible to run a cluster in Active/Active with the same instance across both nodes.
No, you can't
I would of thought no and the way to do it would be to install a second instance, copy the databases and set up mirroring / replication between the two?
Yes, you could do this.
M&M
June 7, 2011 at 3:38 am
Thanks that was my thought as well that it couldn't be done, just someone was saying they managed to do it before to which I thought was a bit strange.
June 8, 2011 at 12:26 am
no you can't because accordoing to the microsoft Active\Active means multple instances on multiple nodes
there is no load balancing for a instance like a RAC in oracle
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 8, 2011 at 9:11 am
You can run an active\active cluster - [with multiple instances]. Not a problem, I have several of them running here. But the same instance across multiple nodes? I don’t think so, I would ask that person to clarify. I suppose if you wanted to make your life difficult you could install the SQL DB engine and SSAS into different drives and then separate them into different applications/ groups with their own ip/ dns names. But I don’t know if that would work or even if it would get you anywhere. Maybe they were talking about a single node cluster..:hehe:
June 8, 2011 at 9:18 am
From the sounds of the discussion that was had, it sounded like they wanted the same OLTP DB to be running on both nodes to which I initialy said, hold on you cant run the same instance active/active.
June 8, 2011 at 9:49 am
yeah, running the same db on multiple nodes would be the RAC from oracle that Syed referred to. It has the load balancing built into the RAC, so it's served and distributed across multiple nodes. From my understanding, they're a fairly complex set up and you would have to have a pretty specific need to even get the CFO to sign off on getting one in the door.
cheers
June 13, 2011 at 3:35 am
I didnt say Active\Active is not possible but as requirement of @anthony-2 is distribute the load of 1 instance on multple nodes that is not possible in SQL Server Environment,Yes you can run multple instances on a node or multple nodes
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply