Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of ailinykh@gmail.com designates
 209.85.215.48 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <loom.20131213T153112-417@post.gmane.org>
References: <loom.20131213T153112-417@post.gmane.org>
Date: Fri, 13 Dec 2013 09:34:43 -0800
Message-ID: 
 <CAK0tFt5+iGndnXvwh3XTYDv=WBFhpurYFdPvW0oxhKYeVKxSKw@mail.gmail.com>
Subject: Re: Restore with archive commitlog
From: Andrey Ilinykh <ailinykh@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a1134609ca7371b04ed6de014

--001a1134609ca7371b04ed6de014
Content-Type: text/plain; charset=ISO-8859-1

As someone told you this feature was added by Netflix to work with Priam
(cassandra management tool). Priam itself uses it for several months only,
so I doubt if anybody uses this feature in production. Any way, you can
ping guys working on Priam. This is your best bet.
https://github.com/Netflix/Priam

Let us know if you can figure out how to use it.

Thank you,
  Andrey


On Fri, Dec 13, 2013 at 6:31 AM, Bonnet Jonathan. <
jonathan.bonnet@externe.bnpparibas.com> wrote:

> Hello,
>
>   As i told you i began to explore restore operations, see my config for
> archive commit logs:
>
> archive_command=/bin/bash /produits/cassandra/scripts/cassandra-archive.sh
> %path %name
>
> restore_command=/bin/bash /produits/cassandra/scripts/cassandra-restore.sh
> %from %to
>
> restore_directories=/produits/cassandra/cassandra_data/archived_commit
>
> restore_point_in_time=2013:12:11 17:00:00
>
> My 2 scripts
>
> cassandra-archive.sh:
>
> bzip2 --best -k $1
> mv $1.bz2 /produits/cassandra/cassandra_data/archived_commit/$2.bz2
>
>
> cassandra-restore.sh:
> cp -f $1 $2
> bzip2 -d $2
>
>
>
> For an example, at 2013:12:11 17:30:00 i had truncate a table which belong
> to a keyspace with no replication on one node, after that i made a nodetool
> flush. So when i restore to 2013:12:11 17:00:00 i expect to have my table
> bein fill up again.
>
> The node restart with this config correctly, i see my archive commit log
> come back to my commitlogdirectory, seems bizarre to me that these ones
> finish by *.out like CommitLog-3-1386927339271.log.out and not just .log.
> Everything is normal ?
>
> When i query my table now, this one is still empty. Finaly my restore
> doesn't work and i wonder why ?
>
> Do i have to make a restore on all nodes ? my keyspace have no replication
> but perhaps restore need same operation on all node.
>
> I miss something, i don't know.
>
> Thanks for your help.
>
>
>

--001a1134609ca7371b04ed6de014
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">As someone told you this feature was added by Netflix to w=
ork with Priam (cassandra management tool). Priam itself uses it for severa=
l months only, so I doubt if anybody uses this feature in production. Any w=
ay, you can ping guys working on Priam. This is your best bet.<div>
<a href=3D"https://github.com/Netflix/Priam">https://github.com/Netflix/Pri=
am</a></div><div><br></div><div>Let us know if you can figure out how to us=
e it.</div><div><br></div><div>Thank you,</div><div>=A0 Andrey=A0</div></di=
v>
<div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Fri, Dec 1=
3, 2013 at 6:31 AM, Bonnet Jonathan. <span dir=3D"ltr">&lt;<a href=3D"mailt=
o:jonathan.bonnet@externe.bnpparibas.com" target=3D"_blank">jonathan.bonnet=
@externe.bnpparibas.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Hello,<br>
<br>
=A0 As i told you i began to explore restore operations, see my config for<=
br>
archive commit logs:<br>
<br>
archive_command=3D/bin/bash /produits/cassandra/scripts/cassandra-archive.s=
h<br>
%path %name<br>
<br>
restore_command=3D/bin/bash /produits/cassandra/scripts/cassandra-restore.s=
h<br>
%from %to<br>
<br>
restore_directories=3D/produits/cassandra/cassandra_data/archived_commit<br=
>
<br>
restore_point_in_time=3D2013:12:11 17:00:00<br>
<br>
My 2 scripts<br>
<br>
cassandra-archive.sh:<br>
<br>
bzip2 --best -k $1<br>
mv $1.bz2 /produits/cassandra/cassandra_data/archived_commit/$2.bz2<br>
<br>
<br>
cassandra-restore.sh:<br>
cp -f $1 $2<br>
bzip2 -d $2<br>
<br>
<br>
<br>
For an example, at 2013:12:11 17:30:00 i had truncate a table which belong<=
br>
to a keyspace with no replication on one node, after that i made a nodetool=
<br>
flush. So when i restore to 2013:12:11 17:00:00 i expect to have my table<b=
r>
bein fill up again.<br>
<br>
The node restart with this config correctly, i see my archive commit log<br=
>
come back to my commitlogdirectory, seems bizarre to me that these ones<br>
finish by *.out like CommitLog-3-1386927339271.log.out and not just .log.<b=
r>
Everything is normal ?<br>
<br>
When i query my table now, this one is still empty. Finaly my restore<br>
doesn&#39;t work and i wonder why ?<br>
<br>
Do i have to make a restore on all nodes ? my keyspace have no replication<=
br>
but perhaps restore need same operation on all node.<br>
<br>
I miss something, i don&#39;t know.<br>
<br>
Thanks for your help.<br>
<br>
<br>
</blockquote></div><br></div>

--001a1134609ca7371b04ed6de014--