Solved

SQL Server clustering : Resource Sharing

Posted on 2012-04-02
1
188 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

911 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

19 Experts available now in Live!

Get 1:1 Help Now