Question:
I'd like to get help to implement ODBC LoadBalancing for User Store. Could you guide me through the changes on system_odbc.ini?
Answer:
In the system_odbc.ini datadirect file, "LoadBalancing" is actually doing failover. To get it work, you need the following attributes configured :
HostName
PortNumber
AlternateServers
LoadBalancing
The difference between 0 and 1 for LoadBalancing is the way the driver will pick up the next server from the AlternateServers list : 0 = sequential, 1 = random
Here's a configuration sample :
[SiteMinder Oracle Data Source]
Driver=/opt/CA/siteminder/odbc/lib/NSora23.so
Description=DataDirect 5.3 Oracle Wire Protocol
HostName=data1.training.com
PortNumber=1521
ServiceName=myservice1
AlternateServers=(Hostname=data2.training.com:PortNumber=1521:ServiceName=myservice1,Hostname=data3.training.com:PortNumber=1521:ServiceName=myservice1)
LoadBalancing=1
KB : TEC1478737