Fast, Reliable, Proven transactional storage for MySQL

Hot Backup Features

InnoDB Hot Backup allows you to backup a running MySQL database, including InnoDB and MyISAM tables, with minimal disruption to operations. In addition, InnoDB Hot Backup supports creating compressed backup files, and performing backups of subsets of InnoDB tables. In conjunction MySQL’s binlog, users can perform point in time recovery.
  • Online backup of InnoDB tables — the backup takes place entirely online, without preventing queries or updates.
  • Online backup of MyISAM tables — during the backup of InnoDB tables, read and write access is permitted to MyISAM tables. While the MyISAM tables are being copied, updates (but not reads) to the MyISAM tables are precluded.
  • Compressed backups — the backup of InnoDB files can be compressed at various levels, saving as much as 70% or more of the storage required.
  • Partial backups — you can selectively backup all or only some of your InnoDB tables.
  • High performance — backup time is comparable to file copy, applying logs for recovery is even faster.
  • Unlimited database size — no practical limit to database size or number of tables.
  • Broad platform support — runs on Linux, Windows and leading Unix platforms.

Compatibility

InnoDB Hot Backup versions support MySQL versions 4.0, 4.1 and 5.0 (and soon 5.1). InnoDB Hot Backup is available for a wide range of hardware and software platforms including Windows, Linux and Unix. NOTE: InnoDB Hot Backup uses a Perl script to automate the procedure of backing up both MyISAM and InnoDB tables. This script (innobackup) is not available on Windows. However, the procedure can be performed using manual (or scripted) steps in combination with the ibbackup utility. See sections 2.3 and 5.0 of the InnoDB Hot Backup manual.

Read more

InnoDB Hot Backup 3.0
Compatible with MySQL/InnoDB up to version 5.0 (possibly 5.1)
  • Microsoft Windows (except for the innobackup Perl script)
  • GNU/Linux on i386, AMD64 (x86_64, EM64T), and PowerPC
  • FreeBSD 5.x on i386
  • HP-UX 11 on PA-RISC 1.1
  • IBM AIX 4.3 and 5.2
  • Sun Solaris 8 and 10 on 32-bit SPARC (works also on Solaris 9)
  • Sun Solaris 10 on 64-bit SPARC (the 32-bit SPARC version should work also on 64-bit SPARC systems)
  • Sun Solaris 10 on i386
  • Sun Solaris 10 on AMD64
InnoDB Hot Backup 2.0
Compatible with MySQL/InnoDB up to version 4.1
  • Apple Mac OS X on PowerPC
  • FreeBSD 4.x on i386
  • GNU/Linux on IA-64
InnoDB Hot Backup 1.40
Compatible with MySQL/InnoDB up to version 4.0
  • HP-UX 10.20 on PA-RISC1.1