Support, We were interest to buy this product. But we notice your application is not generating alerts against the DB replication processes. Please add mysql features in your tool.
Hi,
Thanks for bringing this up, we have a plugin to monitor the MySQL application.
But we notice your application is not generating alerts against the DB replication processes.
We are analyzing the case to include monitoring of the DB replication processes in the existing MySQL plugin itself. Will update in this thread once we are done.
Regards,
Muralikrishnan
Hi Andril,
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)
Plugin Installation:
- 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.
Performance Metrics:
The following metrics will be displayed for this plugin:
- Seconds_Behind_Master
- Slave_IO_State
- Last_Errno
- Last_IO_Errno
- Last_SQL_Errno
- Relay_Log_Space
- Skip_Counter
- Slave_IO_Running
- Slave_SQL_Running
- Slave_heartbeat_period
- Slave_open_temp_tables
- Slave_received_heartbeats
- Slave_retried_transactions
- Slave_running
Hope this helps. Please let us know for queries, if any, in the below thread.
Happy Monitoring!