MySQL Forums
Forum List  »  Router & Proxy

MySQL-proxy Keepalive not working?
Posted by: Tan Yi Zhuang
Date: March 17, 2010 07:54AM

Hi all,

I'm new to the usage of mysql-proxy.

I have a set up of 1 proxy server, 2 cluster api and 2 data nodes. The proxy is working as planned - acting as the single access channel to the databases.

I understand that mysql-proxy have the property "keepalive" where once set as true, in situation where the proxy process dead, an "angle" process will restart the proxy process. (ref: http://fmpwizard.blogspot.com/2009/05/mysql-proxy-what-if-it-crashes.html)

I'm interested in testing out the setting (keepalive=true), but it seem that killing the task did not trigger the restart. How can i test the setting on a window machine?

Below is proxy-config.cnf on my XP machine:

[mysql-proxy]
keepalive = true
proxy-address = 192.168.1.121:4040

proxy-backend-addresses = 192.168.1.123:3306,192.168.1.124:3306

help = true
help-all = true
log-level = debug
log-file = log/proxy.log
proxy-lua-script = bin/scripts/capture-errors.lua
proxy-lua-script = bin/scripts/reporter.lua

Regards
yZ

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL-proxy Keepalive not working?
7532
March 17, 2010 07:54AM


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.