Report Custom

Custom reports

ZRM for MySQL & MariaDB generates a number of Predefined backup reports you can easily customize. ZRM for MySQL & MariaDB automatically generates backup reports after each backup run is completed.

 ReportCustom-ZRM-3.2.png

The Custom Reports displays a list of predefined reports, along with checkboxes that allow the user to customize reports.

  • The left panel shows a list of predefined reports; beneath this list is a series of checkboxes that let you customize the display.
  • The right panel displays the Report.

Predefined Reports

The list of Predefined Reports and User defined reports that can be run for the selected backup set can be selected from the drop down box on the left panel.

The predefined reports are shown and described below. The reports are shown displaying the default columns; you can customize each of the reports to display the desired

ReportCustom-Predefined-ZRM-3.2.png

column fields. The Backup Date and Time column is common to all the reports. It identifies and differentiates between different Backup Runs of the same backup set. A few key columns are discussed below.

When any link is clicked, ZRM for MySQL & MariaDB jumps to the Restore What page with the date and time filled in based on the backup you selected from the report.

Backup Report

The Backup Report has columns that display Level, Database and Tables, corresponding to the Backup Whatparameters. It also has a column that shows the status of the run.

Application Impact Report

The Application Impact Report displays the Read Lock Time and Total Time for each run. These allow you to determine how the backup run affected database application performance.

Backup Status Report

The Backup Status Report displays the Status and the Destination Directory where the data has been backed up. The Status of the run is also displayed.

Backup Method Report

The Backup Method Report displays the backup method (i.e. Databases Logical, Databases Raw and Snapshots) used to create the backup. The data in these columns will not change across runs. By changing the backup set selection in the drop down box at the top of the page, can quickly see which backup sets have what methods.

Backup Retention Policy Report

The Backup Retention Report shows the retention policy for the backup set. A blank column indicates that no purge policy has been set for the backup set.

Backup Performance Report

The Backup Performance Report displays compression and performance statistics for the backup set.

 

Incremental Backup Report

The Incremental Backup Report shows the kind of backup performed: Incremental Backup Sets will display a value, while full backups display a blank column.

Replication Backup Report

The Replication Backup Report has two columns. 'Replication Files' and 'Slave Load Files' show values when Replication has been set for the backup set.

Cluster Backup Report

The Cluster Backup Report has three columns. 'NDB Backup ID' , 'NDB Connect String' and 'NDB Node List'that will show the same values until changed by the User. The Status column allows users to judge the impact of changing these parameters.

Customized Report

 
ReportCustom-Export-ZRM3.5.png
 
You can name the customized report so that it can retrieved later. All ZMC users can retrieve the report. The report name appears as part of list of Predefined reports.
 
Save as CSV button allows users to save custom reports in CSV format. This format can be read by any spreadsheet or report analysis tool. Before saving a custom report as CSV, you must name the report using Save Customized Report. The CSV output is saved in a file named zrm3_5-<custom report name>.csv