You are here
Database backup
With Ops Center you can also do your database backups in a convenient way. In the database operations tab is a button Backup database:
Backup type
First you have to choose the backup type. Those are exactly the same backup types as in the FromDual backup manager. For further information see there:
Backup mode
Next you have to decide if the backup should be done logically (using mysqldump
) or physically (using mysqlbackup
or xtrabackup
):
The backup mode cannot be selected for all backup types.
Backup behavior
Some backups can be done inconsistent. Ops Center (and FromDual Backup Manager) prohibits you from doing invalid backups. If you have some MyISAM tables in your database this backup will be blocking for the whole duration of the backup. If you want to avoid blocking backups use InnoDB storage engine only:
Backup policy
Define the backup policy you want to store your backup in:
Backup directory
Specify where your backup should be written to. This is ideally another device than your database disk. Sometimes NFS mounts are used to write backups to:
FromDual brman location
Ops Center uses in the background FromDual Backup/Recovery Manager to perform the backups. Here you have to specify where on the database server brman is installed. This has to be done before you start with the backup:
After clicking on the Start Backup button Ops Center shows you the command it was sending to the database server. The backup job was not executed directly but sent into the Ops Center job handler. There you can see the actual state of the backup job: