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
