Return-Path: 
 <user-return-41184-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-user-archive@www.apache.org
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 5474F11091
	for <apmail-cassandra-user-archive@www.apache.org>;
 Thu, 12 Jun 2014 17:27:52 +0000 (UTC)
Received: (qmail 15835 invoked by uid 500); 12 Jun 2014 17:27:49 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 15796 invoked by uid 500); 12 Jun 2014 17:27:49 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 15788 invoked by uid 99); 12 Jun 2014 17:27:49 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2014 17:27:49 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of redmumba@gmail.com designates
 209.85.160.44 as permitted sender)
Received: from [209.85.160.44] (HELO mail-pb0-f44.google.com) (209.85.160.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2014 17:27:46 +0000
Received: by mail-pb0-f44.google.com with SMTP id md12so379869pbc.3
        for <user@cassandra.apache.org>; Thu, 12 Jun 2014 10:27:21 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=date:from:to:message-id:in-reply-to:references:subject:mime-version
         :content-type;
        bh=eHSzlw37eBZJzPdP2FkWlUCzaMYepnTr8FkwfIicsdQ=;
        b=KB/TXI4tyuiHsJmuhjIH4Nsa+TwOxXEvMKxgVNk9acJsYrSbGUW4Nkf79usrwONbu2
         APLsYrnHjMMxrbYc6fUh0/BCgJfU8+dDmK1HifMQ65SPYJu1VoCyZmWrvoMEqLm02NN+
         r0DjFGTboJOWFCtB3coeUGzsY32MCwW99wKQStvhvTlOnE+I0AM19TsCFc45RAHRi45I
         lO3AIvt47mmlhP7qXbB/mv8fS5wi71cfBhAy23bxuCJuqdhW9WLC1rixOWeMnmBCvaq4
         4u0F+wheuZcIkUNa4ZC83Cd5Rn7nLqQUvunsf+119y5sgUQzHdHUxG48A9kW4OtLr5hV
         DbGw==
X-Received: by 10.66.161.69 with SMTP id xq5mr22525858pab.62.1402594041760;
        Thu, 12 Jun 2014 10:27:21 -0700 (PDT)
Received: from amcfague-mac.local ([198.134.93.254])
        by mx.google.com with ESMTPSA id
 ak1sm81434500pbc.58.2014.06.12.10.27.19
        for <multiple recipients>
        (version=TLSv1.2 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
        Thu, 12 Jun 2014 10:27:21 -0700 (PDT)
Date: Thu, 12 Jun 2014 10:27:18 -0700
From: Andrew <redmumba@gmail.com>
To: Jack Krupansky <jack@basetechnology.com>, user@cassandra.apache.org
Message-ID: <etPan.5399e2f6.2ae8944a.6c21@amcfague-mac.local>
In-Reply-To: <2A9B7A028C604D8B906AB91BD4931B79@JackKrupansky14>
References: 
 <CAFaNLCY-zdgnTqBqX+W4pTMHVqMAiS7hSybn7fGO3BYxKAn3Yg@mail.gmail.com>
 <B8AC3052AD3DEB4A9AC2C9C81222504715D4542A@DEMUMBX003.nsn-intra.net>
 <2A9B7A028C604D8B906AB91BD4931B79@JackKrupansky14>
Subject: Re: Backup Cassandra to
X-Mailer: Airmail (237)
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="5399e2f6_625558ec_6c21"
X-Virus-Checked: Checked by ClamAV on apache.org

--5399e2f6_625558ec_6c21
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

There isn=E2=80=99t a lot of =E2=80=9Cactual documentation=E2=80=9D on th=
e act of backing up, but I did research for my own company into the act o=
f backing up and unfortunately, you=E2=80=99re not going to have a simila=
r setup as Oracle. =C2=A0There are reasons for this, however.

If you have more than one replica of the data, that means each node in th=
e cluster will likely be holding it=E2=80=99s own unique set of data. =C2=
=A0So you would need to back up the ENTIRE set of nodes in order to get a=
n accurate snapshot. =C2=A0Likewise, you would need to restore it to the =
cluster of the same size in order to restore it (and then run refresh to =
tell Cassandra to reload the tables from disk).

Copying the snapshots is easy=E2=80=94it=E2=80=99s just a bunch of files =
in your data directory. =C2=A0It=E2=80=99s even smaller if you use increm=
ental snapshots. =C2=A0I=E2=80=99ll admit, I=E2=80=99m no expert on tape =
drives, but I=E2=80=99d imagine it=E2=80=99s as easy as copy/pasting the =
snapshots to the drive (or whatever the equivalent tape drive operation i=
s).

What you (and I, admittedly) would really like to see is a way to back up=
 all the logical *data*, and then simply replay it. =C2=A0This is possibl=
e on Oracle because it=E2=80=99s typically restricted to either one (plus=
 maybe one or two standbys) that don=E2=80=99t =E2=80=9Cshare=E2=80=9D an=
y data. =C2=A0What you could do, in theory, is literally select all the d=
ata in the entire cluster and simply dump it to a file=E2=80=94but this c=
ould take hours, days, or even weeks to complete, depending on the size o=
f your data, and then simply re-load it. =C2=A0This is probably not a gre=
at solution, but hey=E2=80=94maybe it will work for you.

Netflix (thankfully) has posted a lot of their operational observations a=
nd what not, including their utility Priam. =C2=A0In their documentation,=
 they include some overviews of what they use:=C2=A0https://github.com/Ne=
tflix/Priam/wiki/Backups

Hope this helps=21

Andrew

On June 12, 2014 at 6:18:57 AM, Jack Krupansky (jack=40basetechnology.com=
) wrote:

The doc for backing up =E2=80=93 and restoring =E2=80=93 Cassandra is her=
e:
http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/=
ops=5Fbackup=5Frestore=5Fc.html
=C2=A0
That doesn=E2=80=99t tell you how to move the =E2=80=9Csnapshot=E2=80=9D =
to or from tape, but a snapshot is the starting point for backing up Cass=
andra.
=C2=A0
-- Jack Krupansky
=C2=A0
=46rom: Camacho, Maria (NSN - =46I/Espoo)
Sent: Thursday, June 12, 2014 4:57 AM
To: user=40cassandra.apache.org
Subject: Backup Cassandra to
=C2=A0
Hi there,
=C2=A0
I'm trying to find information/instructions about backing up and restorin=
g a Cassandra DB to and from a tape unit.
=C2=A0
I was hopping someone in this forum could help me with this since I could=
 not find anything useful in Google :(
=C2=A0
Thanks in advance,
Maria
=C2=A0


--5399e2f6_625558ec_6c21
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<html><head><style>body=7Bfont-family:Helvetica,Arial;font-size:13px=7D</=
style></head><body style=3D=22word-wrap: break-word; -webkit-nbsp-mode: s=
pace; -webkit-line-break: after-white-space;=22><div id=3D=22bloop=5Fcust=
omfont=22 style=3D=22font-family:Helvetica,Arial;font-size:13px; color: r=
gba(0,0,0,1.0); margin: 0px; line-height: auto;=22>There isn=E2=80=99t a =
lot of =E2=80=9Cactual documentation=E2=80=9D on the act of backing up, b=
ut I did research for my own company into the act of backing up and unfor=
tunately, you=E2=80=99re not going to have a similar setup as Oracle. &nb=
sp;There are reasons for this, however.</div><div id=3D=22bloop=5Fcustomf=
ont=22 style=3D=22font-family:Helvetica,Arial;font-size:13px; color: rgba=
(0,0,0,1.0); margin: 0px; line-height: auto;=22><br></div><div id=3D=22bl=
oop=5Fcustomfont=22 style=3D=22font-family:Helvetica,Arial;font-size:13px=
; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;=22>If you have =
more than one replica of the data, that means each node in the cluster wi=
ll likely be holding it=E2=80=99s own unique set of data. &nbsp;So you wo=
uld need to back up the ENTIRE set of nodes in order to get an accurate s=
napshot. &nbsp;Likewise, you would need to restore it to the cluster of t=
he same size in order to restore it (and then run refresh to tell Cassand=
ra to reload the tables from disk).</div><div id=3D=22bloop=5Fcustomfont=22=
 style=3D=22font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0=
,1.0); margin: 0px; line-height: auto;=22><br></div><div id=3D=22bloop=5F=
customfont=22 style=3D=22font-family:Helvetica,Arial;font-size:13px; colo=
r: rgba(0,0,0,1.0); margin: 0px; line-height: auto;=22>Copying the snapsh=
ots is easy=E2=80=94it=E2=80=99s just a bunch of files in your data direc=
tory. &nbsp;It=E2=80=99s even smaller if you use incremental snapshots. &=
nbsp;I=E2=80=99ll admit, I=E2=80=99m no expert on tape drives, but I=E2=80=
=99d imagine it=E2=80=99s as easy as copy/pasting the snapshots to the dr=
ive (or whatever the equivalent tape drive operation is).</div><div id=3D=
=22bloop=5Fcustomfont=22 style=3D=22font-family:Helvetica,Arial;font-size=
:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;=22><br></d=
iv><div id=3D=22bloop=5Fcustomfont=22 style=3D=22font-family:Helvetica,Ar=
ial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: aut=
o;=22>What you (and I, admittedly) would really like to see is a way to b=
ack up all the logical *data*, and then simply replay it. &nbsp;This is p=
ossible on Oracle because it=E2=80=99s typically restricted to either one=
 (plus maybe one or two standbys) that don=E2=80=99t =E2=80=9Cshare=E2=80=
=9D any data. &nbsp;What you could do, in theory, is literally select all=
 the data in the entire cluster and simply dump it to a file=E2=80=94but =
this could take hours, days, or even weeks to complete, depending on the =
size of your data, and then simply re-load it. &nbsp;This is probably not=
 a great solution, but hey=E2=80=94maybe it will work for you.</div><div =
id=3D=22bloop=5Fcustomfont=22 style=3D=22font-family:Helvetica,Arial;font=
-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;=22><b=
r></div><div id=3D=22bloop=5Fcustomfont=22 style=3D=22font-family:Helveti=
ca,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height=
: auto;=22>Netflix (thankfully) has posted a lot of their operational obs=
ervations and what not, including their utility Priam. &nbsp;In their doc=
umentation, they include some overviews of what they use:&nbsp;https://gi=
thub.com/Netflix/Priam/wiki/Backups</div><div id=3D=22bloop=5Fcustomfont=22=
 style=3D=22font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0=
,1.0); margin: 0px; line-height: auto;=22><br></div><div id=3D=22bloop=5F=
customfont=22 style=3D=22font-family:Helvetica,Arial;font-size:13px; colo=
r: rgba(0,0,0,1.0); margin: 0px; line-height: auto;=22>Hope this helps=21=
</div> <div id=3D=22bloop=5Fsign=5F1402593551220696832=22 class=3D=22bloo=
p=5Fsign=22><div><br></div><span style=3D=22font-family:helvetica,arial;f=
ont-size:13px=22></span>Andrew<span></span></div> <br><p style=3D=22color=
:=23000;=22>On June 12, 2014 at 6:18:57 AM, Jack Krupansky (<a href=3D=22=
mailto:jack=40basetechnology.com=22>jack=40basetechnology.com</a>) wrote:=
</p> <blockquote type=3D=22cite=22 class=3D=22clean=5Fbq=22><span><div la=
ng=3D=22EN-US=22 dir=3D=22ltr=22 link=3D=22blue=22 vlink=3D=22purple=22 x=
ml:lang=3D=22EN-US=22><div></div><div>






<title></title>


<div dir=3D=22ltr=22>
<div style=3D=22=46ONT-SIZE: 12pt; =46ONT-=46AMILY: 'Calibri'; COLOR: =23=
000000=22>
<div>The doc for backing up =E2=80=93 and restoring =E2=80=93 Cassandra i=
s
here:</div>
<div><a title=3D=22http://www.datastax.com/documentation/cassandra/2.0/ca=
ssandra/operations/ops=5Fbackup=5Frestore=5Fc.html=22 href=3D=22http://ww=
w.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops=5Fbac=
kup=5Frestore=5Fc.html=22>
http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/=
ops=5Fbackup=5Frestore=5Fc.html</a></div>
<div>&nbsp;</div>
<div>That doesn=E2=80=99t tell you how to move the =E2=80=9Csnapshot=E2=80=
=9D to or from
tape, but a snapshot is the starting point for backing up
Cassandra.</div>
<div>&nbsp;</div>
<div style=3D=22=46ONT-SIZE: 12pt; =46ONT-=46AMILY: 'Calibri'; COLOR: =23=
000000=22>-- Jack
Krupansky</div>
<div style=3D=22=46ONT-SIZE: small; TEXT-DECORATION: none; =46ONT-=46AMIL=
Y: &quot;Calibri&quot;; =46ONT-WEIGHT: normal; COLOR: =23000000; =46ONT-S=
TYLE: normal; DISPLAY: inline=22>
<div style=3D=22=46ONT: 10pt tahoma=22>
<div>&nbsp;</div>
<div style=3D=22BACKGROUND: =23f5f5f5=22>
<div style=3D=22font-color: black=22><b>=46rom:</b> <a title=3D=22maria.c=
amacho=40nsn.com=22 href=3D=22mailto:maria.camacho=40nsn.com=22>Camacho, =
Maria (NSN -
=46I/Espoo)</a></div>
<div><b>Sent:</b> Thursday, June 12, 2014 4:57 AM</div>
<div><b>To:</b> <a title=3D=22user=40cassandra.apache.org=22 href=3D=22ma=
ilto:user=40cassandra.apache.org=22>user=40cassandra.apache.org</a></div>=

<div><b>Subject:</b> Backup Cassandra to</div>
</div>
</div>
<div>&nbsp;</div>
</div>
<div style=3D=22=46ONT-SIZE: small; TEXT-DECORATION: none; =46ONT-=46AMIL=
Y: &quot;Calibri&quot;; =46ONT-WEIGHT: normal; COLOR: =23000000; =46ONT-S=
TYLE: normal; DISPLAY: inline=22>
<div class=3D=22WordSection1=22>
<div>
<div>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
<span style=3D=22=46ONT-SIZE: 10pt; =46ONT-=46AMILY: &quot;Arial&quot;,&q=
uot;sans-serif&quot;; COLOR: =23555555=22>
Hi there,</span></p>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
&nbsp;</p>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
<span style=3D=22=46ONT-SIZE: 10pt; =46ONT-=46AMILY: &quot;Arial&quot;,&q=
uot;sans-serif&quot;; COLOR: =23555555=22>
I'm trying to find information/instructions about backing up and
restoring a Cassandra DB to and from a tape unit.</span></p>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
&nbsp;</p>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
<span style=3D=22=46ONT-SIZE: 10pt; =46ONT-=46AMILY: &quot;Arial&quot;,&q=
uot;sans-serif&quot;; COLOR: =23555555=22>
I was hopping someone in this forum could help me with this since I
could not find anything useful in Google :(</span></p>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
&nbsp;</p>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
<span style=3D=22=46ONT-SIZE: 10pt; =46ONT-=46AMILY: &quot;Arial&quot;,&q=
uot;sans-serif&quot;; COLOR: =23555555=22>
Thanks in advance,</span></p>
<p class=3D=22MsoNormal=22 style=3D=22MARGIN-BOTTOM: 0pt; BACKGROUND: =23=
fff1a8; MARGIN-LE=46T: 12.55pt; MARGIN-RIGHT: 25.95pt; mso-margin-top-alt=
: 0cm=22>
<span style=3D=22=46ONT-SIZE: 10pt; =46ONT-=46AMILY: &quot;Arial&quot;,&q=
uot;sans-serif&quot;; COLOR: =23555555=22>
Maria</span></p>
<p class=3D=22MsoNormal=22>&nbsp;</p>
</div>
</div>
</div>
</div>
</div>
</div>


</div></div></span></blockquote></body></html>
--5399e2f6_625558ec_6c21--