Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Message from discussion galera backups

Received: by 10.205.119.5 with SMTP id fs5mr3194557bkc.7.1333035711260;
        Thu, 29 Mar 2012 08:41:51 -0700 (PDT)
X-BeenThere: codership-team@googlegroups.com
Received: by 10.204.130.2 with SMTP id q2ls1679322bks.9.gmail; Thu, 29 Mar
 2012 08:41:49 -0700 (PDT)
Received: by 10.204.156.202 with SMTP id y10mr498978bkw.1.1333035709844;
        Thu, 29 Mar 2012 08:41:49 -0700 (PDT)
Received: by 10.204.156.202 with SMTP id y10mr498977bkw.1.1333035709831;
        Thu, 29 Mar 2012 08:41:49 -0700 (PDT)
Return-Path: <alexey.yurche...@codership.com>
Received: from mailfw02.zoner.fi (mailfw02.zoner.fi. [84.34.147.249])
        by gmr-mx.google.com with ESMTPS id 8si7889627bka.1.2012.03.29.08.41.49
        (version=TLSv1/SSLv3 cipher=OTHER);
        Thu, 29 Mar 2012 08:41:49 -0700 (PDT)
Received-SPF: neutral (google.com: 84.34.147.249 is neither permitted nor denied by best guess record for domain of alexey.yurche...@codership.com) client-ip=84.34.147.249;
Authentication-Results: gmr-mx.google.com; spf=neutral (google.com: 84.34.147.249 is neither permitted nor denied by best guess record for domain of alexey.yurche...@codership.com) smtp.mail=alexey.yurche...@codership.com
Received: from www15.zoner.fi ([84.34.147.35])
  by wwwsmtp02.zoner.fi with ESMTP; 29 Mar 2012 18:41:49 +0300
Received: from localhost ([127.0.0.1] helo=www.codership.com)
	by www15.zoner.fi with esmtpa (Exim 4.77)
	(envelope-from <alexey.yurche...@codership.com>)
	id 1SDHTx-0006Ry-0w
	for codership-team@googlegroups.com; Thu, 29 Mar 2012 18:41:49 +0300
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Thu, 29 Mar 2012 18:41:48 +0300
From: Alex Yurchenko <alexey.yurche...@codership.com>
To: <codership-team@googlegroups.com>
Subject: Re: [codership-team] galera backups
Organization: Codership Oy
In-Reply-To: <4F743FC202000029000FC3FF@mail.mooreheadcomm.com>
References: <4F743FC202000029000FC3FF@mail.mooreheadcomm.com>
Message-ID: <afdb56d3be0bd09c5b5cdeb1ac32e7ae@codership.com>
X-Sender: alexey.yurche...@codership.com
User-Agent: Roundcube Webmail/0.7.2
X-Antivirus-Scanner: Clean mail though you should still use an Antivirus

On 2012-03-29 17:56, Andy Thompson wrote:
>> Ok.  At that point in time is galera going to do an IST to the
>> joining server to catch it back up then?
>>
>> I guess I've never been real clear on the process that occurs when
>> you have a cluster server down for a restart or maintenance.  Kind 
>> of
>> getting OT but what process does galera go thru to catch a server up
>> in either this or a restart situation?
>
>>1. The joining node sees the gap between its and cluster state and
>>sends state transfer request (STR) to cluster
>
>>2. The donor specified in wsrep_sst_donor, or automatically chosen by
>>cluster, delivers either SST or IST to joiner. In the latter case an
>>empty SST is faked (so you'll see SST messages in log). The choice
>>between SST and IST depends on whether the donor has enough 
>> transactions
>>in gcache. Hence gcache.size option form wsrep_provider_options is
>>important.
>
>
> Ok good information, thanks.  I've left the cache size at the default
> for the time being, I'll wait and see how that goes, probably will
> have to increase it at some point down the road.
>
> Is there any configuration for IST or does it use the SST directive?

Only ist.recv_addr if you want to be specific about the interface IST 
is using (should go into wsrep_provider_options, like anything not 
prefixed with wsrep_). There is a bug about it however: 
wsrep_node_incoming_address seems to override it. So it is sort of 
useless ATM. Will be committing fix to LP tonight.

> I saw a reference somewhere to a listen ore receive address which led
> me to believe there was something specific to IST but I can't recall
> where.  I haven't shut a server down quite yet and looked at the logs
> to see what happens, only added a couple new servers and they got a
> full SST.
>
> thanks
>
> -andy

-- 
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011