2.3.4. MySQL Notifier for Microsoft Windows

The MySQL Notifier for Microsoft Windows is a tool that allows you to monitor and adjust the status of your local MySQL Server instances through an indicator that resides in the system tray. The MySQL Notifier for Microsoft Windows also gives quick access to several MySQL GUI tools (such as MySQL Workbench) through its context menu.

The MySQL Notifier for Microsoft Windows is installed by MySQL Installer, and (by default) will start-up when Microsoft Windows is started.

Note

To install, download and execute the MySQL Installer, be sure the MySQL Notifier for Microsoft Windows product is selected, then proceed with the installation. See the MySQL Installer manual for additional details.

For release notes detailing the changes in each release of MySQL Notifier for Microsoft Windows, see MySQL Notifier Release Notes.

Visit the MySQL Notifier forum for additional MySQL Notifier for Microsoft Windows help and support.

Features include:

Start, Stop, and Restart instances of the MySQL Server.
Automatically detects (and adds) new MySQL Server services. These are listed under Manage Services, and may also be configured.
The Tray icon changes, depending on the status. It's green if all monitored MySQL Server instances are running, or red if at least one service is stopped.
Links to other applications like MySQL Workbench, Windows Installer, and the MySQL Utilities. For example, choosing Configure Instance will load the MySQL Workbench Server Administration window for that particular instance.
If MySQL Workbench is also installed, then the Configure Instance and SQL Editor options are available.

The MySQL Notifier for Microsoft Windows resides in the system tray and provides visual status information for your MySQL Server instances. A green icon is displayed at the top left corner of the tray icon if the current MySQL Server is running, or a red icon if the service is stopped.

The MySQL Notifier for Microsoft Windows automatically adds discovered MySQL Services on the local machine, and each service is saved and configurable. By default, the Automatically add new services that match this pattern option is enabled and set to .*mysqld.*. Related Notifications Options include being notified when new services are either discovered or experience status changes, and are also enabled by default. And uninstalling a service will also remove the service from the MySQL Notifier for Microsoft Windows.

Clicking the system tray icon will reveal several options, as seen in the screenshots below:

The Service Instance menu is the main MySQL Notifier for Microsoft Windows window, and allows you to Stop, Start, and Restart the MySQL Server.

Figure 2.22. MySQL Notifier for Microsoft Windows Service Instance menu

The Actions menu actions include several links to external applications (if they are installed).

Note

The main menu will not show the Actions menu when there are no services being monitored by MySQL Notifier for Microsoft Windows.

Figure 2.23. MySQL Notifier for Microsoft Windows Actions menu

The Actions, Options menu configures MySQL Notifier for Microsoft Windows and includes options to:

Use colorful status icons: Enables a colorful style of icons for the tray of the MySQL Notifier for Microsoft Windows.
Run at Windows Startup: Allows the application to be loaded when Microsoft Windows starts.
Automatically Check For Updates Every # Weeks: Checks for a new version of MySQL Notifier for Microsoft Windows, and runs this check every # weeks.
Automatically add new services that match this pattern: A custom regular expression that filters the monitored services, and also filters the list of the Microsoft Windows services for the Add New Service dialog.
Notify me when a service is automatically added: Will display a notification from the taskbar when a newly discovered service is added to the monitored services list.
Notify me when a service changes status: Will display a notification from the taskbar when a monitored service changes its status.

Figure 2.24. MySQL Notifier for Microsoft Windows Options menu

The Actions, Manage Services menu allows you to configure the monitored services.

Figure 2.25. MySQL Notifier for Microsoft Windows Service Instance menu

MySQL Notifier for Microsoft Windows Manage Services menu

Adding a service (after clicking Add in the Manage Services window) allows you to select a running Microsoft Windows service, and configure MySQL Notifier for Microsoft Windows to monitor it. Add a new service by clicking service name from the list, then OK to accept. Multiple services may be selected.

Figure 2.26. MySQL Notifier for Microsoft Windows Adding a new services

MySQL Notifier for Microsoft Windows Adding new services