Solved

SQL Server clustering : Resource Sharing

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 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