Archive for October, 2008

New version of ZRM expands platform coverage, adds backup of application files

Tuesday, October 21st, 2008

Today we released version 3.0 of Zmanda Recovery Manger for MySQL. Here are the highlights of the release.

The new version of ZRM supports Zmanda Management Console (ZMC) running on 32- and 64-bit Ubuntu and Debian. We received quite a few requests for providing such support in the past.

In addition to Linux and Solaris, the ZRM server can now run on Windows. We supported logical and VSS-based backup for MySQL on Windows for a long time, but sometimes it was a challenge to introduce ZRM running on Linux/Solaris to all-Windows shops. Based on feedback from customers, prospects and from our partner MySQL, we have developed the version of ZRM that can protect MySQL in all-Windows environments.

We expanded the number of supported snapshot technologies by adding EMC CLARiiON SnapView to the list. This mid-range storage array is a staple for many data centers. Now the users who run MySQL on CLARiiON, will be able to take advantage of very fast and space-efficient snapshot capabilities of SnapView.

Lastly, based on requests of many users, the new version of ZRM provides the capability of doing backup of files at the same time as backup of MySQL database. For example, you can backup the directory and configuration files of application that is powered by MySQL. That simplifies recovery of a database and the application that uses MySQL.
Dmitri Joukovski

Three C of Oracle backup: Cost, Complexity and Control

Wednesday, October 1st, 2008

Backup continues to be a challenge for Oracle DBAs. That message was repeated again and again by attendees of OracleWorld in San Francisco last week.

The DBAs consistently bring up three challenges of Oracle backup: Cost, Complexity and Control

For many organizations the Oracle modules for Veritas NetBackup and Legato NetWorker are out of reach because of high cost. According to Sun ’s online store, the list price for NetBackup Oracle module running on a Solaris server with 2 CPUs is $7,500. What if you have multiple Oracle servers to backup? This can add up very quickly.

To avoid paying unreasonable licensing and maintenance fees for NetBackup and Legato, many DBAs write their own RMAN scripts. RMAN is a well documented tool and it seems relatively easy to write a few lines to schedule backup of a single database. However, over time the script gets more complicated, configurations and requirements change, a DBA who wrote the original script gets promoted and moves to another group … and you are stuck trying to figure out when was the last successful backup and how to get your data back.

Who do you depend on to get your data back? In most organizations the roles of DBA and backup administrators are separate. You, as a DBA are paid to protect Oracle data, but often times you have to ask the backup guys to get your data back. The lack of control could be even worse. As soon as your organization starts using NetBackup (or any other backup that keeps data in proprietary formats), your data becomes hostage to Veritas software. You can never recover your own Oracle or any other backups unless you continue paying Veritas.

If you face any of the challenges above, check out Amanda Enterprise for backup of Oracle. For a low cost you will get an easy to use solution that provides you with a full control over Oracle backups and recoveries.

Amanda Backup to Tape Library

Wednesday, October 1st, 2008

Over the years Amanda has added lots of media choices to store backup archives: SAN, NAS, Amazon S3 etc. But tapes remain one of the most popular destination. Gavin, who blogs under a to-the-point title “I Do Linux”, has written a detailed how-to on installing and configuring Amanda with Tape Libraries. He has two setups: One setup (which backs up over a terabyte of Maildir for 3000 users) has Amanda backing up to a Spectra Logic T50 LTO2 tape library, containing 5 magazines/terapacks and 50 tape slots. Second setup (which backs up 4TB of research data for over 100 users) has Amanda backup archives going to a Dell PowerVault TL2000 LTO4 tape library, containing 2 magazines and 23 tape slots.