[Zope] MySQL reconnects on zope application level

[Peter Bengtsson]

I don't have an easy answer but if you do dig into Andy's code and try
to implement this, I would suggest you look at the ZPsycopgDA code
perhaps and look for inspiration since I think that one works much
better.


2008/7/16 Jonas <jonas at freesources.org>:
> Hello,
>
> On several zope 2.10.6 instances we discovered issues with database
> connections to MySQL. Apparently MySQL seems to not automaticly
> reconnect connections with a timeout since version 5.0.3 due to issues
> with transactions.
>
> Until now, mysql-python was patched to restore that behaviour to
> automatically reconnect timeouted connections, but that is not the case
> anymore either.
>
> So from now on the database reconnects need to be done from zope
> applications on their own. Unfortunately the ZMySQLda adapter by Andy
> Dustman doesn't implement such a functionality.
>
> I cannot imagine that we are the only ones who discover this problem. Is
> there an easy way to implement automatic reconnects for Z MySQL Database
> Connections on zope application level?
>
> greetings, and thanks in advance,
>  jonas
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>



-- 
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com