This MindTouch Deki has expired; please contact your system administrator. Visit MindTouch.com for activation information.

Logs

Table of contents
  1. 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
UtilitiesLog file name
mysql-zrm, Pre-Backup Plugin, Post-Backup Plugin, Binary Log Parser Plugin, Copy Pluginmysql-zrm.log
mysql-zrm-reportermysql-zrm-reporter.log
mysql-zrm-schedulermysql-zrm-scheduler.log
Pre Scheduler Pluginmysql-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.


Retrieved from "http://docs.zmanda.com/Logs"

Powered by MindTouch Deki v.8.08.2