What can MySQL ZRM do?

Backup features

Backup of multiple databases

MySQL ZRM can backup multiple MySQL databases that are managed by the MySQL server. It can also backup tables in a single database. It can perform hot and cold backups of the databases.

Support for multiple backup methods

MySQL ZRM can use various MySQL backup methods depending on the storage engine used by MySQL tables. It uses mysqldump, mysqlhotcopy, lvm snapshots and MySQL replication as various backup methods. The tool will use the method that will create consistent backup of the database irrespective of the storage engines used by the databases tables. Backup method can be overridden by user input.

Backup of local MySQL server

In this mode, MySQL ZRM runs on the same machine as the MySQL server. It can use mysqldump, LVM snapshots, mysqlhotcopy to do local MySQL server backups.

Backup of remote MySQL server

In this mode, MySQL ZRM runs on a different machine from the MySQL server. It can use mysqldump or MySQL replication to do backups of remote MySQL servers. SSL authentication is supported between MySQL ZRM and MySQL server which allows for backups over internet or across firewalls. Incremental backups of remote MySQL server is not possible.

Backup Levels

MySQL ZRM does full database backups and incremental database backups.

Disk based backups

All backups are stored on disk (under backup root directory - /var/lib/mysql-zrm)

Backup retention policy

Different retention policies can be specified for each backup set.

Backup verification

Verification can be performed on backed up data.

Recovery features

Backup index

All information about backup run is stored in a backup index. The backup index can be browsed using MySQL ZRM reporting tool.

Full and incremental database recovery

Database restoration can be done only when the MySQL server is inactive. MySQL server should be stopped.

Selective restoration

Incremental restores can be done based on binary log position. This would permit recovery from database operator errors

Point in time recovery

Database can be recovered to any point in time between two successful backups.

Reporting and Scheduling features

Backup sets

MySQL ZRM can be configured in terms of backup sets. Each backup set consists of the list of databases or tables within a database, backup schedules, backup method and configuration parameters. All tools use backup set as parameters

Scheduling

MySQL ZRM backup runs can be scheduled in daily/weekly/monthly intervals. Scheduler can also be used to do backup immediately.

Backup reporting

Status of backup run, backup statistics, backup contents, location of backups can be obtained using backup reporting tool. Backup performance measurements can be used to choose appropriate backup method for a database. There are pre-defined backup reports as well as capability of creating user defined reports. Backup reports are also available in HTML format.

Email notification

MySQL ZRM can send email notification about the backup run status to the MySQL backup administrator.

Logging

All backup and Recovery information is logged in a log file that can be used for auditing as well as debugging.