You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "Saha, Sushanta K" <su...@verizonwireless.com> on 2021/11/19 18:12:31 UTC

Anyone connecting the Cassandra on a server

I need to shutdown an old Apache Cassandra server for good. Running 3.0.x.
Any way I can determine if anyone is still connecting to the Cassandra
instance running on this server?

Thanks
.... Sushanta

Re: [E] Re: Anyone connecting the Cassandra on a server

Posted by "Saha, Sushanta K" <su...@verizonwireless.com>.
Thanks Bowen!

.... Sushanta


On Fri, Nov 19, 2021 at 4:01 PM Bowen Song <bo...@bso.ng> wrote:

> This could be two questions with different answers:
>
>
> 1. Is there anyone / who is connected to the Cassandra server right now?
>
> Use the netstat or ss command and check the active TCP connections on
> native port (default is 9042)
>
>
> 2. Is there anyone / who is connecting to the Cassandra servers between
> now and next hour/day/week/month/etc.?
>
> Use iptables/nftables to log new TCP connections (ct state new) on that
> port
>
>
> On 19/11/2021 18:12, Saha, Sushanta K wrote:
>
> I need to shutdown an old Apache Cassandra server for good. Running 3.0.x.
> Any way I can determine if anyone is still connecting to the Cassandra
> instance running on this server?
>
> Thanks
> .... Sushanta
>
>

-- 

*Sushanta Saha|*MTS IV-Cslt-Sys Engrg|WebIaaS_DB Group|HQ -
* VerizonWireless O 770.797.1260  C 770.714.6555 Iaas Support Line
949-286-8810*

Re: Anyone connecting the Cassandra on a server

Posted by Bowen Song <bo...@bso.ng>.
This could be two questions with different answers:


1. Is there anyone / who is connected to the Cassandra server right now?

Use the netstat or ss command and check the active TCP connections on 
native port (default is 9042)


2. Is there anyone / who is connecting to the Cassandra servers between 
now and next hour/day/week/month/etc.?

Use iptables/nftables to log new TCP connections (ct state new) on that port


On 19/11/2021 18:12, Saha, Sushanta K wrote:
> I need to shutdown an old Apache Cassandra server for good. Running 
> 3.0.x. Any way I can determine if anyone is still connecting to the 
> Cassandra instance running on this server?
>
> Thanks
> .... Sushanta
>

Re: Anyone connecting the Cassandra on a server

Posted by Surbhi Gupta <su...@gmail.com>.
You can use tcpdump

On Fri, 19 Nov 2021 at 10:34, Soumya Jena <so...@gmail.com>
wrote:

> You can just do a netstat on port 9042 to see if anything connected .
>
> Something like
> netstat -anp | grep 9042 .
>
> Or you can also check for read/write client requests metrics . You can
> check if specific tables are taking read or writes .
> There is also a metrics to see number of connected clients .
> org.apache.cassandra.metrics.Client.connectedNativeClients.
>
> Hope this helps . Thanks !!
>
> On Fri, Nov 19, 2021 at 11:43 PM Saha, Sushanta K <
> sushanta.saha@verizonwireless.com> wrote:
>
>> I need to shutdown an old Apache Cassandra server for good. Running
>> 3.0.x. Any way I can determine if anyone is still connecting to the
>> Cassandra instance running on this server?
>>
>> Thanks
>> .... Sushanta
>>
>>

Re: Anyone connecting the Cassandra on a server

Posted by Soumya Jena <so...@gmail.com>.
You can just do a netstat on port 9042 to see if anything connected .

Something like
netstat -anp | grep 9042 .

Or you can also check for read/write client requests metrics . You can
check if specific tables are taking read or writes .
There is also a metrics to see number of connected clients .
org.apache.cassandra.metrics.Client.connectedNativeClients.

Hope this helps . Thanks !!

On Fri, Nov 19, 2021 at 11:43 PM Saha, Sushanta K <
sushanta.saha@verizonwireless.com> wrote:

> I need to shutdown an old Apache Cassandra server for good. Running 3.0.x.
> Any way I can determine if anyone is still connecting to the Cassandra
> instance running on this server?
>
> Thanks
> .... Sushanta
>
>

Re: [E] Re: Anyone connecting the Cassandra on a server

Posted by "Saha, Sushanta K" <su...@verizonwireless.com>.
Thanks a lot Soumya, Surbhi, and Paul. Appreciate your help!

.... Sushanta


On Fri, Nov 19, 2021 at 2:19 PM Paul Chandler <pa...@redshots.com> wrote:

> I wrote a blog post describing how to do this a few years ago:
> http://www.redshots.com/who-is-connecting-to-a-cassandra-cluster/
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.redshots.com_who-2Dis-2Dconnecting-2Dto-2Da-2Dcassandra-2Dcluster_&d=DwMFaQ&c=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ&r=JaNakyvP8b5eGvWhmxll6L4SNrrqHGq3Ghe3-Mb4Nezhm-3SiJqFhK3ICb6tsog4&m=v8A8dX7qL7P4J2FfSNDQM8X1fgwnI0CBYjENorSI5AU&s=M-qeUZejaaOBgcnSk5MMSuk9tMyI6HrTbFYZARlzUmQ&e=>
>
>
> Sent from my iPhone
>
> On 19 Nov 2021, at 18:13, Saha, Sushanta K <
> sushanta.saha@verizonwireless.com> wrote:
>
> 
> I need to shutdown an old Apache Cassandra server for good. Running 3.0.x.
> Any way I can determine if anyone is still connecting to the Cassandra
> instance running on this server?
>
> Thanks
> .... Sushanta
>
>

-- 

*Sushanta Saha|*MTS IV-Cslt-Sys Engrg|WebIaaS_DB Group|HQ -
* VerizonWireless O 770.797.1260  C 770.714.6555 Iaas Support Line
949-286-8810*

Re: Anyone connecting the Cassandra on a server

Posted by Paul Chandler <pa...@redshots.com>.
I wrote a blog post describing how to do this a few years ago: http://www.redshots.com/who-is-connecting-to-a-cassandra-cluster/


Sent from my iPhone

> On 19 Nov 2021, at 18:13, Saha, Sushanta K <su...@verizonwireless.com> wrote:
> 
> 
> I need to shutdown an old Apache Cassandra server for good. Running 3.0.x. Any way I can determine if anyone is still connecting to the Cassandra instance running on this server?
> 
> Thanks
> .... Sushanta
>