Using ZFS Snapshots With Zmanda Recovery Manager for MySQL on OpenSolaris 2008.11 OS

Caryl Takvorian, May 2009

Introduction

The objective of this report is to show how to deploy Zmanda Recovery Manager 3.0 for MySQL on the OpenSolaris 2008.11 OS and how ZRM performs on a Sun Fire X4500 system using the ZFS file system.

In particular, this report demonstrates how ZRM takes advantage of ZFS snapshot technology to provide a strong open source data-protection solution for MySQL.

For more details, see the list of contents below.

Download the document as PDF.

Contents

• Introduction
• Architecture Overview
• • OS Configuration
  • The ZFS File System
  • • Zpool Configuration
    • ZFS Configuration
  • Zmanda Recovery Manager 3.0 for MySQL
  • • ZRM Configuration
    • Installing Dependencies Using pkgadd
    • Installing Dependencies Using IPS
    • Installing ZRM
  • Types of Backup Available to ZRM
  • • Raw-Copy Backup
    • Logical Backup
    • Raw-Quick (No-Copy) Backup
  • Performance Testing Setup
  • • System Setup
    • MySQL Software Release
    • OpenSolaris Operating System Release
    • Zpool Configuration
    • ZFS Configuration
    • ZRM Software Release
    • db_STRESS Load Generator
    • • 1. Creating the test databases
      • 2. Creating test tables in pool2/mysql
      • 3. Generating the dataset
      • 4. Loading the dataset into the tables
      • 5. Creating users
      • 6. Creating a test scenario
    • Testing Methodology
  • Performance Test Results
  • • 1. MyISAM Results with Idle Database
    • 2. InnoDB Results with Idle Database
    • 3. MyISAM Results with a 15 Percent Load on the Database
    • 4. InnoDB Results with a 15 Percent Load on the Database
    • 5. MyISAM Results with a 90 Percent Load on the Database
    • 6. InnoDB Results with a 90 Percent Load on the Database
  • Summary
  • Product Information

  For More Information

  Here are additional resources:

  • Zmanda documentation:
    • Zmanda Recovery Manager for MySQL web site, including ZRM datasheet (PDF)
    • Zmanda Recovery Manager for MySQL is available for download from the Zmanda network (requires registration)
    • Zmanda Network documentation for Zmanda Recovery Manager (requires registration), includes ZRM: Guide to MySQL Backup & Recovery and Backup and Recovery Benchmark for MySQL with ZRM
    • Backup and recovery benchmarks for MyISAM and InnoDB engines with Zmanda Recovery Manager for MySQL
    • BigAdmin articles:
      • Sun Fire X4540 Server as Backup Server for Zmanda's Amanda Enterprise 2.6 Software
      • Sun Storage J4400 Array as Disk Storage for Zmanda Recovery Manager for MySQL
      • Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQL Database
  • Sun Fire X4500 server document collection
  • OpenSolaris 2009.06 Image Packing System Guide (PDF)
  • ZFS documentation:
    • Solaris ZFS Administration Guide (part of the Solaris 10 System Administration Collection)
    • Sun documents at http://docs.sun.com
    • ZFS Best Practices Guide on the Solaris Internals web site
  • MySQL Resources:
    • MySQL site on sun.com
    • mySQL.com web site
    • MySQL documentation site
    • MySQL training courses
    • MySQL download sites:
      • Get MySQL
      • MySQL Downloads
  • Sun training courses at http://www.sun.com/training/
  • Discussions:
    • Zmanda forums
    • MySQL forums
    • Sun Storage forums
    • Sun Hardware - Servers forums
  • Wikis:
    • Sun BluePrints wiki, especially the following:
      • Storage BluePrints page
      • Sun BluePrints article: Optimize MySQL Server on Sun x64 Servers and Storage
    • Sun Storage Administration wiki
    • BigAdmin Storage Tech Tips wiki
    • BigAdmin Databases wiki
  • Other Resources:
    • BigAdmin Storage Resource Collection (includes community content)
    • BigAdmin Database Resource Collection (includes community content)
    • Sun Storage web site
    • Storage Stop Blog
  • Support:
    • Sun resources:
      • Register your Sun gear
      • Services
      • SunSolve Online
    • Community system administration experts
  • Events of interest to users of Sun products:
    • Sun and MySQL Around the World--Meetup Mashup
    • Find a MySQL Meetup Group near you
    • Worldwide Developer Events and Sun Tech Days
    • Current Events

  ---

  Comments (latest comments first)

  Discuss and comment on this resource in the BigAdmin Wiki

  ---

  Unless otherwise licensed, code in all technical manuals herein (including articles, FAQs, samples) is provided under this License.