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
2 Likes
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!
2 Likes
Where do i play with it? Share me the doc if any.
1 Like
1 Like
do you have implemented it now ?
1 Like
Yes, this is implemented and you are encouraged to start testing it, but it is not GA yet so expect some features be still missing.
1 Like