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