The purpose of this manual is to provide you with complete instructions on how to use the CDP for MySQL Add-On.
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. The R1Soft MySQL Add-On ensures that tables be locked and flushed before a backup operation can take place. MySQL Add-On coordinates with the point-in-time file system snapshot.
The MySQL Add-On requires you to specify a MySQL account with administrative privileges that is used by the Agent to flush tables with read lock before the file system snapshot is taken. And the lock must be held until the snapshot completes.
If you use CDP to backup MySQL and do not use the R1Soft Databases Add-On, then the table lock and flush operation will not take place and your MySQL backup may likely be corrupt.
With Version 3.18, you need to do the following to backup your MySQL database:
The following steps should be taken to restore your MySQL: Restoring a MySQL Database.
In order to back up and restore MySQL databases using the CDP for MySQL interface, first you need to install either a Windows or Linux CDP Enterprise Edition 3.6.2 or higher and either a Windows or Linux CDP Agent 3.6.2 or higher on the server where your MySQL databases resides.
All previous versions of CDP do not include the CDP for MySQL Add-On.
|Page: Error - InnoDB Restore Fails to Prepare MySQL Instance (Knowledge Base)|