I would like to migrate 700GB data to galera cluster(2node+1arbitrator). I found that IST is the best method for huge DBs.So how to forecfully change the replication from SST to IST in Galera Config.

Configured sst method:




1 Answer 1


This is not the whole truth. It is not about SST vs. IST it is about SST followed by an IST.

SST is a full sync, IST is an incremental sync between 2 nodes.

Sometimes you have to use an SST. For example, when you sync your second Galera node with the first one the first time. Later on, when both nodes have the full data set and you take out one node and bring it in again, Galera will choose if IST is possible and if not choose SST.

You can force an SST in favour of IST but not the other way around.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.