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 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:

Choose backup type

Backup mode

Next you have to decide if the backup should be done logically (using mysqldump) or physically (using mysqlbackup or xtrabackup):

Choose backup mode

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 behavior

Backup policy

Define the backup policy you want to store your backup in:

Backup policy

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:

Backup directory

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:

FromDual brman location

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:

FromDual brman start