Backup MySQL databases online with minimal disk I/O load and impact using R1Soft's Continuous Data Protection for MySQL.

Key Benefits:

• Online - No interruption to MySQL Databases During Backup
• Supports MySQL on both Windows and Linux Servers
• Central Administration of all MySQL Backups
• Shortest MySQL Backup windows Possible 
• Reduce load on MySQL Databases from Backups
• Improve MySQL Recovery Point Objectives with Hourly Backups
• Backup multiple database instances per physical server
• Flexible Backup Policies: Hourly, Daily, Weekly

Continuous Data Protection

Online Backup - Zero Business Interruption Backups for Even the Busiest MySQL Servers.  Snapshots of databases are typically created in less than a second using proprietary Linux disk Snapshots using the R1Soft CDP device driver on Linux.

Protect MySQL databases on Linux as frequent as every hour using CDP's asynchronous replication backup technology.  Archive up to thousands of recovery points.

Objects Protected and Restored

• Databases
• Tables
• Indexes
• Constraints
• Triggers
• Events
• Views
• Stored Procedures
• Functions

Storage Engines

• MyISAM
• InnoDB / Innobase
• Memory (schema only)
• Archive
• CSV
• Blackhole (schema only)  

Why You Need the CDP for MySQL Addon

When it comes to backups MySQL databases require special handling, and MySQL is no exception. There are a variety of MySQL backup methods available and they all work differently.  The R1Soft CDP for MySQL Add-on integrates Continuous Data Protection® with an online hot backup (snapshot) of MySQL databases to provide fast, efficient and safe MySQL backups.  Both MyISAM and InnoDB storage engines require that tables be locked and flushed before a backup operation can take place. The R1Soft MySQL Add-on ensures that this happens and  carefully coordinates it with the point-in-time file system snapshot.

Linux - MySQL Snapshots are performed by coordinating a brief (usually < 1 second) MySQL LOCK AND FLUSH with the CDP Linux snapshot device driver.

If you use CDP to backup MySQL and don’t use the R1Soft MySQL Add-on then the table lock and flush operation won’t take place – with the result that your MySQL backup will likely be corrupt.

MySQL Enterprise Certified

Certified for MySQL Enterprise.  MySQL Enterprise and Community Releases 5.0 and greater are supported.