CDP Quick Tip #2 – MySQL Add-on: Why MySQL Backups are NOT Safe Without It

Posted by R1Soft on Feb 5, 2010 11:00:00 AM

Here’s a quick tip from the Head GEEK to help you ensure safe, fast online backup and zero business interruption for your MySQL database servers.

When it comes to backups 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.

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 may very likely be corrupt!

Tip KB article can be found here.

Have questions about our High-Performance CDP products? Just email headgeek (at) r1soft (dot) com

Topics: Continuous Data Protection, mysql, Backups, CDP Quick Tips, R1Soft

Recent Posts

Posts by Topic

see all