Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Brazil: +55 11 5189-1097
MySQL Enterprise Backup is the ideal solution for backing up MySQL databases.
MySQL Enterprise Backup performs online "Hot", non-blocking backups of your MySQL databases. Full backups can be performed on all InnoDB data, while MySQL is online, without interrupting queries or updates. In addition, incremental backups are supported where only data that has changed from a previous backup is backed up. Also partial backups are supported when only certain tables or tablespaces need to be backed up.
MySQL Enterprise Backup restores your data from a full backup. Consistent Point-in-Time Recovery (PITR) enables DBAs to perform a restore to a specific point in time. Using MySQL backups and binlog, DBAs can also perform fine-grained roll forward recovery to a specific transaction. A partial restore allows recovery of targeted tables or tablespaces. Plus, DBAs can restore backups to a separate location, or create clones for fast replication setup or administration.
MySQL Enterprise Backup supports creating compressed backup files, typically reducing backup size from 70% to over 90% when compared to the size of actual database files, reducing storage and other costs.
|Full backup||A full backup is performed on all InnoDB data|
|Incremental backup||Only data that changed since a previous backup (full or incremental)|
|Partial Backup||A backup of particular tables or tablespaces.|
|Online backup of InnoDB tables||The backup takes place entirely online, without preventing queries or updates|
|Hot and cold backup support||Backups can be performed with MySQL online or offline|
|Full Restore||A full restore can be performed from a full backup of all InnoDB data|
|Consistent Point-in-Time Recovery (PITR)||Perform a recovery and roll forward to a point in time|
|Roll forward recovery||Backups can be rolled to specific transaction for finer grained recovery|
|Partial Restore||Restore of particular tables or tablespaces|
|Restore to a Separate Location||Restore to separate location, create clones for fast replication setup or administration|
|Parallel Operations||Backup, restore, compression/decompression and page checksum validations are performed in parallel via multi-threading ensuring optimal performance during backup and restore operations|
|Compressed backups||Backup of InnoDB files can be compressed saving up to 90% of the storage|
|Non blocking||Backup of InnoDB tables takes place entirely online, without blocking queries or updates|
|Backup specific tablespaces or sets of tables||Improves performance, reduces backup time and lowers IO requirements|
|Corruption Detection||Checks page checksums when copying InnoDB data and log files|
|Task Synchronization||Allows point-in-time task synchronization of other tasks with backup|
|Only backs up actual data||Does not copy unused blocks. Fewer reads and writes on backup and recovery, backup file use less space|
|Easy installation||Simple to install and deploy across the enterprise|
|High performance||Backup time is comparable to file copy, applying logs for recovery is even faster|
|Unlimited database size||Scalable, works well for small to very large databases|
|Runs outside MySQL process space||Eliminates risk and increases performance by running as a separate process outside the MySQL process space. MySQL Enterprise Backup does not install any additional databases, DLLs, scripts, stored procedures or tables on the MySQL instances|
|Scriptable Interface||Command Line Interface enables you easily integrate within various scheduling systems|
|Backup for Multiple Storage Engines and Formats||InnoDB, MyISAM, Merge, Partition, Archive|
|Backup for MyISAM tables||While the MyISAM tables are being copied, users can read MyISAM tables, but cannot modify them|