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 ADC55200C31 for ; Wed, 8 Mar 2017 21:37:47 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id AC3E2160B83; Wed, 8 Mar 2017 20:37:47 +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 CDD6E160B73 for ; Wed, 8 Mar 2017 21:37:46 +0100 (CET) Received: (qmail 14771 invoked by uid 500); 8 Mar 2017 20:37:45 -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 14761 invoked by uid 99); 8 Mar 2017 20:37:45 -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; Wed, 08 Mar 2017 20:37:45 +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 DAEF3182173 for ; Wed, 8 Mar 2017 20:37:44 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.898 X-Spam-Level: * X-Spam-Status: No, score=1.898 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_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id uz8AnuWXXrKA for ; Wed, 8 Mar 2017 20:37:42 +0000 (UTC) Received: from mail-wr0-f170.google.com (mail-wr0-f170.google.com [209.85.128.170]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 5B92F5F5FD for ; Wed, 8 Mar 2017 20:37:42 +0000 (UTC) Received: by mail-wr0-f170.google.com with SMTP id l37so31641125wrc.1 for ; Wed, 08 Mar 2017 12:37:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=FoiTzGECE+Lj03uhQ0+jLHjKYrkMEvhB1AgXxJ2MbkQ=; b=q6sW4jedwJF4Cfih/7fcakaNbcQQWZW/wxh2HAT8uqF02E9QfXiGk/yqqPk+vLNChK lupdInqVsjYvvH2rk/yJLRZ0UEwv/+UYOYOwkKZCy+4AuZmJajpkrKf1CTe5AQrM95Zg BOwpRo34HpGUyWEgFTCAYjd59kmhTXdKvqq4ILFAxC+UdakVOXXCiMkUlkP0mZPJLV/j 0KAgVjGxvSnADeKD5vTR2Q9tCM4qEEn8WS7F08sS4QaRsFy3mS3UXdy4XO36vGPdUfAF mt5RzQsrDeBciOanLXK7WYt+KPgqu2T6S3C3AInUGIf6M5AycXuVnrvaAIyHvRuIPf7i 5Ebw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=FoiTzGECE+Lj03uhQ0+jLHjKYrkMEvhB1AgXxJ2MbkQ=; b=C1y81PjyOLOAdqebX0HSYQzc1Pl5Uo1DRtAiMc8Tex9mfLGjSmAOJVjXSm2KVsgkw1 itG7kfDeQYV61twPHUaQ3NV07YUOiKnQq6vRYxFeQgBQr1mNZAaSYue8xOXoqdcIIFKo CSIrRoQ3Fs6vESsmK3m3dYfo74juaDNpjORnhtiYT3k3yeTNsM+pfCrguYYT2NrUvZvY rQlRtYf774IRX8kv0NFzNaSGS+P9Yx6gdEZ6pUy5nc2CvgQTYwU89Dn2S1OQsKjXa/wz W1TtI5kqRrvgqBO1bIe7xYpF8UGCMBV9mLPRIFduYMKgw0YiRGAK4FYm1nt1XThDTsSN /stg== X-Gm-Message-State: AMke39l7AQF6Lua8+VNcwtGp//RNdakTwYXjC4T596lzVXV2SC2bniAhYZVIgd6iHI0rkR/jbPvVGZkkkDyUNA== X-Received: by 10.223.135.109 with SMTP id 42mr7889405wrz.141.1489005456192; Wed, 08 Mar 2017 12:37:36 -0800 (PST) MIME-Version: 1.0 Received: by 10.80.162.101 with HTTP; Wed, 8 Mar 2017 12:37:05 -0800 (PST) In-Reply-To: References: <0366B6DC-B8DF-460A-9506-3270A218FBBF@ancestry.com> From: daemeon reiydelle Date: Wed, 8 Mar 2017 12:37:05 -0800 Message-ID: Subject: Re: Disconnecting two data centers To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a11490fa048ffde054a3e1978 archived-at: Wed, 08 Mar 2017 20:37:47 -0000 --001a11490fa048ffde054a3e1978 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I guess it depends on the experience one has. This is a common process to bring up, move, build full prod copies, etc. What is outlined is pretty much exactly what I have done 20-50 times (too many to remember). FYI, some of this should be done with nodes DOWN. *.......* *Daemeon C.M. ReiydelleUSA (+1) 415.501.0198London (+44) (0) 20 8144 9872* On Wed, Mar 8, 2017 at 6:38 AM, Ryan Svihla wrote: > it's a bit tricky and I don't advise it, but the typical pattern is (say > you have DC1 and DC2): > > 1. partition the data centers from one another..kill the routing however > you can (firewall, etc) > 2. while partitioned log onto DC1 alter schema so that DC2 is not > replicating), repeat for other. > 2a. If using propertyfilesnitch remove the DC2 from all the DC1 property > files and vice versa > 2b. change the seeds setting in the cassandra.yaml accordingly (DC1 yaml'= s > shouldn't have any seeds from DC2, etc) > 3. rolling restart to account for this. > 4,. run repair (not even sure how necessary this step is, but after doing > RF changes I do this to prevent hiccups) > > I've done this a couple of times but really failing all of that, the more > well supported and harder to mess up but more work approach is: > > 1. Set DC2 to RF 0 > 2. remove all nodes from DC2 > 3. change yamls for seed files (update property file if need be) > 4. create new cluster in DC2, > 5. use sstableloader to stream DC1 data to DC2. > > On Wed, Mar 8, 2017 at 8:13 AM, Chuck Reynolds > wrote: > >> I=E2=80=99m running C* 2.1.13 and I have two rings that are replicating = data from >> our data center to one in AWS. >> >> >> >> We would like to keep both of them for a while but we have a need to >> disconnect them. How can this be done? >> > > > > -- > > Thanks, > Ryan Svihla > > --001a11490fa048ffde054a3e1978 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I guess it depends on the experience o= ne has. This is a common process to bring up, move, build full prod copies,= etc.

What is outlined is pretty much exac= tly what I have done 20-50 times (too many to remember).

FYI, some of this should be done with nodes DOWN.


=

Daemeon C.M. Reiydelle
USA (+1) 4= 15.501.0198
London (+44) (0) 20 8144 9872

On Wed, Mar 8, 2017 at 6:38 AM, Ryan Svihla = <r= s@foundev.pro> wrote:
it's a bit tricky and I don't advise it, but the typica= l pattern is (say you have DC1 and DC2):

1. partition th= e data centers from one another..kill the routing however you can (firewall= , etc)
2. while partitioned log onto DC1 alter schema so that DC2= is not replicating), repeat for other.
2a. If using propertyfile= snitch remove the DC2 from all the DC1 property files and vice versa
<= div>2b. change the seeds setting in the cassandra.yaml accordingly (DC1 yam= l's shouldn't have any seeds from DC2, etc)
3. rolling re= start to account for this.
4,. run repair (not even sure how nece= ssary this step is, but after doing RF changes I do this to prevent hiccups= )

I've done this a couple of times but really = failing all of that, the more well supported and harder to mess up but more= work approach is:

1. Set DC2 to RF 0
2.= remove all nodes from DC2
3. change yamls for seed files (update= property file if need be)
4. create new cluster in DC2,
5. use sstableloader to stream DC1 data to DC2.

On Wed, Mar 8, 2017 = at 8:13 AM, Chuck Reynolds <creynolds@ancestry.com> wro= te:

I=E2=80=99m running= C* 2.1.13 and I have two rings that are replicating data from our data cen= ter to one in AWS.=C2=A0

=C2=A0

We would like to ke= ep both of them for a while but we have a need to disconnect them.=C2=A0 Ho= w can this be done?




--

Thanks,

Ryan Svihla


--001a11490fa048ffde054a3e1978--