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 DA59710CAB for ; Tue, 15 Sep 2015 05:51:29 +0000 (UTC) Received: (qmail 54957 invoked by uid 500); 15 Sep 2015 05:51:16 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 54917 invoked by uid 500); 15 Sep 2015 05:51:16 -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 54904 invoked by uid 99); 15 Sep 2015 05:51:16 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Sep 2015 05:51:16 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 6CA3C1A1A75 for ; Tue, 15 Sep 2015 05:51:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.099 X-Spam-Level: X-Spam-Status: No, score=-0.099 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id xwN6TH0y34-G for ; Tue, 15 Sep 2015 05:51:03 +0000 (UTC) Received: from mail-yk0-f178.google.com (mail-yk0-f178.google.com [209.85.160.178]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 9DB5A4414C for ; Tue, 15 Sep 2015 05:51:03 +0000 (UTC) Received: by ykft14 with SMTP id t14so23303485ykf.0 for ; Mon, 14 Sep 2015 22:51:03 -0700 (PDT) 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=qX1YxYryxsq5c+KmQKrzAcbSE2Dj5DwNEh9BGpht6+w=; b=SaNe4IamD7NQMhygxeizGwQCOMFmYIkrpDxWoVoVAFtuBMy0DjAYiS8EwGumHDefSZ T8Q3mUG5eibvuJrOOJ/s8xqMKZJrnEfueIcpJMl4D2Jlc9EkiUKf26T7SDUyin+MYfcI pWT6tLb/hB7CUE4DTxTeic9HxO5bAa+jdkLuj7ZIj37Z+bCYMEPNugIGLZHELEfbeUC6 N8kdM40AqDhGuv+2T9TdrTZegVfmCwo/pPB+FdZ/hizeKvQfJiVMsj5QbknqYTIEmQQ7 4/qolzpuKtmk+VbWSzb7WSwARMNdsw4EzjpS44fCqiFA9FGelbeC80BDLY+km7ExZR6P CWtA== MIME-Version: 1.0 X-Received: by 10.170.69.66 with SMTP id l63mr18771294ykl.89.1442296263390; Mon, 14 Sep 2015 22:51:03 -0700 (PDT) Received: by 10.13.232.150 with HTTP; Mon, 14 Sep 2015 22:51:03 -0700 (PDT) Date: Tue, 15 Sep 2015 11:21:03 +0530 Message-ID: Subject: Possible to restore ENTIRE data from Cassandra-Schema in one go? From: Ajay Garg To: user@cassandra.apache.org Content-Type: text/plain; charset=UTF-8 Hi All. We have a schema on one Cassandra-node, and wish to duplicate the entire schema on another server. Think of this a 2 clusters, each cluster containing one node. We have found the way to dump/restore schema-metainfo at :: https://dzone.com/articles/dumpingloading-schema And dumping/restoring data at :: http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_backup_takes_snapshot_t.html http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_backup_snapshot_restore_t.html For the restoring data step, it seems that restoring every "table" requires a dedicated step. So, if the schema has 100 "tables", we would need 100 steps. Is it so? If yes, can the entire data be dumped/restored in one go? Just asking, to save time, if it could :) Thanks and Regards, Ajay