A Windows Service is a specially designed application that can be started automatically at system boot. Windows Services can execute even when no user is logged on to the system. Windows services are usually implemented in C++, but can also be written in any .NET language (C#, VB.NET).

Since Windows 2000, Windows Services support corrective actions - actions to be taken in case of a failure (a Service is considered failed when it terminates without reporting a status of SERVICE_STOPPED to the Service Control Manager).

Whenever a service fails, the Service Control Manager detects it and logs an error in System Event Log:

The XXX service terminated unexpectedly. It has done this YYY time(s).

If the service has an associated corrective action, it logs the following message and executes the corrective action:

The following corrective action will be taken in ZZZ milliseconds: ACTION

Corrective actions can be:
- No action (SC_ACTION_NONE; the default)
- Restart the service (SC_ACTION_RESTART)
- Reboot the system (SC_ACTION_REBOOT)
- Run any command (SC_ACTION_RUN_COMMAND)

The MySQLAutoRestart is a small tool written in Visual C++ .NET which uses WIN32 function ChangeServiceConfig2 to configure the MySQL Service to automatically restart in case of failure. It can be called (or integrated) as part of a setup/installation procedure of MySQL on Windows.
Requirements:

· MySQL Server

Publisher: Emmanuel Kartmann

Tags: Restart Windows Service, Windows Service Failure,