1 Introduction Sun Microsystems, Inc.
Introduction
This paper discusses how to quickly configure and deploy the Sun Fire X4540 server with Zmanda Recovery Manager 2.2
for MySQL databases. For more information on ZRM Enterprise, see: http://zmanda.com/zrm-mysql-enterprise.html.
MySQL
TM
software has become the world's most popular open source database because of its ease of use, high
performance, and high reliability (see http://www.sun.com/software/products/mysql). Regardless of how you use
MySQL software (for example, with a web site or a custom MySQL application), you must ensure successful, secure,
and consistent backups with minimal impact on applications.
The Sun Fire
TM
X4540 server can deliver massive storage capacity and remarkable throughput so it is well-suited as a
nearline storage platform for backup and restore applications. Combining the power of the Solaris
TM
10 Operating
System with the data integrity and simplified administration of ZFS, the Sun Fire X4540 server can be an ideal
candidate for streamlining and improving backup and restore operations.
Zmanda Recovery Manager (ZRM) for MySQL provides comprehensive backup and recovery capabilities for MySQL
databases. It simplifies database administration by providing an easy-to-use, flexible, and robust backup and recovery
solution.
With ZRM you can:
• Perform backups that are optimized for your storage engine and your MySQL configuration.
• Recover a database easily to any point in time or to any particular transaction, for example, just before a user
made an error.
• Centrally manage all backup and recovery operations for a single or multiple MySQL servers from a web-based
management console.
• Schedule full and incremental backups of your MySQL database.
• Define retention policies and automatically delete backups that have expired.
• Visually review MySQL logs for operational and security reasons.
• Easily identify recovery points.
• Choose flexible logical or faster raw backups of your database.
• Provide hot backups of online MySQL databases via various snapshot technologies.
• Back up your remote MySQL database through a firewall.
• Configure on-the-fly compression and/or encryption of your MySQL backups to meet your storage and security
needs.
• Get email or RSS notification about the status of your backups and receive MySQL backup reports.
Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQL Database
