Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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:
my.cnfwsrep_sst_method=rsync
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.
