MySQL Configuration Requirements
To take advantage of Network Appliance snapshots, 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 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.