mysqlbackupdatabase-backupsbackup-strategies

How can I backup mysql database with bareos?


What plugin I should use for that?

Can you show me your config from bareos-fd.conf and FileSet section from bareos-dir.conf

Thank you!


Solution

  • It depends, if it's just a small DB, the bpipe plugin is probably the easiest to get started. There's also the Bareos mysql-python plugin, which is more flexible than bpipe, but like bpipe it makes use of mysqldump. So both of them only do full backups. The third option is the newer Bareos MySQL / MariaDB Percona xtrabackup Plugin, which can also do incremental backups of InnoDB tables.

    All Bareos plugins for backing up MySQL/MariaDB are documented at http://doc.bareos.org/master/html/bareos-manual-main-reference.html#BackupOfAMySQLDatabase