10 | Sun Microsystems, Inc. |
Configuring Storage
Figure 4 shows the Backup Where page, which specifies where the backup images for the backup set will be stored and how long to retain them.
Figure 3. Backup Where Page for Configuring Storage
Regardless of where the remote MySQL server is hosted, backups are stored under the backup directory of the local machine where ZMC runs. The default is /var/lib/mysql-zrm. If you specify another directory, you must create it yourself on both the ZRM server and the MySQL server, and ensure that its permission settings allow read/write access to the MySQL backup user.
We already configured a ZFS volume at /var/lib/mysql-zrm as a repository for MySQL backup archives. For extra protection, the MySQL backup data can be migrated to other storage devices, for example, to a Sun StorageTek™ SL48 Tape Library using network-based backup and recovery software such as Amanda Enterprise.
You must allocate sufficient disk space to store backup copies of all your MySQL databases. In the unlikely event that the Sun Fire X4540 server does not have sufficient disk space allocated, the backup run will fail. The destination directory should have at least 150% of uncompressed backup space available for a successful backup run. This additional space is required even when backups are configured for compression, since the additional space is used for compression during the backup run. The additional space is freed after the backup run. It must also have permissions set to allow read/write access to the MySQL backup user.
Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQL Database