MySQL Backup monitoring using prometheus and grafana

Hi Team,

Do you have a way to monitor mysql backups done using percona xtrabackup and report it to grafana prometheus.

Hello @Hussain_Patel,
There is no way to directly monitor the success/failure of xtrabackup (an external process) to PMM. PMM does not monitor/scrape this data. What you could do is use PMM’s Annotation feature for this. When your backup job script runs, send an API to PMM and add an annotation ‘BEGIN BACKUP’. Then when the script exits, send another annotation ‘FINISH BACKUP’ on success, or ‘FAILED BACKUP’ on failure.

1 Like

Hi matthew,

Do you have any links to see how to get it implemented.

1 Like

You have to design the wrapper script yourself. Simple bash is very easy. The API for PMM is well documented too: https://pmmdemo.percona.com/swagger#/Annotation/AddAnnotation

1 Like

The PMM team did launch a technical preview of backup management in pmm 2.19.0 (enable under settings). This gives the ability to monitor backups that are scheduled using the backup management tool and we use xtrabackup as the main tool for mysql dbs. You can see the backup schedule, status of current and previous backups and even perform some basic restores right from the UI or even API. This is not yet something we would recommend for production use yet but we will never get to that point if people don’t turn on the preview and play with it! We are entering hardening phase now so it’s not far off from being GA!

1 Like

Where do i play with it? Share me the doc if any.

1 Like

Check out Percona Monitoring and Management

1 Like