Cluster Availability
According to the manual, for a 2 storage-node cluster, I would setup 1 mgm and 1 SQL node. Also, it says that an application would access the cluster through the SQL node. Now what happens if the SQL node fails? The whole cluster would fail from the application's point of view, as it would be unreacheable. As I see having only one SQL node, would make it the *single point of failure*.
What would be the solution? Adding more SQL nodes? And if this is the case, if one of the SQL node fails, would I need to code/solve the problem myself (i.e. redirecting all the connections the other SQL node) Or does the cluster have a *built-in* solution for this?
Thanks.
Subject
Views
Written By
Posted
Cluster Availability
2430
July 21, 2005 04:29AM
1622
July 21, 2005 05:03AM
1730
July 22, 2005 08:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.