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.

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

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

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

5. 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.

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

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

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

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

   • xtrabackup, which includes:

     • xbcloud

     • xbstream

   • [qpress][PERCONA_QPRESS].

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.

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert