Template:ZRM Pre-installation Checks

Table of contents
  1. 1. Pre-Installation Changes

Version as of 20:30, 19 May 2024

to this version.

Return to Version archive.

View current version

  • Verify that the version(s) of MySQL server(s) that you deploy are supported by Zmanda Recovery Manager for MySQL.
  • Verify that a mysql user and a mysql group exist on the ZRM server.
  • ZRM for MySQL requires the MySQL client commands listed below to be installed on the local server where ZRM for MySQL is running. These commands are required on the ZRM machine even if ZRM for MySQL is backing up remote MySQL servers:
  • The ZRM for MySQL socket server package requires MySQL server and must be installed on MySQL servers.

Note: The ZRM for MySQL debian package explicitly checks for the presence of the mysql-client package on the ZRM machine before installation. The ZRM for MySQL socket server debian package explicitly checks for the presence of the mysql-server package on the MySQL server.

  • The MySQL client commands installed on the local machine should be compatible with the local MySQL server.
  • It is preferable to use the same version of MySQL on local and remote MySQL servers.
  • Check that MySQL client commands are installed in /usr/bin/ . If they are not, you must change the configuration of the client command location and binary log location in {{web.html($Config_method)}}. See the MySQL subsection of the {{web.html($BS_Config_method)}} for details.
  • Installation and configuration of Zmanda Recovery Manager for MySQL requires superuser access. All ZRM for MySQL commands can be run as any user belonging to the mysql group.
  • Two perl modules are necessary for MySQL ZRM. See the Perl installation notes section of the manual.
    • perl-DBI
    • perl-XML-Parser
These packages are available from CPAN repository or as part of the distribution. Following command can install perl DBI module:
# perl -MCPAN -e 'install DBI'
  • ZRM for MySQL packages require the mailx mail package installed on the machine running ZRM for MySQL. mailx can be found as part of the distribution. The mailx package must be configured to send mail from the ZRM machine to the MySQL database backup administrator.

Pre-Installation Changes

A few scenarios require changes to be made to MySQL database and server configuration:

Root not doing backups 
When a user with root privileges will not be doing backup and/or recovery of MySQL databases, create a new MySQL backup user as well as a restore user.
Incremental backups 
To incrementally back up of MySQL database, enable binary logs on the MySQL server .
Backup using LVM snapshots 
Store MySQL data in logical volumes when this backup method is required at your site.
Secure communication between remote MySQL server and local ZRM for MySQL 
We recommended that you enable SSL on the MySQL server if the backups are performed on unsecured networks. Enabling SSL is described towards the bottom of this page.