Please find attached the plugin script to monitor MySQL Replication status.
Prerequisite: Ensure pymysql module is installed in the default python. Else, you can install it using the command
python3 -m pip install foo (considering python3 as your default python)
- Download and unzip the file mysql-replication.zip.
- Edit the MySQL configurations in the plugin file. Execute the file to check if it returns the replication details in JSON format.
- Once the file is executed successfully, copy the mysql-replication folder to the below Linux server monitoring agent directory: /opt/site24x7/monagent/plugins
This will add a plugin monitor in the Site24x7 web client. Wait for a couple of minutes and go to Server > Server Monitor > Servers > click on the server monitor > Plugins tab.
The following metrics will be displayed for this plugin:
Hope this helps. Please let us know for queries, if any, in the below thread.