Amanda backup

Amanda has a free open source community edition backup program and a commercial edition for enterprise backups. Amanda is produced by Zamanda, who sell the commercial versions. Comparing the free community edition to the commercial version, one of the things I need in a backup is available only in the commercial version, removing Amanda from consideration.

Amanda has client packages to backup several popular operating systems but the Windows version goes back only to XP, not Windows 2000, excluding a huge number of working Windows systems. I recently updated the last of my Windows 2000 machines to Linux, bringing Amanda back into consideration.

You can administer Amanda within Webmin using an add on module downloaded separately or by the commercial version of Amanda with a Web based management application included. My uses do not justify the expense of the commercial version. My attempts at using Webmin a couple of years ago made the Webmin approach too difficult. Webmin is now a nicer product. If the Amanda plugin for Webmin is also good, I will look at the combination next time I need to implement a backup.

One advantage of Amanda is the files are backed up using an open compressed file format and your operating system might be able to browse the compressed files, plus perform searches, without Amanda. If Amanda fails, you should be able to access all your files. There is also an encryption system for storing files on external servers and clouds. You would have to carefully test the combination of compression and encryption to see what you can access without Amanda.

Web management

A disadvantage of Amanda is their move towards using Perl. They use mostly C code for fast efficient operation and use a little bit of Perl for some new features. Instead of replacing the existing Perl code with C, they are going in the reverse direction. Their new direction is better than using Java but not a lot better. Most Linux distributions install Perl.

The real test will be their Web interface. If the Web interface is based on Perl instead of PHP, integration with Web management tools will be limited. Zamanda probably use Perl for the Zamanda commercial version because it is the same developers. The Webmin version might use PHP because PHP is the logical choice but they might also use Perl because a lot of those administration tools are just pretty front ends for Perl scripts. You will have to test for reliability. When you decide you want to add one extra feature, you will have to see what sort of code they use. I will be looking at the Webmin Amanda plugin for a project next year.

Database backup

The commercial version of Amanda has hot backups for Oracle but no mention of MySQL or PostgreSQL. I need hot backups of both so databases can be backed up without stopping applications and the backup, when restored, has to produce a database in a known state. A hot backup requires a database that can keep tract of the status of all transactions until the backup is complete.

PostgreSQL supports that type of action. The latest, or next, version of MySQL is supposed to support that. Amanda needs that feature in the free open version for both MySQL and PostgreSQL.

Conclusion

Amanda has the right features for an environment including a mixture of operating systems, provided the backup is to Linux or Unix. You will need either the commercial version or the Webmin version for easy management.