Failover options while creating a datasource in VApp

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

How we can failover node while creating datasource in VApp as we have below information from DB team .

Also can we add the load balance url when we create.

TEST=(DESCRIPTION=(CONNECT_TIMEOUT=120)(RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1521)))(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=TEST)))

 

Environment

Release : 14.x

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Resolution

1. DB_URL entry would accept multiple hosts as an entry. The right syntax is slightly different than the one shared by your DBA (an example can be found here http://www.mastertheboss.com/jbossas/jboss-datasource/how-do-you-connect-a-datasource-to-a-cluster/ )

<connection-url>jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)       
(address=(protocol=tcp)(host=host1)(port=1521))(address=(protocol=tcp)(host=host2)(port=1521)))(connect_data=(service_name=xxxxsid)(failover_mode=(type=select)(method=basic)))) 
</connection-url>

2. Multiple hosts functionality was never tested by QA during certification. Therefore we would advise thorough testing to be made on a lower environment before applying such configuration in Production

3. From our experience, most sites will use a proxy host in the DB_URL, letting the backend application (database) to handle the load balancing, as it is bound to have a better control than an external application server.