Re: Is there a way to find out if a server is part of application connection string?
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 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 somewhere? > > Application team might have different ips than seed nodes. > > Thanks in advance. > Surbhi >
Re: Is there a way to find out if a server is part of application connection string?
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 any equivalent of this in 3.11. Regards From: Surbhi Gupta Sent: Wednesday, June 7, 2023 2:10 To: user@cassandra.apache.org Subject: Is there a way to find out if a server is part of application connection string? NetApp Security WARNING: This is an external email. Do not click links or open attachments unless you recognize the sender and know the content is safe. 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 somewhere? Application team might have different ips than seed nodes. Thanks in advance. Surbhi
Is there a way to find out if a server is part of application connection string?
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 somewhere? Application team might have different ips than seed nodes. Thanks in advance. Surbhi