Bug #74902 Backup Status Overview
Submitted: 17 Nov 2014 15:06 Modified: 18 Nov 2014 13:37
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S4 (Feature request)
Version:3.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Backup, backup_history, meb, mysqlbackup, overview, report

[17 Nov 2014 15:06] Daniël van Eeden
Description:
I would like to have an overview of the backup status per MySQL instance.

Something like this:
INSTANCE LAST_FULL_SUCCESS LAST_INCR_SUCCESS
mysql1   2014-10-01        2014-10-07
mysql2   2014-11-10        2014-11-11
mysql3   2014-11-10        2014-11-12
mysql4   2014-11-10        NEVER
mysql5   NEVER             NEVER

The output should be web (mem) or alternatively as text report.

Some info is available on <mem>/v3/inventory/com.mysql.etools.inventory.model.mysql.backup.EnterpriseBackup/ but that's not easily consumable by a script.

This would only work for MySQL Enterprise Backup as mysqldump and cluster backup won't update mysql.backup_history yet. (Bug #74064)

Having an overview of MEB versions would be helpfull, but that depends on Bug #74063

How to repeat:
See description
[18 Nov 2014 13:37] Mark Leith
Thanks for the feature request, verifying.