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 innobackupex streaming not working

Received: by 10.216.137.196 with SMTP id y46mr697134wei.7.1334574600669;
        Mon, 16 Apr 2012 04:10:00 -0700 (PDT)
X-BeenThere: percona-discussion@googlegroups.com
Received: by 10.216.199.206 with SMTP id x56ls7441705wen.3.gmail; Mon, 16 Apr
 2012 04:09:58 -0700 (PDT)
Received: by 10.180.8.137 with SMTP id r9mr1457778wia.2.1334574598909;
        Mon, 16 Apr 2012 04:09:58 -0700 (PDT)
Received: by 10.180.8.137 with SMTP id r9mr1457777wia.2.1334574598899;
        Mon, 16 Apr 2012 04:09:58 -0700 (PDT)
Return-Path: <djunt...@gmail.com>
Received: from mail-wg0-f49.google.com (mail-wg0-f49.google.com [74.125.82.49])
        by gmr-mx.google.com with ESMTPS id ef4si3262871wib.1.2012.04.16.04.09.58
        (version=TLSv1/SSLv3 cipher=OTHER);
        Mon, 16 Apr 2012 04:09:58 -0700 (PDT)
Received-SPF: pass (google.com: domain of djunt...@gmail.com designates 74.125.82.49 as permitted sender) client-ip=74.125.82.49;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of djunt...@gmail.com designates 74.125.82.49 as permitted sender) smtp.mail=djunt...@gmail.com; dkim=pass header...@gmail.com
Received: by wgbdr1 with SMTP id dr1so4646705wgb.6
        for <percona-discussion@googlegroups.com>; Mon, 16 Apr 2012 04:09:58 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        bh=joHwDn9PPXIWQo5T0SpHdKR0pvXlDqCbYkJRi7/f8p4=;
        b=d0lsG3xZFUAu6X6fPuF4SA/sZcQM5sdXCUTblw24O6aM5xwDBpsSPiXY03AMdNiDkO
         Vd+El1h8pJuUpPPJYgQ9a1yFFMO0hPjxykQf7Bi0FQGEIJGXWx1oBFBZ83TpNLNXq5aq
         KimDrD9x7MdfrR/qVLEkx+BysbjfvhvCrUTiXDpAe8u5Zsvr3UuRSZ2t1DL9FzPbfrY5
         p0OV1mWXItmStSO0wNB/mi+qZkRRwYq9v+ukI8+LjbiqsntVwgf7wl7hBx8sO4yZTIxl
         9WHR5WwzMdZGr1bLKMYcugfx2SO4P0svnPcYPtQIsWk9HKcS73g3y2jplbOf8ZrM3D0b
         CBVA==
MIME-Version: 1.0
Received: by 10.180.95.74 with SMTP id di10mr15829115wib.1.1334574598645; Mon,
 16 Apr 2012 04:09:58 -0700 (PDT)
Received: by 10.223.156.139 with HTTP; Mon, 16 Apr 2012 04:09:58 -0700 (PDT)
In-Reply-To: <d776a7d7-154b-4c9e-b09f-0141f4a96...@w5g2000vbv.googlegroups.com>
References: <b73ea90c-bc0e-4fd1-998f-745212339...@s7g2000yqm.googlegroups.com>
	<CAM2vrmTN3MjWKkm0HJnL81-2Pg=F_nvZe8B4DXXAhuTUND0...@mail.gmail.com>
	<d776a7d7-154b-4c9e-b09f-0141f4a96...@w5g2000vbv.googlegroups.com>
Date: Mon, 16 Apr 2012 04:09:58 -0700
Message-ID: <CAM2vrmQXK1D5y1=FFYW5xuzLEN_k5MDfkPj2mpWvqvV1=9M...@mail.gmail.com>
Subject: Re: innobackupex streaming not working
From: David Juntgen <djunt...@gmail.com>
To: percona-discussion@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

> from some reason if i stop/start the process a few times it start to
> work, but since i need to do this process often and i need to find out
> whats not working there

Hi - You'll need to provide some info.  What version of MySQL and
which version of xtrabackup are you using?  Can you run without the
pipe from the cli and provide its output?

--Dave

On Sun, Apr 15, 2012 at 12:25 AM, Ran Margaliot <r...@gr8ppl.com> wrote:
> from some reason if i stop/start the process a few times it start to
> work, but since i need to do this process often and i need to find out
> whats not working there
>
> On Apr 14, 3:56=A0pm, David Juntgen <djunt...@gmail.com> wrote:
>> Hi - If you remove the pipe "|" into sshpass and dump to a file does it =
work?
>>
>> Thanks,
>>
>> --Dave
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Sat, Apr 14, 2012 at 5:40 AM, Ran Margaliot <r...@gr8ppl.com> wrote:
>> > Hello,
>>
>> > When i need to setup a new slave I issue the flowing script on the
>> > master:
>>
>> > innobackupex --user=3Droot --password=3D'*****' --throttle=3D15 --
>> > stream=3Dtar /tmp/ --slave-info | sshpass -p '****' ssh root@<new slav=
e
>> > ip> "tar xfi - -C /var/lib/mysql"
>>
>> > usually this command works fine and streams the data to the new slave.
>>
>> > from some reason, when I issue this command now, I get the following
>> > output:
>>
>> > xtrabackup: suspend-at-end is enabled.
>> > xtrabackup: uses posix_fadvise().
>> > xtrabackup: cd to /var/lib/mysql
>> > xtrabackup: Target instance is assumed as followings.
>> > xtrabackup: =A0 innodb_data_home_dir =3D ./
>> > xtrabackup: =A0 innodb_data_file_path =3D ibdata1:10M:autoextend
>> > xtrabackup: =A0 innodb_log_group_home_dir =3D ./
>> > xtrabackup: =A0 innodb_log_files_in_group =3D 2
>> > xtrabackup: =A0 innodb_log_file_size =3D 1310720000
>> > xtrabackup: use O_DIRECT
>> > xtrabackup: Stream mode.
>>
>> > and thats it, normally it would display: "log scanned up to
>> > (... ...........)" every couple of seconds.
>>
>> > looking at the size of the mysql dir on the slave also suggest that no
>> > data is coming in.
>>
>> > any ideas why?
>>
>> > --
>> > You received this message because you are subscribed to the Google Gro=
ups "Percona Discussion" group.
>> > To post to this group, send email to percona-discuss...@googlegroups.c=
om.
>> > To unsubscribe from this group, send email to percona-discussion+unsub=
scribe@googlegroups.com.
>> > For more options, visit this group athttp://groups.google.com/group/pe=
rcona-discussion?hl=3Den.
>>
>> --
>> David W. Juntgen
>
> --
> You received this message because you are subscribed to the Google Groups=
 "Percona Discussion" group.
> To post to this group, send email to percona-discussion@googlegroups.com.
> To unsubscribe from this group, send email to percona-discussion+unsubscr=
ibe@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/perc=
ona-discussion?hl=3Den.
>



--=20
David W. Juntgen