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 9D04EE37E for ; Fri, 22 Feb 2013 17:01:32 +0000 (UTC) Received: (qmail 26851 invoked by uid 500); 22 Feb 2013 17:01:30 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 26818 invoked by uid 500); 22 Feb 2013 17:01:30 -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 26807 invoked by uid 99); 22 Feb 2013 17:01:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Feb 2013 17:01:30 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.174.58.134] (HELO XEDGEA.nrel.gov) (192.174.58.134) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Feb 2013 17:01:23 +0000 Received: from XHUBA.nrel.gov (10.20.4.58) by XEDGEA.nrel.gov (192.174.58.134) with Microsoft SMTP Server (TLS) id 8.3.245.1; Fri, 22 Feb 2013 10:00:59 -0700 Received: from MAILBOX2.nrel.gov ([fe80::19a0:6c19:6421:12f]) by XHUBA.nrel.gov ([::1]) with mapi; Fri, 22 Feb 2013 10:01:02 -0700 From: "Hiller, Dean" To: "user@cassandra.apache.org" Date: Fri, 22 Feb 2013 10:01:08 -0700 Subject: is there a way to drain node(and prevent reads) and upgrade sstables offline? Thread-Topic: is there a way to drain node(and prevent reads) and upgrade sstables offline? Thread-Index: Ac4RHjFEJUzjhZ1XQjaBPbxXlN6szQ== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.5.121010 acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org We would like to take a node out of the ring and upgradesstables while it i= s not doing any writes nor reads with the ring. Is this possible? I am thinking from the documentation 1. nodetool drain 2. ANYTHING to stop reads here???? 3. Modify cassandra.yaml with compaction_throughput_mb_per_sec =3D 0 and = multithreaded_compaction =3D true temporarily 4. Restart cassandra and run nodetool upgradesstables keyspace CF 5. Modify cassandra.yaml to revert changes 6. Restart cassandra to join the cluster again. Is this how it should be done? Thanks, Dean