MySQL Configuration Requirements
To take advantage of VxFS snapshots, all MySQL data and logs must reside on VxFS volumes. The following are some of the possible configurations
- All MySQL data is on a single VxFS 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 VxFS volumes.
- The InnoDB shared data files are on a separate VxFS volume
- The InnoDB logs are on a separate VxFS volume
The VxFS 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 VxFS Snapshots
- The snap reserve for the VxFS volume must be adequate to accommodate changed data. The VxFS default of 20% may be low or high for your site, depending on data change rates.
- To determine the snap reserve, use the VxFS snap reserve volumename command.
- All MySQL database files (data, log, indexes) must be stored in VxFS volumes to ensure consistency.
- If any of the files are not on VxFS 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.