syncing data

Follow

john test

• December 08, 2015 00:09

hi there,

I have a situation that after joining a new node to a galera cluster, the data is not being copied to the new node.

What can I do?

Also, if I ever need to do a force push, how can I do this (other than taking a restoring a dump)?

 

Thanks

0

• 

  Ashraf Sharif

  • December 08, 2015 00:52

  Hi John,

  Galera uses State Snapshot Transfer (SST) to get synced for the very first time when joining the cluster. You can use mysqldump, rsync or xtrabackup to perform SST, configurable under wsrep_sst_method parameter (defaults to rsync). Details at http://galeracluster.com/documentation-webpages/statetransfer.html .

  To force for SST, you can just remove grastate.dat, or simply remove all contents inside MySQL data directory. This process is automatically triggered by Galera, provided that you have configured the required parameters correctly.

  Regarding data is not being copied, did you see any error inside MySQL error log? We can assist you if you don't mind to share the content of my.cnf and MySQL error log here (caution this is public forum), otherwise please submit a support ticket at http://support.severalnines.com/tickets/new and attach the files that I mentioned.

   

  Regards,

  Ashraf

  0

  Comment actions Permalink
• 

  john test

  • December 08, 2015 03:30

  Hi Ashraf, Actually I rebuilt the cluster so didn't save the logs, but here is my.cnf if you see something that can be added/optimized would be much appreciated.
  You will also see that this is a geo-distributed cluster from the last line I have included.

  0

  Comment actions Permalink

Please sign in to leave a comment.