Layer7 API Management

  • 1.  Failover configuration for OTK DB ( Oracle)

    Posted Oct 23, 2017 04:41 PM

    Hi, 

     

    In our Mobile SSO implementation , we are using Exteranal DB ( Oracle) for OTK. 

    We have two Data centers, and we would like to cofigure One Data Center as  primay and other as Failover. 

    But looks  gateway assertion is looking  for a DB connection with a specific name (otk_db), and gateway will associate only one DB instance with the otk_db name.

    Is there a way to configure  specific DB to be as fail over for Primary DB in Gateway. ? 

     

    Thank u



  • 2.  Re: Failover configuration for OTK DB ( Oracle)
    Best Answer

    Broadcom Employee
    Posted Oct 23, 2017 11:38 PM

    I saw some examples to use jdbc connection string for failover, but they're for mysql jdbc connection.

    Oracle should be similar, but it may depend on the jdbc driver, an example I found from internet,

    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604)) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604))) (CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))


  • 3.  Re: Failover configuration for OTK DB ( Oracle)

    Posted Oct 25, 2017 03:02 PM

    have you tried something like this 

     

    jdbc:l7tech:oracle://server1:1521;ServiceName=TEST;AlternateServers=(server2:1521;ServiceName=TEST2,server3:1521;ServiceName=TEST3).