Can we configure two jdbc connection urls for a single connection to internal databases?

[Legacy User]

Hi,

 

Is it possible to configure two gateway servers in a single connection on Manage JDBC connections(like a fault tolerant server)? Currently we use a single connection and it might cause problem with oauth replication(in internal mysql db) when replication breaks but the gateway node is still processing requests.

 

jdbc:mysql://gateway1:3306/otk_db

jdbc:mysql://gateway2:3306/otk_db

 

Thanks,

Anand

[Joe Dascole]

Hi Anand,

 

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.

 

Regards,

Joe

[Legacy User]

Hi Joe,

Thanks for the reply. I was trying to test this and was getting permission denied for the user. I also tried providing grants on the otk db, but I might be missing something. Here is what I tried.

 

GRANT ALL ON otk_db.* TO 'otk_user'@'host';

 

Regards,

Anand

[Legacy User]

We were able to get this solution working.

Thanks,

Anand

[Chaitanya Naidu Nadhandla]

Does this "GRANT ALL ON otk_db.* TO 'otk_user'@'host';" did the magic or you have done something different.  How did you managed to resolve the issue.  I am exactly in your situation and trying resolve the problem.  Any help would be appreciated

[Legacy User]

I do not remember exactly, but i think this is what i did. Or you could use two separate grants for  otk_user with the specific gateway host names that you are connecting from.

 

GRANT ALL PRIVILEGES ON `otk_db`.* TO 'otk_user'@'%'