Skip to content
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

Restore failing with galera cluster #26

Open
shakisha opened this issue Apr 12, 2016 · 1 comment
Open

Restore failing with galera cluster #26

shakisha opened this issue Apr 12, 2016 · 1 comment

Comments

@shakisha
Copy link

I have succesfully done a backup, but when i run "surrogate -r" i have got these messages
´´´´

restoring backup
copying full backup files: /data/backups/daily/Tue/full_2016-04-12_1605
preparing full backup...
160412 16:18:43 completed OK!
applying Logs
check if the apply log completed successfully
160412 16:18:47 completed OK!
stop mysql...
Shutting down MySQL.... SUCCESS!
moving mysql data files...
restoring data files...
calling innobackupex...
delete all log files to start fresh after restore
setting file permissions...
restoration almost complete, starting mysql...
Starting MySQL.............................................................. ERROR!
Restore Completed OK!

´´´´

Mysql failed to start because of replication enabled and i have changed firewall rules to make mysql fail to connect to the other nodes for avoid data loss to the other masters.

Surrogate is telling me that the restore is completed, but after starting mysql in secure way and showing databases, it still shows 3 databases instead of 5 (when i have made the backup i was having 5 databases).

What can i do more?

@ser
Copy link

ser commented Dec 29, 2016

You must provide more data, add "set -x" to any of scripts and paste here results

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants