Solved

SQL Server clustering : Resource Sharing

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

815 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

11 Experts available now in Live!

Get 1:1 Help Now