Skip to content
PERCONA MONITORING AND MANAGEMENT DOCUMENTATION

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

MySQL backup prerequisites

Before creating MySQL backups, make sure to:

  1. Check that Backup Management is enabled and the Backup option is available on the side menu. If Backup Managemt has been disabled on your instance, go to Configuration > PMM Settings > Advanced Settings, re-enable Backup Management then click Apply changes.

!!! caution alert alert-warning “Important” If PMM Server runs as a Docker container, enable backup features at container creation time by adding -e ENABLE_BACKUP_MANAGEMENT=1 to your docker run command.

  1. Check that the PMM Client is installed and running on the node where the backup will be performed.

  2. To enable Xtrabackup for MySQL 8.0+, check that pmm-agent connects to MySQL with a user that has BACKUP_ADMIN privilege.

  3. Check that there is only one MySQL instance running on the node.

  4. Verify that MySQL is running:

    • as a service via systemd;

    • with the name mysql or mysqld (to confirm, use systemctl status mysql or systemctl status mysqld respectively);

    • from a mysql system user account.

  5. Make sure that there is a mysql system group.

  6. Check that MySQL is using the /var/lib/mysql directory for database storage.

  7. Make sure that pmm-agent has read/write permissions to the /var/lib/mysql directory.

  8. Check that the latest versions of the following packages are installed and included in the $PATH environment variable:

Important

Make sure that the versions of xtrabackup, xbcloud, xbstream, and qpress are fully compatible with the currently installed version of MySQL on the system.