Connection failure to oauth DB on failover node

Document ID : KB000098410
Last Modified Date : 30/05/2018
Show Technical Document Details
Issue:
 At the time of Failover, all the active gateways can not connect to Failover Node.
Environment:
Oauth
Cause:
ssg log would show the below errors

WARNING 156 com.l7tech.server.jdbc.JdbcQueryingManagerImpl: Failed to perform querying since Connection is read-only. Queries leading to data modification are not allowed
Resolution:
You can specify failover in the JDBC connection. For example; 

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

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 in MySQL