Hi Bertrand,

You don't want your partitioned node to do SST, because IST is obviously faster.

IST should always happen, unless the node has lost state (crash, inconsistent data, etc) or the latest writeset is not found in the galera cache.

So, rule of thumb is to have a galera cache big enough, so it can hold the latest writesets while your node is partitioned.

Galera cache (the name is a bit misleading, it's more like a binary log) is just a file on disk, so the limitation is about disk space only.

Set it like this: wsrep_provider_options="gcache.size=5G"

About xtrabackup methods. the legacy xtrabackup method should not be used anymore, as it is deprecated because of many bugs/issue.

Use xtrabackup-v2 in all cases. You can improve the method by setting some [xtrabackup] options in your my.cnf file, such as:

# Enables compression, requires qpress package
compress
# Enables parallel transfers (n=number of threads)
parallel=n

xtrabackup-v2 method does not lock the donor database while it is processing, so it can be used for "hot" SST (on the contrary, rsync needs a global lock)

Regards,

On Sat, Dec 5, 2015 at 2:46 PM Bertrand Caplet <bertrand.caplet@chunkz.net> wrote:

Hi all,
I'm using MariaDB Cluster with 3 servers and I often have split brain
because of network. When a network split brain happen, only one node is
disconnected.
What is for you the best choice for SST or maybe IST method for this
configuration ? (N.B.: I already tried rsync method but i'm not really
satisfied with it).

I have another question, I tried xtrabackup-v2 but it seems this method
can't be use for bootstrapping while database is on. Does xtrabackup
method can do this ?

Regards,

--
CHUNKZ.NET - script kiddie and computer technician
Bertrand Caplet, Flers (FR)
Feel free to send encrypted/signed messages
Key ID: 37F70C30
GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp