Zmanda Documentation > Example Configuration

Example Configuration

Server configuration

  • 2 MySQL servers running on host1.company.com and host2.company.com
  • ZRM for MySQL is installed on host1.company.com
  • ssh between the machine are enabled for mysql user.

Backup requirements

  • All databases on host1.company.com needs to be backed up in raw mode
  • 2 databases (db1 and db2) on host2.company.com needs to be backed up in logical mode
  • Compression is needed to be done on all backups
  • Backup will be done using the MySQL database user mysql on both machines

ZRM for MySQL configuration

To take care of the above needs we will create two backup sets

  • host_1_backup_set
  • host_2_backup_set

We will also have a global configuration file for parameters common to both backup sets.

Global Configuration File

The global configuration file is /etc/mysql-zrm/mysql-zrm.conf and will contain the following information

compress=1
user=mysql
password=abcd123

host_1_backup_set Configuration File

This backup set file is /etc/mysql-zrm/host_1_backup_set/mysql-zrm.conf and will contain the following information

backup-mode=raw

host_2_backup_set Configuration File

This backup set file is /etc/mysql-zrm/host_2_backup_set/mysql-zrm.conf and will contain the following information

host=host2.company.com
backup-mode=logical
databases="db1 db2"
copy-plugin="/usr/share/mysql-zrm/plugins/ssh-plugin.pl