Table of contents
- 1. Using Logs
All backup, recovery, reporting and scheduling operations statuses are logged by ZRM for MySQL.
These logs are available under /var/log/mysql-zrm directory on the local machine where ZRM for MySQL runs.
Use the logs for debugging in case of failures as well as for auditing backup/recovery database operations.
If detailed logs for a backup run is required the following parameter can be specified either in the configuration files.
verbose=1
| Utilities | Log file name |
|---|---|
| mysql-zrm, Pre-Backup Plugin, Post-Backup Plugin, Binary Log Parser Plugin, Copy Plugin | mysql-zrm.log |
| mysql-zrm-reporter | mysql-zrm-reporter.log |
| mysql-zrm-scheduler | mysql-zrm-scheduler.log |
| Pre Scheduler Plugin | mysql-zrm-pre-scheduler.log |
Consult the plugins section for more details on plugins.
Using Logs
Example: mysql-zrm log file entries from a restore of incremental backup:
Wed Aug 30 02:39:48 2006: INFO: mysql-zrm started
Comment: All the MySQL backup runs starts with "mysql-zrm started" message.
Action being performed is listed next.
Wed Aug 30 02:39:48 2006: INFO: action being performed is restore Wed Aug 30 02:39:48 2006: INFO: backup set being used is backup
Comment: Command line parameters of mysql-zrm are listed next.
Wed Aug 30 02:39:48 2006: INFO: Reading options from file /etc/mysql-zrm/backup/mysql-zrm.conf
Wed Aug 30 02:39:48 2006: INFO: Mail address: root is ok
Wed Aug 30 02:39:48 2006: INFO: Input Parameters Used {
Wed Aug 30 02:39:48 2006: INFO: verbose=1
Wed Aug 30 02:39:48 2006: INFO: backup-level=1
Wed Aug 30 02:39:48 2006: INFO: mailto=root
Wed Aug 30 02:39:48 2006: INFO: destination=/mysql-zrm
Wed Aug 30 02:39:48 2006: INFO: databases=wikidb
Wed Aug 30 02:39:48 2006: INFO: source-directory=/mysql-zrm/backup/20060830020843
Wed Aug 30 02:39:48 2006: INFO: host=localhost
Wed Aug 30 02:39:48 2006: INFO: database=wikidb
Wed Aug 30 02:39:48 2006: INFO: backup-mode=raw
Wed Aug 30 02:39:48 2006: INFO: password=******
Wed Aug 30 02:39:48 2006: INFO: user=root
Wed Aug 30 02:39:48 2006: INFO: stop-position=5003
Wed Aug 30 02:39:48 2006: INFO: }
Comment: Parameters used for restore operation are listed next.
Wed Aug 30 02:39:48 2006: INFO: Getting the data directory Wed Aug 30 02:39:48 2006: INFO: mysqladmin --user=root --password=***** --host=localhost variables 2> /tmp/mysql-zrm-20060830023948.out Wed Aug 30 02:39:48 2006: INFO: datadir is /var/lib/mysql/ Wed Aug 30 02:39:48 2006: INFO: mysql_version is 4.1.21-standard-log Wed Aug 30 02:39:48 2006: INFO: Checking if this is a replication slave using command Wed Aug 30 02:39:48 2006: INFO: echo "show slave status"|mysql --user=root --password=***** --host=localhost Wed Aug 30 02:39:48 2006: INFO: This is not a replication slave or we do not have appropriate access rights.
replication data if any has not been backed up.
Wed Aug 30 02:39:48 2006: INFO: Ignoring the --replication option
Comment: Validation of backup parameters are listed next.
Wed Aug 30 02:39:48 2006: INFO: Restoring incremental Wed Aug 30 02:39:48 2006: INFO: mysqlbinlog --user=root --password=***** --host=localhost --stop-position=5003 --database=wikidb "/mysql-zrm/backup/20060830020843"/vmsql4-bin.[0-9]* | mysql --user=root --password=***** --host=localhost Wed Aug 30 02:39:48 2006: INFO: Incremental restore done
Comment: Incremental restoration is complete
Wed Aug 30 02:39:48 2006: INFO: for database wikidb Wed Aug 30 02:39:48 2006: INFO: Wed Aug 30 02:39:48 2006: INFO: Shutting down MySQL Wed Aug 30 02:39:53 2006: INFO: Restore done in 5 seconds.
Comment: MySQL server is shutdown after database restoration.