MySQL Forums
Forum List  »  Router & Proxy

Checking backend state
Posted by: Johann Reisner
Date: February 10, 2010 03:28PM

Hi,

is it possible to check the state of a backend more than one time per connection with proxy 0.8?

I've got a php script and some java applications which runs about 2 minutes with 1 opened connection. This script/application does a lot if inserts / updates. I want to check the state in read_query() or read_query_result, if one backend fails during the script/app is running, I want to switch the backend and log the queries that have failed to send to this backend. But I've noticed, that MySQL-Proxy don't notice if a backend fails during the same connection (or I am to stupid to get this working).

Is this correct that proxy only one time per connection (connect_server?) notices if backends are up or down, and is there a workaround or something to check it more than one time?

Thanks for all replies!

Hans

Options: ReplyQuote


Subject
Views
Written By
Posted
Checking backend state
3545
February 10, 2010 03:28PM


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.