How to Monitor the MariaDB Windows Service with Service Protector

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:

   

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

   

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:

   

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:

   

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

   

   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?

• Consult the Service Protector FAQ for answers to commonly asked questions and troubleshooting tips.

• Contact us and we will be happy to help!