Template:ZRM NetApp snapshot requirements >

Template:ZRM NetApp snapshot requirements

MySQL Configuration Requirements

  • Both the ZRM server and MySQL server require the configuration of sudo privileges (see below). On Solaris platforms, this means the SMCsudo package must be installed.
  • If you are backing up a remote MySQL server, the destination directory specified on the Backup Where page must exist on the MySQL server as well as the ZRM server. The MySQL backup user (OS-level) must have read/write permission to access this directory.

All MySQL data and logs must reside on Network Appliance volumes. The following are some of the possible configurations

  • All MySQL data is on a single Network Appliance Volume
  • Specific database directories are on different volumes
  • For databases containing InnoDB-based tables, the snapshot can only be used if the database directory, the InnoDB data files and the InnoDB logs are all on Network Appliance volumes.
    • The InnoDB shared data files are on a separate Network Appliance volume
    • The InnoDB logs are on a separate Network Appliance volume

 

  • The Network Appliance volumes must be mounted on the ZRM server using NFS. The ZRM server's mysql user must have permissions to read and write to the volumes.

Pre-conditions for Using Network Appliance Snapshots

  • The MySQL backup user must be granted sudo privileges to execute Network Appliance commands on the MySQL server. Add a line similar to the following example to /usr/local/etc/sudoers on the MySQL server:
mysql ZRMserver.mycompany.com=NOPASSWD:/usr/sbin/mount,NOPASSWD:/usr/sbin/umount,NOPASSWD:/usr/local/bin/df
where ZRMserver.mycompany.com is the fully-qualified domain name for the ZRM server. Note that if the mount, umount and df commands are installed in non-standard locations, the above example would not work without editing it to reflect the different paths.
  • The snap reserve for the Network Appliance volume must be adequate to accommodate changed data. The Network Appliance default of 20% may be low or high for your site, depending on data change rates.
  • To determine the snap reserve, use the Network Appliance snap reserve volumename command.
  • All MySQL database files (data, log, indexes) must be stored in Network Appliance volumes to ensure consistency.
  • If any of the files are not on Network Appliance volumes, a raw backup using mysqlhotcopy, or a logical backup using mysqldump will be taken based on the storage engines of the tables in each of the databases.

MySQL Configuration Requirements

  • Both the ZRM server and MySQL server require the configuration of sudo privileges (see below). On Solaris platforms, this means the SMCsudo package must be installed.
  • If you are backing up a remote MySQL server, the destination directory specified on the Backup Where page must exist on the MySQL server as well as the ZRM server. The MySQL backup user (OS-level) must have read/write permission to access this directory.

All MySQL data and logs must reside on Network Appliance volumes. The following are some of the possible configurations

  • All MySQL data is on a single Network Appliance Volume
  • Specific database directories are on different volumes
  • For databases containing InnoDB-based tables, the snapshot can only be used if the database directory, the InnoDB data files and the InnoDB logs are all on Network Appliance volumes.
    • The InnoDB shared data files are on a separate Network Appliance volume
    • The InnoDB logs are on a separate Network Appliance volume


The Network Appliance volumes are mounted on ZRM server using NFS. ZRM user "mysql" should have permissions to read and write to the volumes.

Pre-conditions for Using Network Appliance Snapshots

  • The MySQL backup user must be granted sudo privileges to execute Network Appliance commands on the MySQL server. Add a line similar to the following example to /usr/local/etc/sudoers on the MySQL server:
mysql ZRMserver.mycompany.com=NOPASSWD:/usr/sbin/mount,NOPASSWD:/usr/sbin/umount,NOPASSWD:/usr/local/bin/df
where ZRMserver.mycompany.com is the fully-qualified domain name for the ZRM server. Note that if the mount, umount and df commands are installed in non-standard locations, the above example would not work without editing it to reflect the different paths.
  • The snap reserve for the Network Appliance volume must be adequate to accommodate changed data. The Network Appliance default of 20% may be low or high for your site, depending on data change rates.
  • To determine the snap reserve, use the Network Appliance snap reserve volumename command.
  • All MySQL database files (data, log, indexes) must be stored in Network Appliance volumes to ensure consistency.
  • If any of the files are not on Network Appliance volumes, a raw backup using mysqlhotcopy, or a logical backup using mysqldump will be taken based on the storage engines of the tables in each of the databases.