MySQL resolve:FailoverDataConnector failover slow

[Cantor, Scott]

On 4/14/15, 11:50 AM, "Ho, PeiQuan" <PeiQuan.Ho at tufts.edu> wrote:

>I'm using the standard com.mysql.jdbc.Driver from MySQL.  Do you know of a way I could possibly get around this issue?

Find a driver that isn't broken, or try and find out what's wrong I guess, maybe the settings aren't what they document, or maybe they don't work on the connection URL and have to be set as properties.

I run MySQL locally, I can try dropping it and seeing what it does. My guess is that it's connecting in some partial way that prevents the driver from timing out. That's very common with databases.

>Also, I get the issue that even after the initial attempt to the master has failed and the attribute-resolver is directed to the failover connector (the slave), after that attempt is successful and I've successfully logged in, the IDP still takes minutes before returning to the SP.

Then it's contacting something else that's taking minutes to respond. If you want to show me logs of the timestamp gaps and what it's doing, that's fine, but what you're describing isn't how it works.

It's possible that the failover is also broken, in which case every attribute is individually re-resolving both broken connectors.

-- Scott