surrogate
surrogate copied to clipboard
Restore failing with galera cluster
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?
You must provide more data, add "set -x" to any of scripts and paste here results