From user-return-64127-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Sat Jun 29 03:56:11 2019 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 5AFF718062B for ; Sat, 29 Jun 2019 05:56:11 +0200 (CEST) Received: (qmail 52145 invoked by uid 500); 29 Jun 2019 03:56:06 -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 52132 invoked by uid 99); 29 Jun 2019 03:56:06 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Jun 2019 03:56:06 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id AC54DC2122 for ; Sat, 29 Jun 2019 03:56:05 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.201 X-Spam-Level: X-Spam-Status: No, score=-0.201 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, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=live.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id eBolYGMTdbVx for ; Sat, 29 Jun 2019 03:56:02 +0000 (UTC) Received: from NAM04-SN1-obe.outbound.protection.outlook.com (mail-oln040092011077.outbound.protection.outlook.com [40.92.11.77]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 2C65660DBF for ; Sat, 29 Jun 2019 03:56:02 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=live.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=JCxrDbN/Py8APHGIAunr2r5SEBiJQMnegL/EOwLhHIc=; b=Hb30r1Zvyo8xiQOJpuHXt7KZBmxR7ylzCDvxwwDtEEWA9X+GpYAFn5oUGbz98HReYOqgYPiRwNpjyyDFkLt7Vbb6uf+QAG4r1SiSDE8Hl07qOmHcbqigmaTNyy33epCIU3fO0UtIx6mbORPRBEVMcSiBqco0dNooogEMl4rFozEvz/2notLUdypUYKhvrVygcDVICQXd+qrAoCPEFoKgRZGyBkHXc6n46d+53f7uxh/mCVlgQH3fzufkME45SUt0LKhWNrFL0N6zx1M7PWaDPAXMTx4vEKMp8Kzdt96BS1nmFOZlEUwMqMGLv8FNExuCHX3FiY/rNAMo6bwAoa9/ZA== Received: from CO1NAM04FT048.eop-NAM04.prod.protection.outlook.com (10.152.90.59) by CO1NAM04HT216.eop-NAM04.prod.protection.outlook.com (10.152.91.211) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.2032.15; Sat, 29 Jun 2019 03:55:54 +0000 Received: from MN2PR07MB7133.namprd07.prod.outlook.com (10.152.90.56) by CO1NAM04FT048.mail.protection.outlook.com (10.152.91.166) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.2032.15 via Frontend Transport; Sat, 29 Jun 2019 03:55:54 +0000 Received: from MN2PR07MB7133.namprd07.prod.outlook.com ([fe80::484b:ef08:39fc:25]) by MN2PR07MB7133.namprd07.prod.outlook.com ([fe80::484b:ef08:39fc:25%3]) with mapi id 15.20.2032.018; Sat, 29 Jun 2019 03:55:54 +0000 From: Nimbus Lin To: User Subject: Re: How can I check cassandra cluster has a real working function of high availability? Thread-Topic: How can I check cassandra cluster has a real working function of high availability? Thread-Index: AQHVI3LJXvkxh5ZJYkSdNkC6YKPO66acxrg8gAKsUQCAEqLs0A== Date: Sat, 29 Jun 2019 03:55:54 +0000 Message-ID: References: , In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:2166BE53A51F5557ECEA80BF5617C403BA40FD8895492BC35BD03943E9DF62E3;UpperCasedChecksum:64DDD4EEBC01F3FB9DBD23595255EF97173C985DEA9D9D8A3C4944B3E7D058D3;SizeAsReceived:6967;Count:43 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [7MRgMdJdAeKKyM7aTFnnZP+0jgKEt7nH] x-ms-publictraffictype: Email x-incomingheadercount: 43 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(5050001)(7020095)(20181119110)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031322404)(2017031323274)(2017031324274)(1601125500)(1603101475)(1701031045);SRVR:CO1NAM04HT216; x-ms-traffictypediagnostic: CO1NAM04HT216: x-ms-exchange-purlcount: 1 x-microsoft-antispam-message-info: 1bXZssi4lTBZAfXi/Q6+9Jo89lihUFZeyTkUXY+/wTuwIOOklg6EFyau+9gqEvMhnWb1nDJOGk8ymThdrM0Jc03y3ydPEHMsg5ksUa1tYVPqoI8e7G1zIvUUy5sfCbBXk0c9d6HqwaxGFMIY/JiM2S0T1+Yohjvc37tya+GdWD1JpHlyEgbObZLY5TvrDvJN Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: live.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 0efc60f8-e0b1-45d0-a7a9-08d6fc45af6e X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Jun 2019 03:55:54.5031 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1NAM04HT216 To Sir Oleksandr :=0A= =0A= =0A= =0A= =0A= Thank you!=0A= =0A= Sincerely=0A= Nimbuslin(Lin JiaXin)=0A= Mobile: 0086 180 5986 1565=0A= Mail: jiaxinlin@live.com=0A= =0A= =0A= ________________________________________=0A= From: Oleksandr Shulgin =0A= Sent: Monday, June 17, 2019 7:19 AM=0A= To: User=0A= Subject: Re: How can I check cassandra cluster has a real working function = of high availability?=0A= =0A= On Sat, Jun 15, 2019 at 4:31 PM Nimbus Lin > wrote:=0A= Dear cassandra's pioneers:=0A= I am a 5 years' newbie, it is until now that I have time to use cassan= dra. but I cann't check cassandra's high availabily when I stop a seed node= or none seed DN as CGE or Greenplum.=0A= Would someone can tell me how to check the cassandra's high availabilit= y? even I change the consistency level from one to local_one, the cqlsh's s= elect is always return an error of NoHostAvailable.=0A= =0A= By the way, would you like to answer me other two questions:=0A= 2nd question: although cassandrfa's consistency is a per-operation setting,= isn't there a whole all operations' consistency setting method?=0A= 3rd question: how can I can cassandra cluster's running variables as mysql'= s show global variables? such as hidden variable of auto_bootstrap?=0A= =0A= Hi,=0A= =0A= For the purpose of serving client requests, all nodes are equal -- seed or = not. So it shouldn't matter which node you are stopping (or making it unav= ailable for the rest of the cluster using other means).=0A= =0A= In order to test it with cqlsh you should ensure that the replication facto= rs of the keyspace you're testing with is sufficient. Given the NoHostAvai= lable exception that you are experiencing at consistency level ONE (or LOCA= L_ONE), I can guess that you are testing with a keyspace with replication f= actor 1 and the node which is unavailable happen to be responsible for the = particular partition.=0A= =0A= For your second question: it depends on a client (or "client driver") you a= re using. In cqlsh you can set consistency level that will be applied for = all subsequent queries using the "CONSISTENCY ..." command. I think that t= he Java driver does have an option to set the default consistency level, as= well as has an option to set consistency level per query. Most likely thi= s is also true for Python and other drivers.=0A= =0A= And for the third question: I'm not aware of a CQL or nodetool command that= would fulfill the need. Most likely it is possible to learn (and update) = most of the configuration parameters using JMX, e.g. with JConsole: https:/= /docs.datastax.com/en/archived/cassandra/3.0/cassandra/operations/opsMonito= ring.html#opsMonitoringJconsole=0A= =0A= Cheers,=0A= --=0A= Alex=0A= =0A= --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org For additional commands, e-mail: user-help@cassandra.apache.org