Setting Incremental Backup using ZRM

Its been a while I wrote anything on MySQL and/or Database related things as I was on a long two month vacation and immediately had a job change.

Today I was playing a bit in trying to setup up the ZRM community backup on Cent OS 5 to have a incremental backup mechanism; to see how it works as I never had a chance to use it so far. In the process, I could not find a single source of document which explains the basic steps needed on first-hand setup (or my search did not yield the right docs), so thought of writing and noting it down myself for any future reference. More or less, the instructions should be same for any Linux favor.

Here are the steps:

• First install perl-DBI and perl-XML-Parser modules
  Shell

  sudo yum install perl-DBI perl-XML-Parser

  1 2 3

  sudo yum install perl-DBI perl-XML-Parser
• Download and install ZRM package.
  Shell

  sudo rpm -ivh MySQL-zrm-2.0-1.noarch.rpm

  1 2 3

  sudo rpm -ivh MySQL-zrm-2.0-1.noarch.rpm

  Shell

  Password:

  1 2 3

  Password:

  Shell

  warning: MySQL-zrm-2.0-1.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 3c5d1c92

  1 2 3

  warning: MySQL-zrm-2.0-1.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 3c5d1c92

  Shell

  Preparing... <span class="rem">########################################### [100%]</span>

  1 2 3

  Preparing...                <span class="rem">########################################### [100%]</span>

  Shell

  1:MySQL-zrm <span class="rem">########################################### [100%]</span>

  1 2 3

  1:MySQL-zrm              <span class="rem">########################################### [100%]</span>

  Shell

  Checking and Migrating old ZRM data

  1 2 3

  Checking and Migrating old ZRM data
• Create user called backup_user identified by backup_user in MySQL
  Shell

  mysql> <span class="kwrd">GRANT</span> <span class="kwrd">ALL</span> <span class="kwrd">ON</span> *.* <span class="kwrd">TO</span> <span class="str">'backup_user'</span>@localhost IDENTIFIED <span class="kwrd">BY</span> <span class="str">'backup_user'</span>;

  1 2 3

  mysql> <span class="kwrd">GRANT</span> <span class="kwrd">ALL</span> <span class="kwrd">ON</span> *.* <span class="kwrd">TO</span> <span class="str">'backup_user'</span>@localhost IDENTIFIED <span class="kwrd">BY</span> <span class="str">'backup_user'</span>;

  Shell

  Query OK, 0 <span class="kwrd">rows</span> affected (0.00 sec)

  1 2 3

  Query OK, 0 <span class="kwrd">rows</span> affected (0.00 sec)

  Shell

  mysql> flush <span class="kwrd">privileges</span>;

  1 2 3

  mysql> flush <span class="kwrd">privileges</span>;

  Shell

  Query OK, 0 <span class="kwrd">rows</span> affected (0.00 sec)

  1 2 3

  Query OK, 0 <span class="kwrd">rows</span> affected (0.00 sec)

• Add a new directory under /etc/mysql-zrm/ as ˜dailyrun™ and copy the mysql-zrm.conf to this directory

  Shell

  sudo mkdir -<span class="kwrd">p</span> /etc/mysql-zrm/dailyrun

  1 2 3

  sudo mkdir -<span class="kwrd">p</span> /etc/mysql-zrm/dailyrun

  Shell

  sudo cp /etc/mysql-zrm/mysql-zrm<span class="cls">.conf</span> /etc/mysql-zrm/dailyrun/

  1 2 3

  sudo cp /etc/mysql-zrm/mysql-zrm<span class="cls">.conf</span> /etc/mysql-zrm/dailyrun/

• Start editing the file /etc/mysql-zrm/dailyrun/mysql-zrm.conf and fill some of basic information and leave backup-level=1 and backup-mode=raw. The conf-file self-explains on every parameter, so it becomes easy for anyone to setup even for first time.

• Start testing the backup using mysql-zrm-scheduler by issuing:

  Shell

  sudo mysql-zrm-scheduler --now --backup-set dailyrun

  1 2 3

  sudo mysql-zrm-scheduler --now --backup-set dailyrun

• Once tested, add it to the standard daily scheduler to backup at 1 AM:

  Shell

  mysql-zrm-scheduler --add --interval daily --start 01:00 --backup-set dailyrun

  1 2 3

  mysql-zrm-scheduler --add --interval daily --start 01:00 --backup-set dailyrun

I am not going further to explain on how to verify the backup and restore it back, even though they are straight forward by using the ZRM utilities provided by the Zmanda; and complete information can be found from here.