Not the answer you need?
Register and ask your own question!

SST and async slaves

mrkamelmrkamel EntrantInactive User Role Beginner
Hi,

i'd like to know if i have to rebuild the async slaves from scratch (stop slave, create dump, load dump, ...) of a pxc node (5.6.15-25.5-759.wheezy) in case the pxc node performs an SST (xtrabackup-v2), e.g. after a crash or long downtime ? As it seems that SST does not transfer the binlogs, the binlogs can't be consistent with the rest (i.e. the state transferred by SST) after the SST has finished, because the state transfer probably includes intermediate changes, which are then missing in the binlogs.

Thanks for your help

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    If async master node indeed needs full SST for some reason, then it means it got out of sync with cluster probably, hence it may be no longer reliable source of data for async slave. The easiest solution would be using PXC 5.6 and GTID enabled binlogs, so when async master node has problems - you just switch to another node also having GTID binlogs enabled.
    http://www.percona.com/blog/2014/02/...sing-5-6-gtid/
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.