Backup Reports

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search

ZRM for MySQL has a utility call mysql-zrm-reporter that can be used to extract information on backup policy, backup performance, impact on application and database/tables.

  • The mysql-zrm-reporter utility has pre-defined reports as well as user configured reports.
  • The pre-defined reports also have defaults so that very little is required to configure them in most of the cases.
  • ZRM for MySQL automates generation of reports on dealing with backups executed.
  • Reports can be configured globally, specific to a backup set, or launched form the Command Line with parameters of your choice.
  • Report configuration files use additional parameters like width, alignment and format that assist in laying out the reports better.
  • Choice of format of the reports i.e. Text or HTML.
  • Reports can be emailed to the address specified, provided the local machine on which ZRM for MySQL is running has emailing capability.
  • Similarly reports can be sent as an RSS feed provided it is configured on the local machine

Configuring Reporter Utility

  • The mysql-zrm-reporter utility is configured in a similar manner to the mysql-zrm utility.
  • Its parameters can be set globally, in a backup set specific file or passed on from command line.
  • The backup set specific configuration parameters override the global configuration parameters.

Automatic Generation of Backup Reports

ZRM for MySQL automatically generates HTML or Text backup reports after the backup run is completed. They are generated even if the backup run fails. The list of automatically generated predefined backup reports can be controlled by using html-reports in mysql-zrm.conf configuration file. Both HTML as well as Text reports are automatically generated.

The backup reports are stored under the directory html-report-directory specified in mysql-zrm.conf. All HTML reports are stored under sub-directory html and text reports are stored under sub-directory text

Configuration for automatic generation of reports mysql-zrm.conf

html-report-directory=/var/www/html/ZRMForMySQL/Reports/
html-reports=backup-status-info, backup-performance-info

Easy Access

If HTML reports are stored under the webserver document root, the backup reports are accessible from any web browser. Prevent unauthorized access using a web browser by appropriate access controls to the backup html directory.