Routing all connections through a one node in a 2 node RAC cluster
Hi everyone
My client has the following requirement: an active/active RAC cluster (eg node1/node2), but with only one of the nodes being used (node1) and the other sitting there just in case.
For things like services, i'm sure this is straightforward enough - just have them set to preferred on node1 and available on node 2.
For connections, I imagine I would just have the vips in order in the tns file, but with LOAD_BALANCING=OFF, so they go through the tns entries in order (i.e node 1, then node 2), so this would still allow the vip to failover if node 1 is down.
Does that sound about right? Have I missed anything?
Many thanks
Rup