Example Configuration
Jump to navigation
Jump to search
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