Archive for the ‘Paddy Sreenivasan’ Category

Amanda 2.5.2 community release

Thursday, May 3rd, 2007

The Amanda core team is pleased to announce the release of Amanda 2.5.2.
Thanks to everyone who reported bugs in the beta release and submitted patches.

Amanda 2.5.2 packages for Linux and Windows are available in Zmanda downloads page.

Amanda 2.5.2 feature list, documentation and man pages are available in Amanda wiki.

If you have Amanda questions or in general, backup/recovery questions, please use Amanda forums. Amanda developers and users provide answers when possible.

If you are interested in Enterprise version of Amanda, take a look at Zmanda Network (free registration) or contact

MySQL Users conference: ZRM for MySQL – Vision and Roadmap

Friday, April 27th, 2007

Thanks to everyone who attended the talk in person.

The slides used in the talk is available at ZRM for MySQL wiki

If you have questions or comments, please send them to me.

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.

Talking at Scale 5X – Southern California Linux expo

Friday, February 9th, 2007

I will be talking about backup and recovery of Web applications at SCALE 5x. Characteristics of Web applications create unique requirements for backup and recovery. The talk will discuss open source backup and recovery tools for file systems, MySQL and PostgreSQL databases. Conference guru blog provides more information on my session.

I would be happy to meet folks who are interested in Amanda, ZRM for MySQL and open source backups in general before or after the session.

Amanda community version 2.5.1p3 released

Thursday, February 8th, 2007

Amanda community release 2.5.1p3 contains minor features and fixes for more than 50 bugs. We at Zmanda did extensive testing and made code contributions to the release. We provide Amanda packages for various Linux distributions and Windows in our downloads page.

We have made changes to Amanda client for Windows to support localized versions of Windows. With help of Amanda community, we tested Windows client on German and Polish versions of Windows XP. Thanks to all users who helped us in this effort.

If you are not using Amanda, try 2.5.1p3. Documentation is available in Amanda wiki and feel free to ask questions in the forums.

ZRM for MySQL 1.1.4 released

Tuesday, January 30th, 2007
Version 1.1.4 of Zmanda Recovery Manager (ZRM) for MySQL, a robust and
intelligent solution for backup and recovery of MySQL databases is available
for download at Zmanda downloads page.
Changes since 1.1.3 release:
* Support for aborting backup runs
* Support for character sets and stored routines
* Bug fixes
Take a look at ZRM for MySQL user documentation for more information on how to install and configure it.
Find bugs and report them at bugzilla ( Feel free to contribute to ZRM for MySQL wiki and forums.

Knoppix and Amanda

Tuesday, January 23rd, 2007

Knoppix is one of the popular live distributions that can be used in a bare metal recovery situation. Extensive hardware detection support in Knoppix allows for recovery of variety of Windows and Linux systems. Knoppix has complete graphical environment (KDE) and very good networking support.

Knoppix includes system repair tools to partition disks, create filesystems and restore data from backup. Amanda client on the Knoppix CD makes it easy to browse and restore the data files from the system backup. Amanda tool – amrestore allows users to recover files if the Amanda indexes are no longer available.

Latest version of Knoppix (5.1) CD and DVD includes Amanda 2.5.1p1 server and client. The Knoppix CD with latest version of Amanda makes it convenient to recover Windows or Linux system completely.

ZRM for MySQL users manual Updated

Monday, January 8th, 2007

ZRM for MySQL users manual has been rewritten based on user feedback. It is available at ZRM for MySQL wiki

Thanks to everyone who provided feedback. User contributions to the manual are welcome.

ZRM for MySQL 1.1.3 released

Tuesday, December 19th, 2006

Version 1.1.3 of Zmanda Recovery Manager (ZRM) for MySQL, an enterprise solution for backup and recovery of MySQL databases is available for download at Zmanda downloads page.

Changes since 1.1.2 release:
* Supports Ubuntu Edgy (6.10) release
* Works with MySQL enterprise 5.0
* User configuration for custom plugins
* Bug fixes

Documentation is available in ZRM for MySQL wiki. Please use forums to provide feedback on the release.

Thanks to all users for providing valuable feedback as well as finding bugs in earlier
releases 🙂

Detecting malicious database activity

Wednesday, December 6th, 2006

I was talking to a customer yesterday and the customer was surprised that database backups can be used to detect malicious database activity from legitimate users and hackers.

ZRM for MySQL stores MySQL binary logs as part of the database backups. The binary logs provide a good audit trail of all database activity. ZRM for MySQL binary log parsing capability, usually used for selective point in time recovery, can also be used to detect malicious database activity using SQL inspection.

ZRM for MySQL plugin interface allows DBAs to write log parser plugin scripts to track the database activity that they are interested in. For example: the following script can be used to detect deletion of data from the PRODUCTS table in the database. This script prints all instances of deletion from PRODUCTS table.

@fields = split ( / \| /, $ARGV[0] );


if (($fields[3] == “Query”) && \
( $fields[4] =~ /$SQL_VERB *FROM.*`$TABLE_NAME`/ )) {
print “$fields[2] $fields[4]\n”;

The mysql-zrm command can be used to run the customized plugin script for all backups or a specific backup image. The following command looks for deletion from PRODUCTS table on a backup image dated Dec 5, 2006.

# mysql-zrm –action parse-binlogs \
–source-directory /var/lib/mysql-zrm/pricebook/20061205142103 \
–parse-binlogs-plugin /usr/share/mysql-zrm/plugins/

The output of the command will contain valid deletions as well as malicious database deletions.

Yet another use for ZRM of MySQL.