Textpattern CMS

#1 2009-12-29 16:46:19

franktranhunt

New Member

Registered: 2009-12-29

Posts: 1

is there plugin that checks and resolves database connections

I was wondering if you know of any DB plugins that might resolve an issue we’re having with the MySQL database connection. What we’re seeing is that when the application looses connection to the backend it doesn’t resolve the connection and we’re having to manually bounce the DB to re-establish.

1. Do you know of anything that would help textpattern either periodically check for a connection issues and re-establish or
2. How do we manually reconnect through textpattern instead of bouncing the DB?

I prefer option #1 if possible.

#2 2009-12-29 18:45:23

rsilletti

Moderator

From: Spokane WA

Registered: 2004-04-28

Posts: 707

Re: is there plugin that checks and resolves database connections

Database connects are accomplished by “class DB” in txplib_db,php. This class is instantiated at each execution of TXP as a script, barring AJAX operations. Reloading the script should resolve any connection issues with MySql, and this should happen at each significant event that would involve the database. I’m a little unsure as to where that leaves opportunity for any sustained connection loss?