The MySQL backup tool in Bacula Enterprise Edition is designed to both simplify and accelerate the backup of your MySQL databases. Designed to save your valuable time, the system administrator does not need to know the internals of MySQL DB backup techniques or programming to write complex scripts. This MySQL backup software will automatically backup essential information such as configuration or user definitions. Putting speed and accurate data recovery into the hands of the user, our solution supports both Dump and binary backup of MySQL database and data recovery techniques.
The Point In Time Recovery feature is available for both Dump and Binary. Bacula's MySQL backup tool also backs up vital meta-data information and manages Object filtering during database backup and restore. No special scripting skills are required.
This MySQL backup tool is available on Linux 32 and 64 bits platforms and supports MySQL 4.0.x, 4.1.x, 5.0.x, 5.5.x, 5.6.x.
MySQL Percona module for Bacula Enterprise is a hot backup utility for MySQL-based servers which removes the need to lock your database during the backup.
Percona backup tool uses techniques that ensure consistency of the whole backup. Another advantage is that Bacula's Percona backup software does not require the use of large temporary files.
During restore, databases are restored to a temporary location, then made consistent using the 'Prepare' option on the Percona tools, prior to actually modifying the live database. Rather than doing the 'Prepare' work to make the database consistent at restore time, the 'Prepare' can be done automatically by the module during the backup phase by adding the module option 'prepare' keyword.
Key MySQL Backup Software Benefits
The Bacula Systems' MySQL backup software allows the administrator to choose between Dump (slower and smaller backups) or Binary (faster and larger backups). Our backup tool takes care of the MySQL log files when using the Point In Time Recovery (PITR) feature.
Further help on MySQL Backup Tools and more: