MySQL backup prerequisites¶
Before creating MySQL backups, make sure to:
- Check that Backup Management is enabled and the Backup option is available on the side menu. If Backup Management has been disabled on your instance, go to Configuration > PMM Settings > Advanced Settings, re-enable Backup Management then click Apply changes.
Check that the PMM Client is installed and running on the node.
To enable Xtrabackup for MySQL 8.0+, check that pmm-agent connects to MySQL with a user that has BACKUP_ADMIN privilege.
Check that there is only one MySQL instance running on the node.
Verify that MySQL is running:
as a service via
with the name
mysqld(to confirm, use
systemctl status mysqlor
systemctl status mysqldrespectively);
mysqlsystem user account.
Make sure that there is a
Check that MySQL is using the
/var/lib/mysqldirectory for database storage.
Make sure that
pmm-agenthas read/write permissions to the
Check that the latest versions of the following packages are installed and included in the
xtrabackup, which includes:
The versions of each must be compatible with the installed version of MySQL.
For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or consulting services , contact Percona Sales.