Re: [Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster

2015-12-05 Thread Tom Worster
Hi Guillaume, Yes, it helps. Thanks! I can log these every hour (say) and plot the curve over a week to get an idea of rate and its variability. Tom From: Guillaume Lefranc Date: Saturday, December 5, 2015 at 12:57 PM To: Tom Worster , Bertrand Caplet , maria-discuss email list Subject: Re

Re: [Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster

2015-12-05 Thread Guillaume Lefranc
Hi Tom, Use the wsrep_replicated_bytes and wsrep_received_bytes status variables. The sum of those two variables will give you the total bytes written to gcache. By using a derivative function you should be able to figure out the write rate. Hope this helps, On Sat, Dec 5, 2015 at 6:46 PM Tom Wo

Re: [Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster

2015-12-05 Thread Tom Worster
Hi Guillaume, What variable(s) should we monitor to estimate the rate at which gcache is written? or to otherwise estimate how far back a given gcache.size goes in history? Tom From: Maria-discuss on behalf of Guillaume Lefranc Date: Saturday, December 5, 2015 at 10:23 AM To: Bertrand Capl

Re: [Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster

2015-12-05 Thread Guillaume Lefranc
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

[Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster

2015-12-05 Thread Bertrand Caplet
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 re