MySQL Java Database Connectivity (JDBC) Failover Configuration for the OAuth Toolkit (OTK) Database

Document ID : KB000011611
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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

 

Answer:

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 IP's of your OTK Database servers and "otk_db" is the name of your database.

 

_jdbc_otk.png

 

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';