# MySQL Backup monitoring using prometheus and grafana

**URL:** https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924
**Category:** PMM 2.x
**Tags:** pmm
**Created:** [June 17, 2021, 6:26pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924 "2021-06-17T18:26:28Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Hussain\_Patel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hussain_patel/32/17808_2.png) [@Hussain\_Patel](https://forums.percona.com/u/Hussain_Patel)
#### Post date: [June 17, 2021, 6:26pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/1 "2021-06-17T18:26:29Z")

</div>

Hi Team,

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

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [July 6, 2021, 5:25pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/2 "2021-07-06T17:25:08Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Hussain\_Patel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hussain_patel/32/17808_2.png) [@Hussain\_Patel](https://forums.percona.com/u/Hussain_Patel)
#### Post date: [July 6, 2021, 6:32pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/3 "2021-07-06T18:32:44Z")

</div>

Hi matthew,

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

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [July 6, 2021, 8:20pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/4 "2021-07-06T20:20:03Z")

</div>

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`

---

<div class="post-metadata">

### Author: ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)
#### Post date: [July 6, 2021, 11:06pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/5 "2021-07-06T23:06:12Z")

</div>

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!

---

<div class="post-metadata">

### Author: ![Hussain\_Patel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hussain_patel/32/17808_2.png) [@Hussain\_Patel](https://forums.percona.com/u/Hussain_Patel)
#### Post date: [July 7, 2021, 5:08pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/6 "2021-07-07T17:08:03Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)
#### Post date: [July 7, 2021, 5:53pm UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/7 "2021-07-07T17:53:06Z")

</div>

Check out [Backup and Restore - Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/2.x/using/backup.html)

---

<div class="post-metadata">

### Author: ![sshine](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@sshine](https://forums.percona.com/u/sshine)
#### Post date: [June 2, 2022, 1:53am UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/8 "2022-06-02T01:53:21Z")

</div>

do you have implemented it now ?

---

<div class="post-metadata">

### Author: ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)
#### Post date: [June 2, 2022, 10:54am UTC](https://forums.percona.com/t/mysql-backup-monitoring-using-prometheus-and-grafana/10924/9 "2022-06-02T10:54:56Z")

</div>

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.
