Contact Sales

USA: +1-866-221-0634
Canada: +1-866-221-0634

Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447

Japan: 0120-065556
China: 10800-811-0823
India: 0008001005870
Brazil: +55 11 5189-1097

More Countries »

Contact Us Online »

MySQL Enterprise Backup

MySQL Enterprise Edition

Download Now »

Only available in select Commercial Editions

MySQL Enterprise Backup is the ideal solution for backing up MySQL databases.

Backup

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.

Download Whitepaper "MySQL Enterprise Backup - Fast, Consistent, Online Backups" »

Restore

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.

Compression

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.

Features	Benefits
Backup
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
Recovery
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
Advanced Features
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
Storage Engines
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