MySQL Bugs: #53016: Proxy --keepalive does not work on Windows

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:	Windows
Assigned to:	MC Brown	CPU Architecture:	Any
Tags:	keepalive, proxy

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.

See http://bugs.mysql.com/bug.php?id=53381

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)

Documented; the Windows service information is currently incomplete, I've made a note to address this separately.