Solved

SQL Server clustering : Resource Sharing

Posted on 2012-04-02
1
187 Views
Last Modified: 2012-04-10
Hi,
1. What is shared nothing architecture under SQL server clustering?
2. Is each database at node replicated on other node fro failover?
3. If I have 4  nodes in a cluster, can I distribute the load for those databases across all nodes of the cluster? Under ORACLE RAC it works brilliantly. I read in docs I can't?
4. If that is the case then how does having more than 2 nodes in a cluster helps?


Thanks
0
Comment
Question by:crazywolf2010
1 Comment
 
LVL 18

Accepted Solution

by:
irweazelwallis earned 500 total points
ID: 37795898
you can't do this out of the box with SQL - at least automatically

If you set up a cluster the DB's sit on shared storage and that storage is failed over to a specific node
If you have mutiple nodes and multiple instances in the cluster then you can distribute the load among them by moving specific instances to each node i.e DB1 on instance 1 on SQL1 and DB2 on instance 2 on SQL2 -

be aware that this changes the licencing you need as it is no longer active-passive/failover clustering so you will need to licence each server.

By having a 2 or more node SQL cluster means you have automated resilience so that if one node has a hardware failure then databases and instances will fail over to the other node, you could have this multisite to give you geographical resilience as well
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now