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.

MySQLTM 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 FireTM 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 SolarisTM 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

Page 5
Image 5
Sun Microsystems X4540 manual Introduction