Reconnect while loosing Mysql connection

[Pavel Skvazh]

Hi, everyone!

Due to an obviously lacking skills of an admin, the connection with Mysql sever is really spotty.

And I keep getting OperationalError 'Can't connect to MySQL server' error every once in a while.

What's the best practice approach to handle this kind of errors.

Logical way would be to try to reconnect N times every N seconds and if it fails - throw this error.

Doing it manually doesn't seem appropriate and natural. Code won't be pretty either.

Connection pool looks like the way to go. i.e. try to get another connection if this one dies for some reason. It doesn't look like it's the way it is.

Any help would be highly appreciated.

[Pavel Skvazh]

Too obvious or too complicated?

[Michael Bayer]

turn off pooling is the quickest, use NullPool.

otherwise set pool_recycle very low, or add a "ping" event.

Docs for all of this at:

http://docs.sqlalchemy.org/en/rel_0_7/core/pooling.html

--
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/QKPokWMzPbkJ.
To post to this group, send email to sqlal...@googlegroups.com.
To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.