How to Integrate the MySQL Plugin

Introduction

This document provides a step-by-step guide to integrating the MySQL Plugin into an existing host for monitoring MySQL database performance. The process includes reviewing prerequisites, configuring the plugin, installation, dashboard setup, and uninstallation.

Steps to Integrate MySQL Plugin

Step 1: Navigate to Metrics Integration

1. Log in to the application.

2. Navigate to the Integration section by clicking Metrics in the left-side panel.

   

Step 2: Expand the Database Systems Section

1. Locate and expand the Database Systems section.

2. Click on MySQL Plugin to begin the integration process.

   

Step 3: Follow Plugin Prerequisites

1. Click to expand the Plugin Prerequisites section.

2. Review and complete the prerequisites listed in this section.

Step 4: Plugin Configuration

1. Download the installation script using the command provided in the Plugin Configuration section.

2. Assign execution permissions to the script by running the specified command.

   

Step 5: Plugin Installation

1. Select the target host from the available list.

   1. If the host is not listed, you must first Add the Linux Agent.

   
2. Execute the Installation Script:

   1. Once the host is selected, a customized installation script will be generated. Execute this script on the remote server/host to complete the MySQL plugin installation.

   

Step 6: Install the Dashboard

1. Click the Install Dashboard button to set up a detailed metrics dashboard for monitoring MySQL database performance, including resource utilization, query performance, and error tracking.

   

Step 7: Verify Installation

1. Navigate to the Metrics Dashboard page.

2. Confirm that the MySQL Dashboard is displayed, indicating successful integration and setup.