Keep MariaDB Windows Service running 24/7 with Service Protector

How to Monitor the MariaDB Windows Service with Service Protector

Automatically restart MariaDB if it crashes, gets shut down accidentally or stops for any reason.

MariaDB is a popular open source relational database. It's installed as a Windows Service, to start automatically whenever your server reboots:

To monitor MariaDB with Service Protector:

  1. Download and install Service Protector.

  2. Start Service Protector.

  3. Select Protector > Add to open the Add Protector window:

    Add Protector

  4. On the General tab, in the Service to protect field, select the MariaDB Windows Service:

    MariaDB Windows Service: General Settings

  5. Do you find that the service takes a very long time to stop and has to be forcibly terminated? If so, switch to the Extras tab and enable the "stuck" actions.

    Be sure to give MariaDB enough time to complete its work though! 5 minutes (as pictured) should be enough:

    MariaDB Windows Service: Extra Settings

  6. We're done with the basic setup so click the Save button to record your settings. In a few seconds, an entry for MariaDB will show up in the Service Protector window.

    The shield icon in the Protected column will be green — indicating that MariaDB is already being monitored by Service Protector:

    MariaDB Windows Service: Protected

    You can click the green "Running" circle to see how the database service is doing:

    MariaDB Windows Service: Status

    Similarly, clicking the "Protected" shield icon will show the status of protection.

  7. And that's it! Next time your computer boots, MariaDB will start up automatically and Service Protector will start monitoring the database to restart it quickly it if it crashes for any reason.

    We encourage you to edit the MariaDB entry in Service Protector and check out the many other settings that may be helpful in your environment. For example, restart the service if it hogs the CPU, send an email notification if the service stops, and much more.



Trouble protecting the MariaDB Windows Service?