Help Needed for RAC with TAF

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

Help Needed for RAC with TAF

Postby mail.madhankumar » Sat Oct 27, 2012 9:35 pm

Hi Tim,
when we use taf service to connect the rac database . it is connecting to preferred node based on TAF.. so server load will be in main node only , then why are they saying Load balancing feature..

ex:
we have 2 node rac. 1st node is rac1 and second node is rac2 . here rac1 is preferred node and rac2 is availability on taf.
i connect to rac2 node and connect to schema using taf service . but that connects to rac1 instance.. where will be the server load?. rac1 server or rac2 server?. or will it connect to rac2 instance after some connections established.? using load balancing..? please explain me...

Regards,
Madhan
mail.madhankumar
Senior Member
 
Posts: 87
Joined: Tue May 15, 2012 2:47 pm

Re: Help Needed for RAC with TAF

Postby Tim... » Sat Oct 27, 2012 9:50 pm

Hi.

If doesn't make sense to define a preferred node, then try to use load balancing. They are trying to achieve totally different things. You need to either:

- Have a service with a preferred node and not attempt to load balance. This way the connections will be made to the preferred server, but will go to the other server if the preferred server is down.

or

- Not have a preferred server and have a load balanced connection. This way, load will be spread evenly across both nodes.

The two goals are mutually exclusive.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Help Needed for RAC with TAF

Postby mail.madhankumar » Sun Oct 28, 2012 12:02 am

Hi,
if we have preferred server...and also mentioned load balance true what will happen..

your point
- Not have a preferred server and have a load balanced connection. This way, load will be spread evenly across both nodes.

load shared on both node using load balancing.. one node got failure means.. wat will happen.. will they loss the connection or failover to another node..

if both feature works together means it's gud.. rite..

Regards,
Madhan
mail.madhankumar
Senior Member
 
Posts: 87
Joined: Tue May 15, 2012 2:47 pm

Re: Help Needed for RAC with TAF

Postby Tim... » Sun Oct 28, 2012 7:18 am

Hi.

I'm not really sure what would happen if you combine a preferred node and load balancing. I've never done it because it's stupid. So I've never tested the consequence of that configuration. If you want to know, then test it.

If you have load balancing and no preferred server your load is spread between nodes. If a node goes down, then only the working node is used. It would be pretty stupid of Oracle to design a HA solution that wasn't HA right?

These are things that are easy for you to test.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: No registered users and 2 guests

cron