Return-Path: 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 CD580D797 for ; Wed, 5 Dec 2012 18:56:40 +0000 (UTC) Received: (qmail 12107 invoked by uid 500); 5 Dec 2012 18:56:38 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 12046 invoked by uid 500); 5 Dec 2012 18:56:38 -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 12036 invoked by uid 99); 5 Dec 2012 18:56:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Dec 2012 18:56:38 +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 (athena.apache.org: domain of ailinykh@gmail.com designates 209.85.215.44 as permitted sender) Received: from [209.85.215.44] (HELO mail-la0-f44.google.com) (209.85.215.44) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Dec 2012 18:56:31 +0000 Received: by mail-la0-f44.google.com with SMTP id d3so4739502lah.31 for ; Wed, 05 Dec 2012 10:56:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=rYo7qQU9ihIlzgaJeIe5pruWVe1Lk2N7Qi+2218MgW4=; b=CzmRy58uJQ5Nrf7JIUuvLERYoLfTrMJ/pgF+mZcRFWUGkRpbF2jgP1vm8iwwXGG6Gp FpMBg6v6ZoXKYKn3xAJI6OtnuT5B49HOiCBFr7kqFDG+Hoc3ac6QJ35996TXsLLUAHPv j5EUtOttNrzSOMzjUdfSK0umBZMooErBq+pV3LccT1XRgObcO7DsT+0CSqn5LjxuOl82 Lmk83W8rCAYONFY6OoUM6N/lpmH7MQnxfzwQpbtnK7Ajs9gRtMeufKEzgrBr03ozJZKG kPOBX5QFl/T3uV/B+waG/tnqfSn5edkqBw7srvW4Bf3OzuvbU2Fw4kktZa20wE+XGBc4 XLKA== MIME-Version: 1.0 Received: by 10.112.28.98 with SMTP id a2mr7724213lbh.110.1354733770394; Wed, 05 Dec 2012 10:56:10 -0800 (PST) Received: by 10.114.28.34 with HTTP; Wed, 5 Dec 2012 10:56:10 -0800 (PST) Date: Wed, 5 Dec 2012 10:56:10 -0800 Message-ID: Subject: how to take consistant snapshot? From: Andrey Ilinykh To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=bcaec554de46264c6d04d01f89e7 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec554de46264c6d04d01f89e7 Content-Type: text/plain; charset=ISO-8859-1 Hello, everybody! I have production cluster with incremental backup on and I want to clone it (create test one). I don't understand one thing- each column family gets flushed (and copied to backup storage) independently. Which means the total snapshot is inconsistent. If I restore from such snapshot I have totally useless system. To be more specific, let's say I have two CF, one serves as an index for another. Every time I update one CF I update index CF. There is a good chance that all replicas flush index CF first. Then I move it into backup storage, restore and get CF which has pointers to non existent data in another CF. What is a way to avoid this situation? Thank you, Andrey --bcaec554de46264c6d04d01f89e7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello, everybody!
I have production cluster with=A0incremental=A0backup= on and I want to clone it (create test one). I don't understand one th= ing- each column family gets flushed (and copied to backup storage) indepen= dently. Which means the total snapshot is inconsistent. If I restore from s= uch snapshot =A0I have totally useless system. To be more specific, let'= ;s say I have two CF, one serves as an index for another. Every time I upda= te one CF I update index CF. There is a good chance that all replicas flush= index CF first. Then I move it into backup storage, restore and get CF whi= ch has pointers to non=A0existent=A0data in another CF. What is a way to av= oid this situation?

Thank you,
=A0 Andrey
--bcaec554de46264c6d04d01f89e7--