From user-return-65157-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Fri Feb 7 02:10:46 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 1607E18064E for ; Fri, 7 Feb 2020 03:10:45 +0100 (CET) Received: (qmail 14999 invoked by uid 500); 7 Feb 2020 02:10:42 -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 14988 invoked by uid 99); 7 Feb 2020 02:10:42 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Feb 2020 02:10:42 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 31A50C0826 for ; Fri, 7 Feb 2020 02:10:42 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.001 X-Spam-Level: X-Spam-Status: No, score=-0.001 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=0.2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id lyNH4jO8vjbs for ; Fri, 7 Feb 2020 02:10:41 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.166.46; helo=mail-io1-f46.google.com; envelope-from=ankitgadhiya@gmail.com; receiver= Received: from mail-io1-f46.google.com (mail-io1-f46.google.com [209.85.166.46]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id DA1B8BB805 for ; Fri, 7 Feb 2020 02:10:40 +0000 (UTC) Received: by mail-io1-f46.google.com with SMTP id s6so453630iol.9 for ; Thu, 06 Feb 2020 18:10:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=LQ00pujCFO/flJe3PED2wuSk93XmOZr3K5OHgkPTlj4=; b=CyYjQMw6xFv5+vekC6qvecQUoQPZwouW09cJ7gp31hy6qU04oQXLjPonbnO1QSFQKY RyT89UxfOkz/iMm0arEq8IeWTTp3YtFYZ4oX5mSv51LU6ru/i0hJxsD/O4LUMna8BKVX GZA/3BWcUWvqyruxLCsKIKoqzmsqAlsvVKLOba0rYbwsYq469xNjigwJvwBnlZx6M4IX r5YRlg7O1iGmKUC3O8JRVhC3jtJj5K7nQumulJzHKFb+3vlry0h8QJPQpDjF2Rf2n0Zp 4aPinNA1iJPCtTW4Gk4p2418T5uXNgqL9ZahqE3ZA8n4hP/xLBCufZryZ4zRrOSWRNDE n/qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=LQ00pujCFO/flJe3PED2wuSk93XmOZr3K5OHgkPTlj4=; b=HHKUrJmE/3heXZyIasOrcJciFvVVqRCYDmPNThaAVl/ejmIoD834Gorn7Bg+WX0UKj TL308ImyeEH1y1vj3fhakUYnxzOO6QGHhbeKQexNNvHdk+YGxGNF/qzJPKSpzXFL9B8F it4V6G40kKN9uwp6ZNgfzBWHJaDZlfBeERF4LrBtF0VYtSFgjjGDq/hlKcVNVRbmHZob TSnDY5WKO53O9HIwZSr7TGVcMzyPCdX7kLoWNLjj18VfAEBfNKOy8fmekbdQnmij65rp HVQ0JMGQc922Q1/ep3XP+RhbHcwALfLw9fOywms4nZB0m13mjVtLq+R775htqZEd0tKq Hhpw== X-Gm-Message-State: APjAAAX8+bp//GGdmiAheC717WRezxT/I3oM8m4LHaVohTVWqBKJ9Iwi O6AqUsWLNULl3YcUZMIzGoye7q9bfczcLioKUcVG2Nvk X-Google-Smtp-Source: APXvYqw2N2l3+QOjFjHqw1Nk70SnMm1SxDje97lzyS/AJlqE9uI5cOYhiiNA3q3tfhwVIOTqSaqOCkvlzm/aKNQ/Mt8= X-Received: by 2002:a92:cd52:: with SMTP id v18mr7333091ilq.134.1581041440111; Thu, 06 Feb 2020 18:10:40 -0800 (PST) MIME-Version: 1.0 References: <947fc6af-dd5e-ea68-7519-acccff1fee66@pbandjelly.org> In-Reply-To: From: Ankit Gadhiya Date: Thu, 6 Feb 2020 21:10:28 -0500 Message-ID: Subject: Re: Query timeouts after Cassandra Migration To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary="00000000000069c158059df2e5fa" --00000000000069c158059df2e5fa Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks Eric. So do you advise copying tokens in such cases ? What procedure is advisable ? Latency increased on target cluster. I=E2=80=99d double check on storage di= sks but it should be same. =E2=80=94 Ankit On Thu, Feb 6, 2020 at 9:07 PM Erick Ramirez wrote: > I didn=E2=80=99t copy tokens since it=E2=80=99s an identical cluster and = we have RF as 3 >> on 3 node cluster. Is it still needed , why? >> > > In C*, same number of nodes alone isn't enough. Clusters aren't really > identical unless token assignments are the same. In your case though sinc= e > each node has a full copy of the data (RF =3D N nodes), they "appear" > identical. > > I recently migrated Cassandra keyspace data from one Azure cluster (3 >> Nodes) to another (3 nodes different region) using simple sstable copy. >> Post this , we are observing overall response time has increased and >> timeouts every 20 mins. >> > > You mean the response time on the source cluster increased? Or the > destination cluster? I can't see how the copy could affect latency unless > you're using premium storage disks and you've maxed out the throughput on > them. For example, P30 disks are capped at 200MB/s. > > Do I need to copy anything from system* > > > No, system tables are local to a node. Only ever copy the application > keyspaces. Cheers! > --=20 *Thanks & Regards,* *Ankit Gadhiya* --00000000000069c158059df2e5fa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Eric.
So do you = advise copying tokens in such cases ? What procedure is advisable ?

Latency increased on target clu= ster. I=E2=80=99d double check on storage disks but it should be same.


= =E2=80=94 Ankit

O= n Thu, Feb 6, 2020 at 9:07 PM Erick Ramirez <flightctlr@gmail.com> wrote:
I didn=E2=80=99t copy to= kens since it=E2=80=99s an identical cluster and we have RF as 3 on 3 node = cluster. Is it still needed , why?
=C2=A0
= In C*, same number of nodes alone isn't enough. Clusters aren't rea= lly identical unless token assignments are the same. In your case though si= nce each node has a full copy of the data (RF =3D N nodes), they "appe= ar" identical.

I recently = migrated Cassandra keyspace data from one Azure cluster (3 Nodes) to anothe= r (3 nodes different region) using simple sstable copy. Post this , we are = observing overall response time has increased and timeouts every 20 mins.

=C2=A0You mean the respons= e time on the source cluster increased? Or the destination cluster? I can&#= 39;t see how the copy could affect latency unless you're using premium = storage disks and you've maxed out the throughput on them. For example,= P30 disks are capped at 200MB/s.

Do I need to copy anything from system*=C2=A0<= /blockquote>

No, system tables are local to a node. Only= ever copy the application keyspaces. Cheers!=C2=A0
--
Thanks & Regards,
Ankit Gadhiya

--00000000000069c158059df2e5fa--