About MySQL Server Plugin

MySQL Server Plugin provides protection and proactively monitors the MySQL Server environment’s, configuration data, services, and application data files.

What's new

• EN-4400: File Filter discovery mechanism improvements for long file name in 8.3 format

Supported Versions and Platforms

• MySQL Server supported versions and features:
  • 8.0, 5.7, 5.6, 5.5, 5.1 Community/Standard/Enterprise versions/editions deployed as standalone server on any of the following operating systems (where compatible):
    • Windows Server 2008 R2
    • Windows Server 2012
    • Windows Server 2012 R2
    • Windows Server 2016 
  • Document Store feature for MySQL 5.7 and 8.0

Monitoring

For MySQL Server Plugin, monitoring consists of the following:

• Service Availability Monitoring
• Application Monitoring 
• Database File Monitoring and Replication

Service Availability Monitoring

Neverfail Engine monitors services specified by the plug-ins to ensure application availability. In the event that a specified service stops or fails, Neverfail Engine can take up to three pre-configured actions to remedy the issue.

When the plug-in is installed, all protected services will be set to manual unless otherwise stated.

This is the list of all services protected by this plug-in:

• MySQL<version> (default)

Application Monitoring

Tasks - The following 'Tasks' are installed by MySQL Server Plugin:

• Periodic
  • Protected Services Discovery
  • File Filter Discovery
  • Registry Filter Discovery

To configure/modify Periodic 'Tasks', follow the steps below:

1. Using the Neverfail Advanced Management Client, click on Application -> Tasks .
2. Select the desired 'Task'.
3. Click on the Edit button at the top of the 'Tasks' pane.
4. Configure/modify the 'Interval' field.

Note: 'Interval' is the only field available for configuration/modification and is measured in seconds.

5. Click OK to save the changes.

Note: This dialog is also used to Enable/Disable the selected 'Task'.

Database File Monitoring and Replication

When the MySQL Server Plugin is installed, it will determine all current instances of MySQL Server and their locations for database files. It will also determine the configuration, application and user data associated with MySQL application. These files will be protected, i.e. their contents will be synchronized, and subsequent updates replicated to the passive server.

Install/Uninstall the MySQL Server Plugin Via the Neverfail Advanced Management Client

The MySQL Server Plugin can be installed either via the Neverfail CE deployment process or by using Application -> Plugins in the Neverfail Advanced Management Client using the procedure below. Neverfail recommends that for initial deployments of MySQL Server Plugin, installation should be performed using Engine Management Service.

To manually install the MySQL Server Plugin, follow the steps below:

1. Unzip the MySQL Server Plugin to the desired location.
2. Launch the Neverfail Advanced Management Client.
3. Navigate to Application -> Plugins .
4. Click on the Install 
5. Click the Browse button and navigate to the location of the <plug-in name>.dll 
6. Click OK to complete the installation.
7. Repeat this process for each individual plug-in.

To remove/uninstall the MySQL Server Plugin, follow the steps below:

1. Launch the Neverfail Advanced Management Client.
2. Navigate to Application -> Plugins .
3. Select the desired plug-in to be removed/uninstalled.
4. Click on the Uninstall button in the 'Plugins' pane.
5. When the plug-in is uninstalled, the files are not removed. This is by design for future functionality and therefore the following workaround is provided:
   • Copy the contents of the r2\plugins\<sponsor>\<version> folder to a different location (e.g. C:\temp).
   • Delete the contents of the r2\plugins\<sponsor>\<version> 
   • To reinstall the plug-in, when prompted for the location of the plug-in files, navigate to the new folder location (e.g. C:\temp).

Note: As an alternative, reinstallation can be accomplished by using the downloaded files from the original download location after removing the plug-in.

Applies To

MySQL Server Plugin v201.5.4