Re: Is there a way to find out if a server is part of application connection string?

2023-06-07 Thread Miles Garnsey
Could you maybe do something with the output of lsof -nPi? It'll give you open network connections across the system. You could then filter them down using grep/awk for just those accessing Cassandra's CQL port (9042 by default). On Wed, Jun 7, 2023 at 10:10 AM Surbhi Gupta wrote: > Hi, > > We

Re: Is there a way to find out if a server is part of application connection string?

2023-06-07 Thread Miklosovic, Stefan
Hi Surbhi, maybe looking into system_views.clients virtual table in case you are on a cluster of version 4.0+ would be helpful? That table contains all clients connected to that particular Cassandra node having "address" and "hostname" columns as well as "username" column. I am not sure there

Is there a way to find out if a server is part of application connection string?

2023-06-06 Thread Surbhi Gupta
Hi, We have a cluster with many applications connecting to it. We need to decommission few of the servers from the cluster . Without asking the application team, is there any way to know the ips of the application connection string? Does cassandra logs (system or debug) this information