How do you install MySQL ZRM?

Before installation

• Check the version of your MySQL server. Verify that this is a version supported by Zmanda Recovery Manager for MySQL.

• MySQL ZRM requires MySQL client commands to be installed on the machine where MySQL ZRM is running. These commands are required even if MySQL ZRM is backing up remote MySQL servers. MySQL ZRM depends on the following MySQL commands:
  • mysqladmin
  • mysqlhotcopy
  • mysqldump
  • mysqlbinlog
  • mysql

• The MySQL client commands installed on MySQL ZRM machine should be compatible with the MySQL server. It is preferable to use the same version of MySQL on MySQL servers and on the MySQL ZRM machine if they are running on different machines.

• If the MySQL client commands are installed in a different location (not /usr/bin/), it is neccessary to configure the client command location and binary log location in mysql-zrm.conf. See mysql-zrm.conf configuration section for details.

• Zmanda Recovery Manager for MySQL installation and configuration requires Unix superuser access. All MySQL ZRM commands are run as the superuser.

• ZRM for MySQL requires Perl 5.8.7 or later version.

• Two perl modules are necessary for MySQL ZRM installation
  • 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'

Installation using RPM

• RPM installation must be done as superuser.
• RPMs are available from Zmanda downloads page.
  • There are two ZRM for MySQL RPMs - MySQL-zrm RPM must be installed on the machine that will be doing backups and MySQL-zrm-socket-server RPM must be installed on the MySQL servers if the MySQL server is being backed up remotely using socket copy plugin.
• Verify the RPM signatures. If the signatures are not correct, try downloading again.
• Install using rpm(8) command:

# rpm -ivh MySQL-zrm-1.1.5-1.noarch.rpm
Preparing...                ########################################### [100%]
  1:MySQL-zrm               ########################################### [100%]

Installation using Debian packages

• Debian package installation must be done as superuser.
• Debian packages are available from Zmanda downloads page.
  • There are two debian packages - mysql-zrm package must be installed on the machine that will be doing backups and mysql-zrm-socket-server package must be installed on the MySQL servers if the MySQL server is being backed up remotely using socket copy plugin.
• Use MD5 checksums in the downloads page to check the integrity of the downloaded package before installation.
• Install using dpkg(8) command:

# dpkg -i mysql-zrm_1.1.3_all.deb
Unpacking mysql-zrm (from mysql-zrm_1.1.3_all.deb) ...
Setting up mysql-zrm (1.1.3) ...

On MySQL servers, you can install mysql-zrm-socket-server debian package if socket copy plugin is being used.

 # dpkg -i mysql-zrm-socket-server_1.1.3_all.deb
 Unpacking mysql-zrm-socket-server (from
 mysql-zrm-socket-server_1.1.3_all.deb) ...
 Setting up mysql-zrm-socket-server (1.1.3) ...
 Reloading internet superserver: inetd.

Installation from tar ball

• Download the MySQL ZRM tar ball from Zmanda downloads page.
• Verify the MD5 sum of the downloaded tar ball matches the information in the Zmanda downloads page.
• Uncompress the tar ball

 $ gunzip MySQL-zrm-1.1.5-release.tar.gz

• Extract the tar file using tar(1) command. The files will be extracted with respect to the current directory. Extracting the files in root (/) directory will install MySQL ZRM. The directory locations used by the tar ball may not be compatible with the distribution. So, extract the files in a temporary directory and move them to correct directory location. For locations where files are installed, see installation locations.

 $ mkdir /usr/tmp/MySQL-zrm; cd /usr/tmp/MySQL-zrm
 $ tar xvf MySQL-zrm-1.1.5-release.tar

Installation locations

Files are installed in following directories:

	Directory location
Executables	/usr/bin
Man pages	/usr/share/man/{man1,man5}
Configuration files	/etc/mysql-zrm
Plugin templates and samples	/usr/share/mysql-zrm/plugins
README files and docs	/usr/share/doc/MySQL-zrm-* or /usr/share/doc/mysql-zrm
Libraries	/usr/lib/mysql-zrm
Log files	/var/log/mysql-zrm
Backup images	/var/lib/mysql-zrm

Is MySQL ZRM really installed?

You can do one of the following to verify installation:

• Use rpm(8) command

# rpm -qa | grep MySQL-zrm
MySQL-zrm-1.1.3-1

• Check mysql-zrm man page

# man mysql-zrm