Restore a galera cluster on a new host

Comments

3 comments

  • Avatar
    Ashraf Sharif

    Hi Simon,

    The best way to understand what was going on is to examine the MySQL error log of both donor and joiner nodes. However, by making some educated based on your restoration procedures, I can tell that the reason SST happens is because the second Galera node doesn't have information on the "Galera state" it should have been held, since you didn't configure the grastate.dat under MySQL datadir of the joiner node (second node).

    I'd recommend you to look at this blog post, https://severalnines.com/blog/how-avoid-sst-when-adding-new-node-galera-cluster as we described steps to restore a joiner node from a backup, configure proper values inside grastate.dat file to avoid SST when the joiner node joins the cluster for the first time. Take note on step 6, where the backup was taken with "--galera-info" flag and step 8 where we configure the Galera state (UUID and seqno) in grastate.dat.

    Regards,
    Ashraf

  • Avatar
    Simon Tardif

    Thank for your reply, i will look at the post.  I also see the parameter wsrep_sst_auth is not the same user/password for both cluster, so I think it may be a part of the problem too?

  • Avatar
    Simon Tardif

    Finally it worked by changing wsrep_sst_auth.  I red the post about avoiding full sst and it will be very usefull when our database will be bigger and this post made me understand how sst and ist works. Thank you! 

Please sign in to leave a comment.

Powered by Zendesk