InnoDB ibbackup

{page-title}{excerpt}Oracle's InnoDB Hot Backup Utility{excerpt}
\\

[Oracle owns|http://www.oracle.com/innodb/index.html] [Innobase|http://www.innodb.com/] which makes the [ibbackup InnoDB command line backup utility|http://www.innodb.com/doc/hot_backup/manual.html].  While ibbackup can do SQL dumps of MyISAM its primary use is InnoDB as it really adds no value for MyISAM over mysqldump. 

h3. How Does ibbackup Work?

The ibbackup utility provides an online backup capability for InnoDB table spaces.  This is a great feature as it means zero business interruption during backups for InnoDB.  You can run ibbackup without shutting off or even locking tables during the backup.  ibbackup works by reading the InnoDB journal log file and table space at a very low level to provide a point-in-time backup of the InnoDB table space while MySQL is writing to the table space. 
\\
\\
| {color:#cc0000}Category{color}\\ | [Online|TP:Categories of MySQL Backup Software]\\ |
| Archive Type | Disk \\ |
| MySQL Storage Engines Supported | InnoDB (only SQL dumps for MyISAM) \\ |
| Supported O/S | All \\ |
| Binlog Backup & Restore | {color:#00cc00}Yes{color} \\ |
| {color:#00cc00}Zero Business Interruption (Online Backups){color} | {color:#00cc00}Yes{color} |
| {color:#cc3300}Granular (Table Level) Restore{color} \\ | {color:#cc3300}No{color} |
| {color:#cc3300}Easy to Use Graphical User Interface{color} \\ | {color:#cc3300}No{color}\\ |
| Complete Server Protection (Backup All Data or just MySQL?) \\ | {color:#cc3300}No{color} |
| Backup Type \\ | [Incremental|TP:Backup Method - Full Backup]\\ |
| {color:#cc3300}Backup Window Length{color} \\ | {color:#cc3300}Long{color} \\ |
| {color:#cc3300}Server Disk I/O and Load Impact{color} \\ | {color:#cc3300}Heavy{color} \\ |
\\