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
- 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.
- If you intend to use snapshot devices rather than storage checkpoints (the default), you must configure a snapshot device for each volume used by the MySQL database(s) being backed up.