View Full Version : Backup and recovery benchmarks with ZRM for MySQL

March 21st, 2007, 09:53 AM
Often times we are asked what performance to expect from ZRM for MySQL. That is why recently we measured backup and recovery performance for MyISAM and InnoDB storage engines using various backup methods.

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 <a href="http://network.zmanda.com/register.php">free registration to the Zmanda Network</a>. Here are the important takeaways:
<li>Logical backups and especially recoveries are slow. 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.</li>
<li>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.</li>
<li>In our testing we did not find any significant difference in backup and recovery transfer rates for different sizes of the database.</li>
<li>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.</li> </ul>
That testing was our first step in measuring the performance of ZRM for MySQL when there was no user activity. We understand that DBAs are concerned with backup performance when MySQL is used. Our next step is to measure ZRM performance including conditions with heavy user activity.
Dmitri Joukovski