MySQL Forums
Forum List  »  Router & Proxy

Persistent connection to non-persistent connection conversion
Posted by: Daan Try
Date: March 16, 2010 11:35AM

Hi,

We have a closed source data-logging application that is using a persistent connection to the MySQL database. Unfortunately we have no control over this application.

Now our MySQL database host has put in new rules that limit the connection idle time to 100s. Although this makes perfect sense from his point of view, it poses a problem on our dataloggers. Sometimes, especially at night time, two consecutive database INSERTs may be more than 100seconds apart. This combined with the very bad error handling from within this application makes that our loggers die every night.

The company who produced this software is out of business, so nothing we can do here.

Is there a way to configure MySQL Proxy to open a session for each query it receives? How should that be done?

Current Flow:
MySQL Login
INSERT data #1
INSERT data #2
INSERT data #3
...
more than 100s
...
INSERT data #n << Fail

Desired Flow:
MySQL Login
INSERT data #1
MySQL Logout
MySQL Login
INSERT data #2
MySQL Logout
MySQL Login
INSERT data #3
MySQL Logout
...
more than 100s
...
MySQL Login
INSERT data #n << Succes
MySQL Logout


Daan

Options: ReplyQuote


Subject
Views
Written By
Posted
Persistent connection to non-persistent connection conversion
4772
March 16, 2010 11:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.