New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
PMM cant restore xtradb from backup #2340
Comments
Hi @artemsafiyulin , please check that your setup met required prerequisites described here: https://docs.percona.com/percona-monitoring-and-management/get-started/backup/mysql_prerequisites.html P.S. Please consider that MySQL backups/restores still in technical preview and not ready for use in production. |
@artemgavrilov hi! Yes my setup required all prerequisites from this link. I did not notice that this solution is not ready for use yet. Apparently you will have to create backups in a different way. Thank you for the information! |
@artemsafiyulin We just released PMM v2.38.0 and I see that there was fixed bug that looks similar to yours: https://jira.percona.com/browse/PMM-11645 If you still want to play with PMM Backups you can try new PMM version (fix was done on the pmm-agent side). We will appreciate any feedback. |
@artemgavrilov Hi! I try with new version PMM agent, but get same error:
As i can see in ticket that you attach problem was in getMysqlServiceName function, but in my case problem with jobs.stopMySQL |
Description
I installed test xtradb cluster (5.7 version) using this instruction:
https://docs.percona.com/percona-xtradb-cluster/5.7/overview.html
Install PMM server and pmm agent (on each mysql node), register service from each node, using this instruction:
https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html
Install xtrabackup 2.4 on all mysql nodes using this instruction:
https://docs.percona.com/percona-xtrabackup/2.4/installation/yum_repo.html
now i have next installation:
node01 - xtradb 5.7 / xtrabackup2.4 / pmm-agent2 2.37.1
node02 - xtradb 5.7 / xtrabackup2.4 / pmm-agent2 2.37.1
node03 - xtradb 5.7 / xtrabackup2.4 / pmm-agent2 2.37.1
node 04 - percona/pmm-server:2 in docker
After all preparing i start backup from node01 using web interface. Backup complete without problems. After creating backup i start restore them to node01 using web interface and get error. Web interface dont get information about error. But li /var/log/mesages i see next errors:
I using almalinux 8.7 on all servers. And also settings same solution for backuping mongoDB (the work good).
Can you help me with this problem?
Expected Results
I expect that backup restore correctly.
Actual Results
Backup restore with errors.
Version
node01 - xtradb 5.7 / xtrabackup2.4 / pmm-agent2 2.37.1
node02 - xtradb 5.7 / xtrabackup2.4 / pmm-agent2 2.37.1
node03 - xtradb 5.7 / xtrabackup2.4 / pmm-agent2 2.37.1
node 04 - percona/pmm-server:2 in docker
Steps to reproduce
install xtradb 5.7 cluster with 3 nodes, create backup using PMM web interface, try restore backup
Relevant logs
No response
Code of Conduct
The text was updated successfully, but these errors were encountered: