Go to All Forums

Mysql Replication Alerts

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.

Like (3) Edit Delete Reply
Replies (5)

Re: Mysql Replication Alerts

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

 

Like (0) Reply

Re: Re: Mysql Replication Alerts

Any ETA On replication status alerting for mysql?

Like (0) Reply

Re: Re: Re: Mysql Replication Alerts

Hi,

We are working to include the MySQL replication status. We cannot provide an exact timeline on when this will be available. We will update this thread once it is done. 

 

- Sriram

Like (0) Reply

Re: Re: Re: Re: Mysql Replication Alerts

Hello,

Is this still valid? We are currently testing this plugin and we desperately need this feature.

Like (0) Reply

Re: Re: Re: Re: Re: Mysql Replication Alerts

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:

  1. Download and unzip the file mysql-replication.zip.
  2. Edit the MySQL configurations in the plugin file. Execute the file to check if it returns the replication details in JSON format.
  3. 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!

Attachments
mysql-replication.zip
Size: 2.72 KB
Like (0) Reply

Was this post helpful?