Layer 7 API Gateway: Failover Configuration for the OAuth Toolkit (OTK) Database

Products

• CA API Gateway

Issue/Introduction

How can a single connection be configured to support two OAuth Toolkit (OTK) databases in the 'Manage JDBC connections' settings? 

Environment

All supported versions of the API Gateway

Resolution

You can specify failover in the JDBC connection properties. For example;

jdbc:mysql://db_server1:3306,db_server2:3306/otk_db?failOverReadOnly=false&autoReconnect=true&connectTimeout=1

Where "db_server1" & "db_server2" are the hostnames or IPs of your OTK Database servers and "otk_db" is the name of your database.

 

 

You will also need to make sure that the necessary MySQL grants are in place to allow all Gateway nodes to access the OTK DB.

1) Login to mysql

2) Execute the following query:

GRANT SELECT,UPDATE,DELETE,INSERT ON otk_db.* TO 'otk_user'@'host';