Re: Testing Cassandra connectivity at application startup

2023-08-25 Thread Raphael Mazelier
Mind that a new connection is really costly for C*. So at startup it's fine. but not in a liveness or readiness check imo. For the query why not select 1; ? -- Raphael Mazelier On 25/08/2023 19:38, Shaurya Gupta wrote: > Hi community > > We want to validate cassandra connecti

Re: Testing Cassandra connectivity at application startup

2023-08-25 Thread Raphael Mazelier
That's a good way to it! On 25/08/2023 20:10, Shaurya Gupta wrote: > We don't plan to open a new connection. It should use the same connection(s) > which the application will use. > > On Fri, Aug 25, 2023 at 10:59 AM Raphael Mazelier wrote: > >> Mind that a new connec

Re: Local read request going across DC

2022-09-21 Thread Raphael Mazelier
% of the queries. read_repair is set to 0. I follow this thread with interest. C* version is 3.11.4. -- Raphael Mazelier On 21/09/2022 09:23, Erick Ramirez wrote: Would you be open to temporarily posting the full CQL command + full trace output to gist.github.com <http://gist.github.com>? I'

Understanding multi region read query and latency

2022-08-05 Thread Raphael Mazelier
ted. Best, -- Raphael Mazelier 1659724153007200197 [Info] before query Aug 05 2022 06:29:13.229 [INFO] main.go:18 - Tracing session 81281b0014ec11ed8fd10f5c2d1a52b5 (coordinator: 10.66.111.13, duration: 0s): Aug 05 2022 06:29:13.231 [INFO] main.go:18 - 2022/08/05 18:29:13.008: reading digest from /10.

Re: Understanding multi region read query and latency

2022-08-06 Thread Raphael Mazelier
Well answering to myself this is not related to read_repair chance. Settings them to 0 change also nothing. So the question remains: why from time to time C* want to make multiple read on a non local dc ? On 06/08/2022 12:31, Raphael Mazelier wrote: Well I tried (but already have some

Re: Understanding multi region read query and latency

2022-08-06 Thread Raphael Mazelier
? -- Raphael Mazelier On 05/08/2022 23:13, Jim Shaw wrote: I remember gocql.DataCentreHostFilter was used.  try add it to see whether will read local DC only in your case ? Thanks, James On Fri, Aug 5, 2022 at 2:40 PM Raphael Mazelier wrote: Hi Cassandra Users, I'm relatively new

Re: Understanding multi region read query and latency

2022-08-07 Thread Raphael Mazelier
Is there some GC which could affect coordinarir node ? Kind regards Stéphane Le dim. 7 août 2022, 13:41, Raphael Mazelier a écrit : Thanks for the answer but I was well aware of this. I use localOne as consistency level. My client connect to a local seeds, then choose a local coordinator

Re: Understanding multi region read query and latency

2022-08-07 Thread Raphael Mazelier
obabilistic from the server side to catch a slow query in the act - that will help identify what’s happening. - Scott On Aug 7, 2022, at 10:25 AM, Raphael Mazelier wrote:  Nope. And what really puzzle me is in the trace we really show the difference between queries. The fast queries only reques