To take advantage of ZFS snapshots, all MySQL data and logs for databases/tables that belong to the backup set. The following are some of the possible configurations
The MySQL backup user (described in System Requirements) must be granted sudo privileges to execute ZFS commands on the MySQL server. Add a line similar to the following example to /usr/local/etc/sudoers on the MySQL server:
mysql MySQLserver.mycompany.com=NOPASSWD:/usr/sbin/df,NOPASSWD:/usr/sbin/zfs
where MySQLserver.mycompany.com is the fully-qualified domain name for the MySQL server. If the MySQL database resides on the the ZRM server, the ZRM server name should be used. Note that if ZFS commands are installed in non-standard locations, the above example would not work without editing it to reflect the different paths.
To test the sudo configuration, run the command as the "mysql" user. The command should execute correctly without prompting for a password. For example:
# su - mysql $ sudo /usr/sbin/df
All MySQL database files (data, log, indexes) belonging to the backup set must be stored in ZFS volumes to ensure consistency.
Refer to the Solaris ZFS documentation for details on ZFS administration.