Can I Restore MySQL Without Having MySQL Agent Add-on Installed?
Question:
Can I restore MySQL without having MySQL Agent add-on installed?
Doesn't the Linux Agent take all the backups of a server, which would include MySQL?
Solution:
If you do not have MySQL Agent add-on installed, the MySQL binary files are still backed up by the CDP Server. R1Soft can certainly restore any data file without the MySQL plugin. You can not, however, guarantee the consistency of the raw database files. The MySQL add-on module allows more granular control over restoring specific tables, and also backs up data in RAM.
Without the MySQL add-on
An inconsistent copy of your MySQL databases will be backed up. Raw mysql files can be restored as regular files or along with a complete system image. Raw MySQL files are very likely to be corrupt due to the way MySQL caches pages and changes in memory.
We have added a warning to the latest Agent releases that will warn you if you are backing up a volume that has MySQL databases and no MySQL instance configured on the CDP Server.
With the MySQL add-on
Always consistent and accurate copies of your MySQL databases are backed up for both MyISAM and InnoDB with zero transaction loss or interruption.
You can perform granular restores of individual databases or tables to original or alternate locations.
Read more in MySQL Addon - Why MySQL Backups are Not Safe Without It.