Archive for March, 2007

Backup and recovery benchmarks with Zmanda Recovery Manager for MySQL

Tuesday, March 20th, 2007

The MySQL database has become the world’s most popular open source database because of its fast performance, high reliability and ease of use. The DBAs expect the same virtues from a backup solution for MySQL. Often times we are asked what performance to expect from Zmanda Recovery Manager (ZRM) for MySQL. That is why recently we measured backup and recovery performance for MyISAM and InnoDB storage engines using various backup methods available with ZRM.

In our testing we used MySQL 5.0 running Netflix databases available as part of Netflix Prize project. Our 2-way Red Hat Enterprise 4 server with 4 GB of memory was able to copy large files with an average transfer rate of 37 Mb/s.

All details and results are described in a white paper available with a free registration to the Zmanda Network. Here are the important takeaways:

  • Logical backups and especially recoveries are slo-o-o-o-w. For MyISAM storage engine the transfer rate for backup was 5 MB/s and only 2 MB/s for recovery. Backup of InnoDB was only slightly faster.
  • Raw backups and recoveries are much faster than logical ones. For example, for MyISAM the transfer rate was 25 MB/s for raw backup and 40 MB/s for recovery.
  • In our testing we did not find any significant difference in backup and recovery transfer rates for different sizes of the database.
  • The READLOCK time is the shortest with raw backups done via LVM snapshots managed by ZRM. The shorter the READLOCK time the better for an application and users.

That testing was our first step in measuring the performance of ZRM for MySQL when there was no user activity. We do understand that DBAs are concerned with backup performance when MySQL is used. That is why we will continue to measure ZRM performance including conditions with heavy user activity.
Dmitri Joukovski

Webinar: Zmanda Management Console for Amanda

Thursday, March 15th, 2007

Event Information

Zmanda Management Console for Amanda Enterprise Edition

Date and Time:
Thursday, March 22, 2007 10:00 am
Pacific Daylight Time (GMT -07:00, San Francisco)

Panelist(s) Info:
Shailen Patel – Professional Services Engineer,
Dmitri Joukovski – VP of Product Management,
Ram “TK” Krishnamurthy – VP of Services and Support

Duration: 1 hour

The recently released Amanda Enterprise Edition 2.6, contains Zmanda Management Console [ZMC]. ZMC is a web-based services that is integrated with the Zmanda Network. This release also includes Amanda Rapid Installer, a very simple and easy to use installation mechanism that installs MySQL, PHP, Apache and all other pre-requisites for ZMC. In this webinar, we will introduce to you ZMC and provide a live demo of using ZMC to configure and restore backups.

Amanda Rapid Installer

Friday, March 2nd, 2007

Two days ago, we announced Amanda Enterprise Edition 2.6. One of the
key features of the release is Zmanda Management Console – a simple,
secure and easy to use interface for Amanda. Zmanda Management Console
allows users to configure and administer Amanda backups, restore from
Amanda backup archives, and provides reports.

In addition to Zmanda Management Console, Amanda Enterprise Edition
2.6 includes Amanda Rapid Installer. Amanda Rapid Installer makes the
installation of Amanda Enterprise Edition and Zmanda Management
Console a simple process. Users just need to download the common binary for all
supported platforms from the Zmanda Network, run the installer, answer
few questions, and the installer launches Zmanda Management Console in
a browser.

Amanda Rapid Installer installs all necessary dependencies
such as Apache, MySQL, PHP, Perl for the platform and does not impact
any existing installations of these software. We used BitRock‘s stack and
expertise to develop the Rapid Installer.

Amanda Rapid Installer is one of the key tools in our goal to make all
aspects of Amanda use simpler. For a demo of Amanda Rapid Installer, click here.