Sun Microsystems X4540 User Manual

Using Sun Fire

TM

X4540 Server

With Zmanda Recovery Manager

2.2 for MySQL

Thomas Hanvey (Sun Microsystems)
Dmitri Joukovski and Ken Crandall (Zmanda)

October 2008

TM

Database

Copyright © 2008 Sun Microsystems, Inc., 4150 Network Circle, Santa Clara, California 95054, U.S.A. All rights
reserved.

U.S. Government Rights - Commercial software. Government users are subject to the Sun Microsystems, Inc.
standard license agreement and applicable provisions of the FAR and its supplements. Use is subject to license
terms. This distribution may include materials developed by third parties.

Parts of the product may be derived from Berkeley BSD systems, licensed from the University of California. UNIX is
a registered trademark in the U.S. and in other countries, exclusively licensed through X/Open Company, Ltd.
X/Open is a registered trademark of X/Open Company, Ltd.

AMD, Opteron, the AMD logo, the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro
Devices.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation in the United States and other
countries.

Sun, Sun Microsystems, the Sun logo, MySQL, Solaris, Sun BluePrints, Sun Fire, Sun StorageTek, and SunSolve are
trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other
countries.

This product is covered and controlled by U.S. Export Control laws and may be subject to the export or import laws
in other countries. Nuclear, missile, chemical biological weapons or nuclear maritime end uses or end users,
whether direct or indirect, are strictly prohibited. Export or reexport to countries subject to U.S. embargo or to
entities identified on U.S. export exclusion lists, including, but not limited to, the denied persons and specially
designated nationals lists is strictly prohibited.

Sun Microsystems, Inc.

Table of Contents

Introduction.....................................................................................................................................................1

Configuration ..................................................................................................................................................2

Overview...............................................................................................................................................................2

Solaris Configuration..............................................................................................................................................3

Zpool Configuration...............................................................................................................................................3

ZFS Configuration...................................................................................................................................................5

ZRM Configuration.................................................................................................................................................5

Installing the ZRM..................................................................................................................................................6

Zmanda Management Console................................................................................................................................6

Configuring Backup Sets.........................................................................................................................................7

Configuring Storage.............................................................................................................................................10

Configuring ZFS Snapshots...................................................................................................................................11

ZRM Monitoring and Reporting.............................................................................................................................13

Database Events Viewer........................................................................................................................................14

Recovery Using the ZMC........................................................................................................................................15

Summary.......................................................................................................................................................17

For More Information .....................................................................................................................................17

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 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 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

2 Configuration Sun Microsystems, Inc.

Configuration

Overview

Figure 1 shows an example of Zmanda Recovery Manager (ZRM) running on the Sun Fire X4540 server and protecting
remote MySQL servers running on Solaris OS, Linux, and Microsoft Windows machines with MyISAM and InnoDB
tables, and a MySQL Cluster with NDB storage engine.

Figure 1. Centralized Backup of MySQL Server With ZRM on Sun Fire X4540 Server

Notes:
X4540 here refers to Sun Fire X4540 Server.
All figures reprinted with permission from Zmanda.

The complete ZRM deployment consists of the following:

• ZRM Server and Zmanda Management Console (ZMC) to centralize all backup and recovery operations for

MySQL databases. You need at least one ZRM server for your environment. In Figure 1, ZRM is configured on
the Sun Fire X4540 server.

• Zmanda ZRM clients installed on remote Solaris, Linux, or Microsoft Windows systems where you run MySQL.

Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQL Database

3 Overview Sun Microsystems, Inc.

Solaris Configuration

For this guide, the Sun Fire X4540 server used for ZRM certification was running the Solaris 10 8/07 OS. This is the
minimum recommended version to use because various ZFS improvements were introduced in this build.

The Sun Fire X4540 server is powered by up to 8 CPUs operating at 2300 MHz and provides 48 SATA drives with a total
capacity close to 50 Tbytes in a 4U enclosure. The two boot drives are mirrored using Solaris Volume Manager with
UFS. The rest of the drives are available for backup data.

The default NIC configuration on the Sun Fire X4540 server allows up to four physical Gigabit Ethernet connections to
be attached. The connections provide backup ability for up to four separate subnets. Alternatively, the links can be
aggregated together using dladm(1M) for improved throughput to a single subnet.

Zpool Configuration

The decision about how to configure zpools needs to be based on a number of factors:

• What is the required performance needed? (IOPS/throughput)

• What is the required data protection level needed? (RAIDZ, RAIDZ2, mirror)

• What is the required capacity?

After gathering and analyzing the requirements, a configuration that balances the needs of those requirements can be
chosen.

When configuring the system for network backups, the ability of the Sun Fire X4540 server to receive data over the
network is also a factor. For example, a 500-Mbyte/sec backup speed requirement cannot be met solely by using the 4
pre-installed Gigabit Ethernet ports. Additional network cards would be required to accommodate such throughput.

Care should be taken that a system is not over-configured for disk performance, at the expense of space or data
protection, when the entire system (encompassing MySQL backup clients and network infrastructure) is not able to
send data at adequate levels. Likewise, a system should not be over-configured for space at the expense of
performance or data protection.

For the purposes of this guide, the Sun Fire X4540 server was configured with one zpool consisting of 12 drives and 2
spares in a RAIDZ2 configuration. This provided 7 Tbyte of capacity for backups with a very high level of protection
against drive failure and performance sufficient to handle 300 to 350 Mbyte/sec of backup traffic over the network.

Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQL Database