Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id CCA7A200B61 for ; Tue, 9 Aug 2016 08:53:55 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id CB7B7160AA5; Tue, 9 Aug 2016 06:53:55 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id EB15B160AA4 for ; Tue, 9 Aug 2016 08:53:54 +0200 (CEST) Received: (qmail 94927 invoked by uid 500); 9 Aug 2016 06:53:53 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 94916 invoked by uid 99); 9 Aug 2016 06:53:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Aug 2016 06:53:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 87BD1185DDD for ; Tue, 9 Aug 2016 06:53:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.228 X-Spam-Level: X-Spam-Status: No, score=-0.228 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, RP_MATCHES_RCVD=-1.426, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id MuPGQZ-w4Kfd for ; Tue, 9 Aug 2016 06:53:50 +0000 (UTC) Received: from nm43-vm1.bullet.mail.ne1.yahoo.com (nm43-vm1.bullet.mail.ne1.yahoo.com [98.138.120.225]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 67B585FBC6 for ; Tue, 9 Aug 2016 06:53:50 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1470725624; bh=gekMXjY/LI/bhnwjuDNsrJjSwNlHiNJRqc3YeuOFHic=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=bcBWSPw7mOzHwZr4xdC6T6HvDLfyb+TQYTCKuwhGRtWkyZa8xwoQdiaBUL6cWkySzIN9+Qzd1YBaFfN9mMNER+QVY0X2sUadt6fhgGdDvP44H4ypH8/zTI+mXFXQOFppG27u358wCEBzywogUx7vWrU4ZgXBrCKBsijYNzPHZTrfvfaUV1LF3aLgb+qu+wV0qm+5Rv3aTHUq9p2JOqdiiqB9F6DwxojMccJYL5Zxn7ZBXiZIDW2K6SHLYpyOkR6dANSTFNeNXr9KbZltas5zbT6QXyttdik9uAcMcXCdwAv3r2Au7Cp0qeV69/e3ONZ9R+Y+rev4um/+D+uEeRFYog== Received: from [127.0.0.1] by nm43.bullet.mail.ne1.yahoo.com with NNFMP; 09 Aug 2016 06:53:44 -0000 Received: from [98.138.100.103] by nm43.bullet.mail.ne1.yahoo.com with NNFMP; 09 Aug 2016 06:50:45 -0000 Received: from [106.10.166.126] by tm102.bullet.mail.ne1.yahoo.com with NNFMP; 09 Aug 2016 06:50:45 -0000 Received: from [106.10.151.123] by tm15.bullet.mail.sg3.yahoo.com with NNFMP; 09 Aug 2016 06:50:44 -0000 Received: from [127.0.0.1] by omp1005.mail.sg3.yahoo.com with NNFMP; 09 Aug 2016 06:50:44 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 742461.97551.bm@omp1005.mail.sg3.yahoo.com X-YMail-OSG: mlQhjSEVM1nwWFPA2jAO8X05YiMDQbbnFzym54mOcbOcnqb6fBuywedRLMv0Avx 6ZutezbiZpWXE2LSrUmtTtLkGCaXlFnZwZ2.PjwDUboNXpc0d0ksGZ5_GFp1YQS.WX3Yu0RBIjVb wu8Il8yhSoJHPoX4KZq1FDeAXVQnfnBXAvlulEjFVeOYSB0_7v_XrrJEK1VxEcAjqhq1D7NAfogQ QegKfl3H5TLn7.QSISP3cTQz84AI1feDjbBxEYjpOW3ipUk8ius.rj8EAIZG8IU3GB31i9O5zVPS veB4Vn4nrKn1APXWLLZlE_uBivhdL.BNGsKSOztiNuKxXS2DU6iLKasYyNZCnjb6SWX81NlHODMP RzmKQKFieIeTHSenmmY5wM2n3uy9saIWqYWVhvCRBHt2S6oR5qEr8CQpF2tJM3j33tgKzIxh8CUt m7LaT6UP7i6dwdMzk6v6xAf02yF4bBq_VIdOFjQMsXxXLJjLjFR4wkofGjdW6H.rpVw3V9HPyz6f bv3Ver6fE9bwTpqxlKTTdgXSh9sfrninwZw-- Received: from jws10924.mail.sg3.yahoo.com by sendmailws113.mail.sg3.yahoo.com; Tue, 09 Aug 2016 06:50:44 +0000; 1470725444.274 Date: Tue, 9 Aug 2016 06:50:43 +0000 (UTC) From: INDRANIL BASU Reply-To: INDRANIL BASU To: "user@cassandra.apache.org" Message-ID: <1729819024.10543763.1470725443855.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: <897271456.10186638.1470655770312.JavaMail.yahoo@mail.yahoo.com> Subject: Re: Verify cassandra backup and restore in C * 2.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10543762_1315870249.1470725443851" archived-at: Tue, 09 Aug 2016 06:53:56 -0000 ------=_Part_10543762_1315870249.1470725443851 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Rajath. We have atleast 20 millions of records, so count(*) with lim= it and token is getting cumbersome. =C2=A0Yes using nodetool snapshot. I know there is a nodetool verify, but i= m using C * 2.1 Copy commands sometimes fails as well. So any better easy mechanism? =C2=A0Thanks and regards,-- Indranil Basu From: Rajath Subramanyam To: user@cassandra.apache.org; INDRANIL BASU =20 Sent: Monday, 8 August 2016 11:41 PM Subject: Re: Verify cassandra backup and restore in C * 2.1 =20 Hi Indranil,=C2=A0 One approach is to do a row count on the original source table and the tabl= e that is restored=C2=A0from backup. How are you backing up data ? I am ass= uming you are issuing snapshot commands (either incremental or otherwise). I hope this helps.=C2=A0 - Rajath ------------------------ Rajath Subramanyam On Mon, Aug 8, 2016 at 4:29 AM, INDRANIL BASU wrote= : Hello, =C2=A0=C2=A0 How can we verify that cassandra data is backed up and restore= d correctly? -- IB =20 ------=_Part_10543762_1315870249.1470725443851 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks Rajath. We h= ave atleast 20 millions of records, so count(*) with limit and token is get= ting cumbersome.
 Yes using nodetool snaps= hot. I know there is a nodetool verify, but i m using C * 2.1
Copy commands sometimes fails as well.

So any bet= ter easy mechanism?
 
Thanks and regards,
--= Indranil Basu


=
From: Rajath Subramanyam <rajath26@gmail.co= m>
To: user@cassand= ra.apache.org; INDRANIL BASU <indranil_db@yahoo.com>
Sent: Monday, 8 August 2016 11:41 PM<= br> Subject: Re: Verify ca= ssandra backup and restore in C * 2.1

Hi Indranil, 

One approach is to do a row coun= t on the original source table and the table that is restored from bac= kup. How are you backing up data ? I am assuming you are issuing snapshot c= ommands (either incremental or otherwise).

I hope this helps. 

- = Rajath

------------------------
Rajath Subramanyam


On Mon, Aug 8, 2016 = at 4:29 AM, INDRANIL BASU <indranil_db@yahoo.com> wrot= e:
Hello,

<= /div>
   How can we verify that cassandra data is backed up a= nd restored correctly?

=
-- IB




<= /div>


------=_Part_10543762_1315870249.1470725443851--