Bug #53016 Proxy --keepalive does not work on Windows
Submitted: 21 Apr 2010 0:04 Modified: 6 May 2010 9:00
Reporter: Chris Calender Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy: Documentation Severity:S3 (Non-critical)
Version: OS:Microsoft Windows
Assigned to: MC Brown CPU Architecture:Any
Tags: keepalive, proxy
Triage: Triaged: D5 (Feature request) / R1 (None/Negligible) / E1 (None/Negligible)

[21 Apr 2010 0:04] Chris Calender
Description:
The proxy --keepalive option does not appear to work on windows.

This is probably expected, in which case it needs to be documented.

Or if this is not expected, then this needs to be fixed, as it does not work (no second process with the same name is started, nor is proxy restarted after 5 minutes).

--keepalive

"Creates a process surrounding the main mysql-proxy which will attempt to restart the true mysql-proxy process in thr event a crash or other failure."

http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-configuration.html#option_mysql-proxy_k...

How to repeat:
Start proxy with --keepalive option:

C:\>mysql-proxy.exe --admin-lua-script=admin.lua --admin-password=secret --admin-username=root --proxy-backend-addresses=127
.0.0.1:3306 --proxy-lua-script=reporter.lua --keepalive

Notice only one process is created, the proxy.

And if you kill the proxy (ctrl-c), then it is never restarted.

Suggested fix:
Either document this, or fix the functionality if it should work on windows.
[3 May 2010 15:08] Diego Medina
See http://bugs.mysql.com/bug.php?id=53381
[5 May 2010 9:36] Enterprise Tools JIRA Robot
Mark Leith writes: 
Please document that this option is not available on windows, and direct people to the service options for restarting the agent service automatically (which it does by default)
[6 May 2010 9:00] MC Brown
Documented; the Windows service information is currently incomplete, I've made a note to address this separately.