Documentation Home
MySQL Enterprise Monitor 3.3 Manual
Related Documentation Download this Manual

18.1 Backup Overview

The following topics are described:

Common Backup Status Information

This section describes the types of information reported on each backup. These types are used in the backup information panes.

  • Backup Events: displays a summary of all the backup event types and lists all events for the selected groups or instance. The Backup Events label is a link. Clicking the link displays the Events page, filtered for backup events, only. To sort the events, ascending or descending, right-click in the required column and select the required sort. Each column supports sorting.

  • End Time: date and time at which the backup completed.

  • Type: the backup type.

  • Run Time: duration of the backup procedure.

  • Lock Time: total lock time during the backup process.

  • End LSN: the InnoDB redo log sequence number at which the backup ended.

  • Binlog Position: the point in the binlog at which the consistent snapshot was taken by the backup process.

  • Exit State: the final state of the backup process. Values can be either SUCCESS or FAILURE.

Backup Overview

The Backup Overview page has two modes, Group and Instance.

Note

If no backup data is detected in the selection, an advice page is displayed.

Group Backup Overview is displayed for a group selection, while Instance Backup Overview is displayed for an instance selection. The titles of each frame are links to the details page of the relevant instance. For example, clicking the Last Successful Full Backup title link, opens the details page for the last successful full backup. The details page opens in a tab.

  • Group Backup Overview:

    • Last Backup: displays the details of the last backup performed on a member of the group.

    • Last Failed Backup: displays the details of the last backup which failed for a member of the group.

    • Last Successful Full Backup: displays the details of the last successful full backup on a member of the group.

    • Last Successful Incremental Backup: displays the details of the last successful incremental backup on a member of the group.

    • Instance: (displayed on the Group Backup Overview only) the name of the instance, which links to the Instance Backup Overview page for that instance.

    • Group Backup Coverage: displays which monitored instances have configured backups and which do not. Filtered replicas are not counted. This section also lists all instances without a configured backup. To view the list, expand the Instances without a configured backup link.

  • Instance Backup Overview:

    • Last Backup: displays the details of the last backup performed on the selected instance.

    • Last Failed Backup: displays the details of the last failed backup on the selected instance.

      If no failed backup is detected, None found is displayed.

    • Last Successful Full Backup: displays the details of the last successful full backup on the selected instance.

    • Last Successful Incremental Backup: displays the details of the last successful incremental backup on the selected instance.

    • Full Backup Run Time History: graphs the history of the duration and lock time of all full backups run on the selected instance.

    • Incremental Backup Run Time History: graphs the history of the duration and lock time of all incremental backups run on the selected instance.

Backup History

The History tab of the group view lists all backups, successful or failed, for all the instances in the group, while the instance view lists all backups performed on the selected instance. It is possible to sort the history using the column titles.

The History is divided into Backups and Events sections on the group-level, and the instance-level includes a Graphs section. The Events section is identical to the Events section on the Current Status tab.

Note

On first run, backup data is collected up to one month in the past.

Overview Filter

The overview filter enables you to refine the contents of the History page.

  • End Time: filters the backups based on the end time of the backup, as stored in backup_history.end_time. Select Interval to use a predefined range, or select From-To to define a custom range.

  • Type: the type of backup to filter on. Possible values are Full, Incremental, TTS, or Partial.

  • Exit State: the backup result to filter on. Possible values are Successful or Failed.

  • Filter: filter the results.

  • Reset to Default: resets the selections and displays all results.


User Comments
Sign Up Login You must be logged in to post a comment.