Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Maintenance Window

forums forums Monyog Monyog: Bugs / Feature Requests Maintenance Window

This topic contains 0 replies, has 0 voices, and was last updated by  Mahesh 6 years, 6 months ago.

  • Author
    Posts
  • #12797

    sam.miller
    Member

    Hi guys

    I'musing a MySQL backup tool nightly, to take a snapshot of all databases.

    Every time the backup runs, MonYog sends me a dozen or so long-running query alerts

    These long-running query alerts are essential during the day, but I need to define a 'maintenance window' during which MonYog does not send me alerts

    Is there a way to define this in MonYog Enterpris 5.2? Or does anyone have an alternate suggestion?

    I've considered using batch files and Scheduled Tasks to stop and restart the MonYog service, but this seems messy and prone to error, plus it will reset the 'warm-up' time every night

  • #33803

    Mahesh
    Member

    Ofcourse!! You can manage it using MONyog API, You need curl tool to be installed for it to make a HTTP call (http://curl.haxx.se/download.html)

    Below is an example of MONyog running on local machine wherein using MONyog API you can disable Long running queries and enable again for a server named “TestServer”

    This action will not log Long Running Queries in MONyog's embedded database and hence it will not send notification email alerts.

    To disable:



    D:Curl>curl.exe "http://127.0.0.1:5555/?_object=MONyogAPI&_action=LongRunningQu

    eries&_value=disable&_server=TestServer"



    To enable:

    D:Curl>curl.exe "http://127.0.0.1:5555/?_object=MONyogAPI&_action=LongRunningQu

    eries&_value=enable&_server=TestServer"

    You can schedule using Windows scheduler in Windows or using cronjob in Linux

    You can refer MONyog API section in documentation for further options which can be helpful for `Maintainance Window`

    http://www.webyog.co…_MONyog_API.htm

    Please let us know if you need any help.

    Regards,

    Mahesh

You must be logged in to reply to this topic.