We have 11 instances installed on that cluster. Yes active active clustering is supported in SQL Server It requires no code changes. The application does not need to be cluster aware.
I don't have the book that you got this information from, so please type into this thread exactly what it says. Perhaps you are mis-reading it. I don't understand what your boss has a problem with.
Our cluster groups failover in about 30 seconds. What exercise is he talking about? Applications that connect to the database would not have to be rewritten, unless they would need some sort of re-connection logic for when there is a failover.
Is active-active cluster really supported by microsoft? I have already added article for Active — Passive clustering. In active-active clustering you have to install sql server on both the instance.
Say Node 1 is the primary for the FO cluster. Good Question. Do the failover for node2. Make sure Node2 has ownership of the required Disks and resources. However, I have found a mountain of contradictory evidence to this. My understanding is that this was supposed to be included in SQL R2 but is not. Have you been able to get that working or is your statement in error? I was not able to install it asked for SQL manager service account and it was disabled so could not eneter it and just have to quit installing but was able to install using CLI.
Thanks for Publishing the such a good document,I have couple of question on the same. From which node I have to start installation active node or Passive Node. This article didnt mention about the type of filesystem that mssql need to have.
Has anyone tried this yet? Please write smoething on how to configure the windows cluster administrator which involves more on quorum disk and other disk layouts too. But Active-Active cluster installation you have to follow the mentioned steps on both the nodes.
Once that is done, you have to add nodes using installation menu. Like RAC. Can i keep data directory in sharable mode on SAN where two physical server access same data directoy. Do you have an article that would help me with this? Let me know your queries, I will post answers.
I just finished building 3 node cluster on Win 2k8 r2 AND sql 2k8 r2. I want to know how will one set it up so two of the the nodes are active at one point of time?
Is there any way we can configure it? I have two services one for msdtc and another for SQL, running on all three nodes but only active on one node at a time. Your help will be highly appreciated. Hi J-Shaw its really good to know the installation of sql clustering and please keep on posting the other configutrations and issues.
Do you want to add one more drive or you want to increase the storage? On failover, do you want both instances to go? By failover, it does not mean failure but any event that needs the virtual instance to be running on another node.
What about the resources owned by an instance? Assuming that one fails over, do you want it to take the disks of the other instance with it too? Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 12 years, 4 months ago.
Active 12 years, 4 months ago. Viewed times. Improve this question. Jason Kleban Jason Kleban 3 3 gold badges 8 8 silver badges 19 19 bronze badges. Add a comment. Active Oldest Votes.
0コメント