MySQL resolve:FailoverDataConnector failover slow

[Ho, PeiQuan]

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

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.

Thanks,
-PQ


-----Original Message-----
From: users-bounces at shibboleth.net [mailto:users-bounces at shibboleth.net] On Behalf Of Cantor, Scott
Sent: Tuesday, April 14, 2015 11:40 AM
To: Shib Users
Subject: Re: MySQL resolve:FailoverDataConnector failover slow

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

>During testing however, we noticed that when the master is done, the transaction is really slow.. way slower than the expected timeout values… and even after the authentication has succeeded, the IDP takes a long time before passing the session back to the SP… like minutes!  We’re also using mysql connector string of the type below, but it still doesn’t seem like timeout values are honored.

That's up to the driver, not the IdP. We can't make their settings work. If it takes minutes, it's because the initial attempt is taking that long to fail.

-- Scott

-- 
To unsubscribe from this list send an email to users-unsubscribe at shibboleth.net