• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

SQL Server clustering : Resource Sharing

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
crazywolf2010
Asked:
crazywolf2010
1 Solution
 
ChrisCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now